DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_PVT dependencies on FND_MSG_PUB

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

23: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25:
26:
27: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE Complete_dm_target_Rec (

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

24: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25:
26:
27: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE Complete_dm_target_Rec (
32: p_dm_target_rec IN dm_target_rec_type,

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

25:
26:
27: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE Complete_dm_target_Rec (
32: p_dm_target_rec IN dm_target_rec_type,
33: x_complete_rec OUT NOCOPY dm_target_rec_type

Line 87: FND_MSG_PUB.initialize;

83:
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list )
86: THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Debug Message
91: IF (AMS_DEBUG_HIGH_ON) THEN

Line 210: FND_MSG_PUB.Count_And_Get

206: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
207: END IF;
208:
209: -- Standard call to get message count and if count is 1, get message info.
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count,
212: p_data => x_msg_data
213: );
214: EXCEPTION

Line 224: FND_MSG_PUB.Count_And_Get (

220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO CREATE_Dmtarget_PVT;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: -- Standard call to get message count and if count=1, get the message
224: FND_MSG_PUB.Count_And_Get (
225: p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data
228: );

Line 234: FND_MSG_PUB.Count_And_Get (

230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: ROLLBACK TO CREATE_Dmtarget_PVT;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: -- Standard call to get message count and if count=1, get the message
234: FND_MSG_PUB.Count_And_Get (
235: p_encoded => FND_API.G_FALSE,
236: p_count => x_msg_count,
237: p_data => x_msg_data
238: );

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

239:
240: WHEN OTHERS THEN
241: ROLLBACK TO CREATE_Dmtarget_PVT;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
244: THEN
245: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
246: END IF;
247: -- Standard call to get message count and if count=1, get the message

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

241: ROLLBACK TO CREATE_Dmtarget_PVT;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
244: THEN
245: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
246: END IF;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE,

Line 248: FND_MSG_PUB.Count_And_Get (

244: THEN
245: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
246: END IF;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE,
250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );

Line 303: FND_MSG_PUB.initialize;

299:
300: -- Initialize message list if p_init_msg_list is set to TRUE.
301: IF FND_API.to_Boolean( p_init_msg_list )
302: THEN
303: FND_MSG_PUB.initialize;
304: END IF;
305:
306: -- Debug Message
307: IF (AMS_DEBUG_HIGH_ON) THEN

Line 484: FND_MSG_PUB.Count_And_Get

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

Line 498: FND_MSG_PUB.Count_And_Get (

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

Line 508: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 522: FND_MSG_PUB.Count_And_Get (

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

Line 587: FND_MSG_PUB.initialize;

583:
584: -- Initialize message list if p_init_msg_list is set to TRUE.
585: IF FND_API.to_Boolean( p_init_msg_list )
586: THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589:
590: -- Debug Message
591: IF (AMS_DEBUG_HIGH_ON) THEN

Line 696: FND_MSG_PUB.Count_And_Get

692: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
693: END IF;
694:
695: -- Standard call to get message count and if count is 1, get message info.
696: FND_MSG_PUB.Count_And_Get
697: (p_count => x_msg_count,
698: p_data => x_msg_data
699: );
700: EXCEPTION

Line 710: FND_MSG_PUB.Count_And_Get (

706: WHEN FND_API.G_EXC_ERROR THEN
707: ROLLBACK TO DELETE_Dmtarget_PVT;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: -- Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data
714: );

Line 720: FND_MSG_PUB.Count_And_Get (

716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
717: ROLLBACK TO DELETE_Dmtarget_PVT;
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: -- Standard call to get message count and if count=1, get the message
720: FND_MSG_PUB.Count_And_Get (
721: p_encoded => FND_API.G_FALSE,
722: p_count => x_msg_count,
723: p_data => x_msg_data
724: );

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

725:
726: WHEN OTHERS THEN
727: ROLLBACK TO DELETE_Dmtarget_PVT;
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
732: END IF;
733: -- Standard call to get message count and if count=1, get the message

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

727: ROLLBACK TO DELETE_Dmtarget_PVT;
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN
731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
732: END IF;
733: -- Standard call to get message count and if count=1, get the message
734: FND_MSG_PUB.Count_And_Get (
735: p_encoded => FND_API.G_FALSE,

Line 734: FND_MSG_PUB.Count_And_Get (

730: THEN
731: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
732: END IF;
733: -- Standard call to get message count and if count=1, get the message
734: FND_MSG_PUB.Count_And_Get (
735: p_encoded => FND_API.G_FALSE,
736: p_count => x_msg_count,
737: p_data => x_msg_data
738: );

Line 780: FND_MSG_PUB.initialize;

776:
777: -- Initialize message list if p_init_msg_list is set to TRUE.
778: IF FND_API.to_Boolean( p_init_msg_list )
779: THEN
780: FND_MSG_PUB.initialize;
781: END IF;
782:
783: -- Standard call to check for call compatibility.
784: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

808: FETCH c_Dmtarget INTO l_TARGET_ID;
809:
810: IF (c_Dmtarget%NOTFOUND) THEN
811: CLOSE c_Dmtarget;
812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
813: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
814: FND_MSG_PUB.add;
815: END IF;
816: RAISE FND_API.g_exc_error;

Line 814: FND_MSG_PUB.add;

810: IF (c_Dmtarget%NOTFOUND) THEN
811: CLOSE c_Dmtarget;
812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
813: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
814: FND_MSG_PUB.add;
815: END IF;
816: RAISE FND_API.g_exc_error;
817: END IF;
818:

Line 822: FND_MSG_PUB.count_and_get(

818:
819: CLOSE c_Dmtarget;
820:
821: -------------------- finish --------------------------
822: FND_MSG_PUB.count_and_get(
823: p_encoded => FND_API.g_false,
824: p_count => x_msg_count,
825: p_data => x_msg_data);
826: IF (AMS_DEBUG_HIGH_ON) THEN

Line 840: FND_MSG_PUB.Count_And_Get (

836: WHEN FND_API.G_EXC_ERROR THEN
837: ROLLBACK TO LOCK_Dmtarget_PVT;
838: x_return_status := FND_API.G_RET_STS_ERROR;
839: -- Standard call to get message count and if count=1, get the message
840: FND_MSG_PUB.Count_And_Get (
841: p_encoded => FND_API.G_FALSE,
842: p_count => x_msg_count,
843: p_data => x_msg_data
844: );

Line 850: FND_MSG_PUB.Count_And_Get (

846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: ROLLBACK TO LOCK_Dmtarget_PVT;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: -- Standard call to get message count and if count=1, get the message
850: FND_MSG_PUB.Count_And_Get (
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data
854: );

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

855:
856: WHEN OTHERS THEN
857: ROLLBACK TO LOCK_Dmtarget_PVT;
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
862: END IF;
863: -- Standard call to get message count and if count=1, get the message

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

857: ROLLBACK TO LOCK_Dmtarget_PVT;
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
862: END IF;
863: -- Standard call to get message count and if count=1, get the message
864: FND_MSG_PUB.Count_And_Get (
865: p_encoded => FND_API.G_FALSE,

Line 864: FND_MSG_PUB.Count_And_Get (

860: THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
862: END IF;
863: -- Standard call to get message count and if count=1, get the message
864: FND_MSG_PUB.Count_And_Get (
865: p_encoded => FND_API.G_FALSE,
866: p_count => x_msg_count,
867: p_data => x_msg_data
868: );

Line 1140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1136: p_lookup_type => 'AMS_DM_MODEL_TYPE',
1137: p_lookup_code => p_dm_target_rec.model_type
1138: ) = FND_API.g_false
1139: THEN
1140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1141: THEN
1142: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1143: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_target_rec.model_type);
1144: FND_MESSAGE.set_token ('COLUMN_NAME', 'MODEL_TYPE');

Line 1145: FND_MSG_PUB.add;

1141: THEN
1142: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1143: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_target_rec.model_type);
1144: FND_MESSAGE.set_token ('COLUMN_NAME', 'MODEL_TYPE');
1145: FND_MSG_PUB.add;
1146: END IF;
1147:
1148: x_return_status := FND_API.g_ret_sts_error;
1149: END IF;

Line 1336: FND_MSG_PUB.initialize;

1332:
1333: -- Initialize message list if p_init_msg_list is set to TRUE.
1334: IF FND_API.to_Boolean( p_init_msg_list )
1335: THEN
1336: FND_MSG_PUB.initialize;
1337: END IF;
1338:
1339: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1340: Check_dm_target_Items(

Line 1381: FND_MSG_PUB.Count_And_Get

1377: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1378: END IF;
1379:
1380: -- Standard call to get message count and if count is 1, get message info.
1381: FND_MSG_PUB.Count_And_Get
1382: (p_count => x_msg_count,
1383: p_data => x_msg_data
1384: );
1385: EXCEPTION

Line 1395: FND_MSG_PUB.Count_And_Get (

1391: WHEN FND_API.G_EXC_ERROR THEN
1392: ROLLBACK TO VALIDATE_Dmtarget_;
1393: x_return_status := FND_API.G_RET_STS_ERROR;
1394: -- Standard call to get message count and if count=1, get the message
1395: FND_MSG_PUB.Count_And_Get (
1396: p_encoded => FND_API.G_FALSE,
1397: p_count => x_msg_count,
1398: p_data => x_msg_data
1399: );

Line 1405: FND_MSG_PUB.Count_And_Get (

1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402: ROLLBACK TO VALIDATE_Dmtarget_;
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: -- Standard call to get message count and if count=1, get the message
1405: FND_MSG_PUB.Count_And_Get (
1406: p_encoded => FND_API.G_FALSE,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data
1409: );

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

1410:
1411: WHEN OTHERS THEN
1412: ROLLBACK TO VALIDATE_Dmtarget_;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1415: THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1417: END IF;
1418: -- Standard call to get message count and if count=1, get the message

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

1412: ROLLBACK TO VALIDATE_Dmtarget_;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1415: THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1417: END IF;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,

Line 1419: FND_MSG_PUB.Count_And_Get (

1415: THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1417: END IF;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data
1423: );

Line 1446: FND_MSG_PUB.initialize;

1442:
1443: -- Initialize message list if p_init_msg_list is set to TRUE.
1444: IF FND_API.to_Boolean( p_init_msg_list )
1445: THEN
1446: FND_MSG_PUB.initialize;
1447: END IF;
1448:
1449: -- Initialize API return status to SUCCESS
1450: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1458: FND_MSG_PUB.Count_And_Get

1454: -- THEN
1455: -- x_return_status := FND_API.G_RET_STS_ERROR;
1456:
1457: -- Standard call to get message count and if count is 1, get message info.
1458: FND_MSG_PUB.Count_And_Get
1459: (p_count => x_msg_count,
1460: p_data => x_msg_data
1461: );
1462: END Validate_dm_target_Rec;