DBA Data[Home] [Help]

APPS.PV_GE_CHKLST_RESP_PVT dependencies on FND_MSG_PUB

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

69: --
70: -- End of Comments
71: -- ==============================================================================
72:
73: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
74: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
75: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
76:
77: PROCEDURE Create_Ge_Chklst_Resp(

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

70: -- End of Comments
71: -- ==============================================================================
72:
73: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
74: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
75: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
76:
77: PROCEDURE Create_Ge_Chklst_Resp(
78: p_api_version_number IN NUMBER,

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

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

Line 128: FND_MSG_PUB.initialize;

124:
125: -- Initialize message list if p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )
127: THEN
128: FND_MSG_PUB.initialize;
129: END IF;
130:
131:
132:

Line 259: FND_MSG_PUB.Count_And_Get

255: END IF;
256:
257:
258: -- Standard call to get message count and if count is 1, get message info.
259: FND_MSG_PUB.Count_And_Get
260: (p_count => x_msg_count,
261: p_data => x_msg_data
262: );
263: EXCEPTION

Line 273: FND_MSG_PUB.Count_And_Get (

269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data
277: );

Line 283: FND_MSG_PUB.Count_And_Get (

279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: -- Standard call to get message count and if count=1, get the message
283: FND_MSG_PUB.Count_And_Get (
284: p_encoded => FND_API.G_FALSE,
285: p_count => x_msg_count,
286: p_data => x_msg_data
287: );

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

288:
289: WHEN OTHERS THEN
290: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
293: THEN
294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
295: END IF;
296: -- Standard call to get message count and if count=1, get the message

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

290: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
293: THEN
294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
295: END IF;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get (
298: p_encoded => FND_API.G_FALSE,

Line 297: FND_MSG_PUB.Count_And_Get (

293: THEN
294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
295: END IF;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get (
298: p_encoded => FND_API.G_FALSE,
299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );

Line 387: FND_MSG_PUB.initialize;

383:
384: -- Initialize message list if p_init_msg_list is set to TRUE.
385: IF FND_API.to_Boolean( p_init_msg_list )
386: THEN
387: FND_MSG_PUB.initialize;
388: END IF;
389:
390:
391:

Line 469: --IF (PV_DEBUG_HIGH_ON) THENPVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;

465: END IF;
466:
467:
468: -- Debug Message
469: --IF (PV_DEBUG_HIGH_ON) THENPVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
470:
471: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Update_Row)
472: Pv_Ge_Chklst_Resp_Pkg.Update_Row(
473: p_chklst_response_id => p_ge_chklst_resp_rec.chklst_response_id,

Line 502: FND_MSG_PUB.Count_And_Get

498: END IF;
499:
500:
501: -- Standard call to get message count and if count is 1, get message info.
502: FND_MSG_PUB.Count_And_Get
503: (p_count => x_msg_count,
504: p_data => x_msg_data
505: );
506: EXCEPTION

Line 516: FND_MSG_PUB.Count_And_Get (

512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );

Line 526: FND_MSG_PUB.Count_And_Get (

522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );

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

531:
532: WHEN OTHERS THEN
533: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
536: THEN
537: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
538: END IF;
539: -- Standard call to get message count and if count=1, get the message

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

533: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
536: THEN
537: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
538: END IF;
539: -- Standard call to get message count and if count=1, get the message
540: FND_MSG_PUB.Count_And_Get (
541: p_encoded => FND_API.G_FALSE,

Line 540: FND_MSG_PUB.Count_And_Get (

536: THEN
537: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
538: END IF;
539: -- Standard call to get message count and if count=1, get the message
540: FND_MSG_PUB.Count_And_Get (
541: p_encoded => FND_API.G_FALSE,
542: p_count => x_msg_count,
543: p_data => x_msg_data
544: );

Line 616: FND_MSG_PUB.initialize;

612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614: IF FND_API.to_Boolean( p_init_msg_list )
615: THEN
616: FND_MSG_PUB.initialize;
617: END IF;
618:
619:
620:

Line 664: FND_MSG_PUB.Count_And_Get

660: END IF;
661:
662:
663: -- Standard call to get message count and if count is 1, get message info.
664: FND_MSG_PUB.Count_And_Get
665: (p_count => x_msg_count,
666: p_data => x_msg_data
667: );
668: EXCEPTION

Line 678: FND_MSG_PUB.Count_And_Get (

674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: -- Standard call to get message count and if count=1, get the message
678: FND_MSG_PUB.Count_And_Get (
679: p_encoded => FND_API.G_FALSE,
680: p_count => x_msg_count,
681: p_data => x_msg_data
682: );

Line 688: FND_MSG_PUB.Count_And_Get (

684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: -- Standard call to get message count and if count=1, get the message
688: FND_MSG_PUB.Count_And_Get (
689: p_encoded => FND_API.G_FALSE,
690: p_count => x_msg_count,
691: p_data => x_msg_data
692: );

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

693:
694: WHEN OTHERS THEN
695: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
698: THEN
699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
700: END IF;
701: -- Standard call to get message count and if count=1, get the message

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

695: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
698: THEN
699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
700: END IF;
701: -- Standard call to get message count and if count=1, get the message
702: FND_MSG_PUB.Count_And_Get (
703: p_encoded => FND_API.G_FALSE,

Line 702: FND_MSG_PUB.Count_And_Get (

698: THEN
699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
700: END IF;
701: -- Standard call to get message count and if count=1, get the message
702: FND_MSG_PUB.Count_And_Get (
703: p_encoded => FND_API.G_FALSE,
704: p_count => x_msg_count,
705: p_data => x_msg_data
706: );

Line 775: FND_MSG_PUB.initialize;

771:
772: -- Initialize message list if p_init_msg_list is set to TRUE.
773: IF FND_API.to_Boolean( p_init_msg_list )
774: THEN
775: FND_MSG_PUB.initialize;
776: END IF;
777:
778:
779:

Line 800: FND_MSG_PUB.count_and_get(

796: Pv_Ge_Chklst_Resp_Pkg.Lock_Row(l_chklst_response_id,p_object_version);
797:
798:
799: -------------------- finish --------------------------
800: FND_MSG_PUB.count_and_get(
801: p_encoded => FND_API.g_false,
802: p_count => x_msg_count,
803: p_data => x_msg_data);
804: IF (PV_DEBUG_HIGH_ON) THEN

Line 818: FND_MSG_PUB.Count_And_Get (

814: WHEN FND_API.G_EXC_ERROR THEN
815: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: -- Standard call to get message count and if count=1, get the message
818: FND_MSG_PUB.Count_And_Get (
819: p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data
822: );

Line 828: FND_MSG_PUB.Count_And_Get (

824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: -- Standard call to get message count and if count=1, get the message
828: FND_MSG_PUB.Count_And_Get (
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data
832: );

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

833:
834: WHEN OTHERS THEN
835: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
838: THEN
839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
840: END IF;
841: -- Standard call to get message count and if count=1, get the message

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

835: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
838: THEN
839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
840: END IF;
841: -- Standard call to get message count and if count=1, get the message
842: FND_MSG_PUB.Count_And_Get (
843: p_encoded => FND_API.G_FALSE,

Line 842: FND_MSG_PUB.Count_And_Get (

838: THEN
839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
840: END IF;
841: -- Standard call to get message count and if count=1, get the message
842: FND_MSG_PUB.Count_And_Get (
843: p_encoded => FND_API.G_FALSE,
844: p_count => x_msg_count,
845: p_data => x_msg_data
846: );

Line 1183: FND_MSG_PUB.initialize;

1179:
1180: -- Initialize message list if p_init_msg_list is set to TRUE.
1181: IF FND_API.to_Boolean( p_init_msg_list )
1182: THEN
1183: FND_MSG_PUB.initialize;
1184: END IF;
1185:
1186:
1187: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1251: FND_MSG_PUB.Count_And_Get

1247: END IF;
1248:
1249:
1250: -- Standard call to get message count and if count is 1, get message info.
1251: FND_MSG_PUB.Count_And_Get
1252: (p_count => x_msg_count,
1253: p_data => x_msg_data
1254: );
1255: EXCEPTION

Line 1265: FND_MSG_PUB.Count_And_Get (

1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_msg_count,
1268: p_data => x_msg_data
1269: );

Line 1275: FND_MSG_PUB.Count_And_Get (

1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1272: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: -- Standard call to get message count and if count=1, get the message
1275: FND_MSG_PUB.Count_And_Get (
1276: p_encoded => FND_API.G_FALSE,
1277: p_count => x_msg_count,
1278: p_data => x_msg_data
1279: );

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

1280:
1281: WHEN OTHERS THEN
1282: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1285: THEN
1286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1287: END IF;
1288: -- Standard call to get message count and if count=1, get the message

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

1282: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1285: THEN
1286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1287: END IF;
1288: -- Standard call to get message count and if count=1, get the message
1289: FND_MSG_PUB.Count_And_Get (
1290: p_encoded => FND_API.G_FALSE,

Line 1289: FND_MSG_PUB.Count_And_Get (

1285: THEN
1286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1287: END IF;
1288: -- Standard call to get message count and if count=1, get the message
1289: FND_MSG_PUB.Count_And_Get (
1290: p_encoded => FND_API.G_FALSE,
1291: p_count => x_msg_count,
1292: p_data => x_msg_data
1293: );

Line 1310: FND_MSG_PUB.initialize;

1306: BEGIN
1307: -- Initialize message list if p_init_msg_list is set to TRUE.
1308: IF FND_API.to_Boolean( p_init_msg_list )
1309: THEN
1310: FND_MSG_PUB.initialize;
1311: END IF;
1312:
1313:
1314:

Line 1329: FND_MSG_PUB.Count_And_Get

1325:
1326: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1327: END IF;
1328: -- Standard call to get message count and if count is 1, get message info.
1329: FND_MSG_PUB.Count_And_Get
1330: (p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );
1333: END Validate_ge_chklst_resp_Rec;

Line 1363: FND_MSG_PUB.initialize;

1359:
1360: -- Initialize message list if p_init_msg_list is set to TRUE.
1361: IF FND_API.to_Boolean( p_init_msg_list )
1362: THEN
1363: FND_MSG_PUB.initialize;
1364: END IF;
1365:
1366: -- Initialize API return status to SUCCESS
1367: x_return_status := FND_API.G_RET_STS_SUCCESS;