DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_VALUE_PVT dependencies on FND_MSG_PUB

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

26: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28:
29:
30: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
31: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
32: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
33:
34: PROCEDURE Complete_dm_target_value_Rec (

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

27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28:
29:
30: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
31: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
32: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
33:
34: PROCEDURE Complete_dm_target_value_Rec (
35: p_dm_target_value_rec IN dm_target_value_rec_type,

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

28:
29:
30: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
31: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
32: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
33:
34: PROCEDURE Complete_dm_target_value_Rec (
35: p_dm_target_value_rec IN dm_target_value_rec_type,
36: x_complete_rec OUT NOCOPY dm_target_value_rec_type

Line 99: FND_MSG_PUB.initialize;

95:
96: -- Initialize message list if p_init_msg_list is set to TRUE.
97: IF FND_API.to_Boolean( p_init_msg_list )
98: THEN
99: FND_MSG_PUB.initialize;
100: END IF;
101:
102: -- Debug Message
103: IF (AMS_DEBUG_HIGH_ON) THEN

Line 234: FND_MSG_PUB.Count_And_Get

230: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
231: END IF;
232:
233: -- Standard call to get message count and if count is 1, get message info.
234: FND_MSG_PUB.Count_And_Get
235: (p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238: EXCEPTION

Line 248: FND_MSG_PUB.Count_And_Get (

244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO CREATE_Dm_Target_Value_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
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 258: FND_MSG_PUB.Count_And_Get (

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

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

263:
264: WHEN OTHERS THEN
265: ROLLBACK TO CREATE_Dm_Target_Value_PVT;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
268: THEN
269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message

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

265: ROLLBACK TO CREATE_Dm_Target_Value_PVT;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
268: THEN
269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,

Line 272: FND_MSG_PUB.Count_And_Get (

268: THEN
269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data
276: );

Line 335: FND_MSG_PUB.initialize;

331:
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF FND_API.to_Boolean( p_init_msg_list )
334: THEN
335: FND_MSG_PUB.initialize;
336: END IF;
337:
338:
339: -- Initialize API return status to SUCCESS

Line 461: FND_MSG_PUB.Count_And_Get

457: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
458: END IF;
459:
460: -- Standard call to get message count and if count is 1, get message info.
461: FND_MSG_PUB.Count_And_Get
462: (p_count => x_msg_count,
463: p_data => x_msg_data
464: );
465: EXCEPTION

Line 475: FND_MSG_PUB.Count_And_Get (

471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO UPDATE_Dm_Target_Value_PVT;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: -- Standard call to get message count and if count=1, get the message
475: FND_MSG_PUB.Count_And_Get (
476: p_encoded => FND_API.G_FALSE,
477: p_count => x_msg_count,
478: p_data => x_msg_data
479: );

Line 485: FND_MSG_PUB.Count_And_Get (

481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO UPDATE_Dm_Target_Value_PVT;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: -- Standard call to get message count and if count=1, get the message
485: FND_MSG_PUB.Count_And_Get (
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data
489: );

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

490:
491: WHEN OTHERS THEN
492: ROLLBACK TO UPDATE_Dm_Target_Value_PVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message

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

492: ROLLBACK TO UPDATE_Dm_Target_Value_PVT;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,

Line 499: FND_MSG_PUB.Count_And_Get (

495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data
503: );

Line 620: FND_MSG_PUB.initialize;

616:
617: -- Initialize message list if p_init_msg_list is set to TRUE.
618: IF FND_API.to_Boolean( p_init_msg_list )
619: THEN
620: FND_MSG_PUB.initialize;
621: END IF;
622:
623: -- Debug Message
624: IF (AMS_DEBUG_HIGH_ON) THEN

Line 713: FND_MSG_PUB.Count_And_Get

709: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
710: END IF;
711:
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get
714: (p_count => x_msg_count,
715: p_data => x_msg_data
716: );
717: EXCEPTION

Line 727: FND_MSG_PUB.Count_And_Get (

723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO DELETE_Dm_Target_Value_PVT;
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: -- Standard call to get message count and if count=1, get the message
727: FND_MSG_PUB.Count_And_Get (
728: p_encoded => FND_API.G_FALSE,
729: p_count => x_msg_count,
730: p_data => x_msg_data
731: );

Line 737: FND_MSG_PUB.Count_And_Get (

733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
734: ROLLBACK TO DELETE_Dm_Target_Value_PVT;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: -- Standard call to get message count and if count=1, get the message
737: FND_MSG_PUB.Count_And_Get (
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data
741: );

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

742:
743: WHEN OTHERS THEN
744: ROLLBACK TO DELETE_Dm_Target_Value_PVT;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
747: THEN
748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
749: END IF;
750: -- Standard call to get message count and if count=1, get the message

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

744: ROLLBACK TO DELETE_Dm_Target_Value_PVT;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
747: THEN
748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
749: END IF;
750: -- Standard call to get message count and if count=1, get the message
751: FND_MSG_PUB.Count_And_Get (
752: p_encoded => FND_API.G_FALSE,

Line 751: FND_MSG_PUB.Count_And_Get (

747: THEN
748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
749: END IF;
750: -- Standard call to get message count and if count=1, get the message
751: FND_MSG_PUB.Count_And_Get (
752: p_encoded => FND_API.G_FALSE,
753: p_count => x_msg_count,
754: p_data => x_msg_data
755: );

Line 797: FND_MSG_PUB.initialize;

793:
794: -- Initialize message list if p_init_msg_list is set to TRUE.
795: IF FND_API.to_Boolean( p_init_msg_list )
796: THEN
797: FND_MSG_PUB.initialize;
798: END IF;
799:
800: -- Standard call to check for call compatibility.
801: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

825: FETCH c_Dm_Target_Value INTO l_TARGET_VALUE_ID;
826:
827: IF (c_Dm_Target_Value%NOTFOUND) THEN
828: CLOSE c_Dm_Target_Value;
829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
830: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
831: FND_MSG_PUB.add;
832: END IF;
833: RAISE FND_API.g_exc_error;

Line 831: FND_MSG_PUB.add;

827: IF (c_Dm_Target_Value%NOTFOUND) THEN
828: CLOSE c_Dm_Target_Value;
829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
830: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
831: FND_MSG_PUB.add;
832: END IF;
833: RAISE FND_API.g_exc_error;
834: END IF;
835:

Line 839: FND_MSG_PUB.count_and_get(

835:
836: CLOSE c_Dm_Target_Value;
837:
838: -------------------- finish --------------------------
839: FND_MSG_PUB.count_and_get(
840: p_encoded => FND_API.g_false,
841: p_count => x_msg_count,
842: p_data => x_msg_data);
843: IF (AMS_DEBUG_HIGH_ON) THEN

Line 857: FND_MSG_PUB.Count_And_Get (

853: WHEN FND_API.G_EXC_ERROR THEN
854: ROLLBACK TO LOCK_Dm_Target_Value_PVT;
855: x_return_status := FND_API.G_RET_STS_ERROR;
856: -- Standard call to get message count and if count=1, get the message
857: FND_MSG_PUB.Count_And_Get (
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data
861: );

Line 867: FND_MSG_PUB.Count_And_Get (

863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO LOCK_Dm_Target_Value_PVT;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: -- Standard call to get message count and if count=1, get the message
867: FND_MSG_PUB.Count_And_Get (
868: p_encoded => FND_API.G_FALSE,
869: p_count => x_msg_count,
870: p_data => x_msg_data
871: );

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

872:
873: WHEN OTHERS THEN
874: ROLLBACK TO LOCK_Dm_Target_Value_PVT;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877: THEN
878: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
879: END IF;
880: -- Standard call to get message count and if count=1, get the message

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

874: ROLLBACK TO LOCK_Dm_Target_Value_PVT;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877: THEN
878: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
879: END IF;
880: -- Standard call to get message count and if count=1, get the message
881: FND_MSG_PUB.Count_And_Get (
882: p_encoded => FND_API.G_FALSE,

Line 881: FND_MSG_PUB.Count_And_Get (

877: THEN
878: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
879: END IF;
880: -- Standard call to get message count and if count=1, get the message
881: FND_MSG_PUB.Count_And_Get (
882: p_encoded => FND_API.G_FALSE,
883: p_count => x_msg_count,
884: p_data => x_msg_data
885: );

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

1088: p_lookup_type => 'AMS_DM_TARGET_OPERATORS',
1089: p_lookup_code => p_dm_target_value_rec.target_operator
1090: ) = FND_API.g_false
1091: THEN
1092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1093: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1094: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_target_value_rec.target_operator);
1095: FND_MESSAGE.set_token ('COLUMN_NAME', 'TARGET_OPERATOR');
1096: FND_MSG_PUB.add;

Line 1096: FND_MSG_PUB.add;

1092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1093: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1094: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_target_value_rec.target_operator);
1095: FND_MESSAGE.set_token ('COLUMN_NAME', 'TARGET_OPERATOR');
1096: FND_MSG_PUB.add;
1097: END IF;
1098: x_return_status := FND_API.g_ret_sts_error;
1099: END IF;
1100: END IF;

Line 1264: FND_MSG_PUB.initialize;

1260:
1261: -- Initialize message list if p_init_msg_list is set to TRUE.
1262: IF FND_API.to_Boolean( p_init_msg_list )
1263: THEN
1264: FND_MSG_PUB.initialize;
1265: END IF;
1266: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1267: Check_dm_target_value_Items(
1268: p_dm_target_value_rec => p_dm_target_value_rec,

Line 1315: FND_MSG_PUB.Count_And_Get

1311: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1312: END IF;
1313:
1314: -- Standard call to get message count and if count is 1, get message info.
1315: FND_MSG_PUB.Count_And_Get
1316: (p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );
1319: EXCEPTION

Line 1329: FND_MSG_PUB.Count_And_Get (

1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO VALIDATE_Dm_Target_Value_;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: -- Standard call to get message count and if count=1, get the message
1329: FND_MSG_PUB.Count_And_Get (
1330: p_encoded => FND_API.G_FALSE,
1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1333: );

Line 1339: FND_MSG_PUB.Count_And_Get (

1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: ROLLBACK TO VALIDATE_Dm_Target_Value_;
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: -- Standard call to get message count and if count=1, get the message
1339: FND_MSG_PUB.Count_And_Get (
1340: p_encoded => FND_API.G_FALSE,
1341: p_count => x_msg_count,
1342: p_data => x_msg_data
1343: );

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

1344:
1345: WHEN OTHERS THEN
1346: ROLLBACK TO VALIDATE_Dm_Target_Value_;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message

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

1346: ROLLBACK TO VALIDATE_Dm_Target_Value_;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,

Line 1353: FND_MSG_PUB.Count_And_Get (

1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1355: p_count => x_msg_count,
1356: p_data => x_msg_data
1357: );

Line 1390: FND_MSG_PUB.initialize;

1386:
1387: -- Initialize message list if p_init_msg_list is set to TRUE.
1388: IF FND_API.to_Boolean( p_init_msg_list )
1389: THEN
1390: FND_MSG_PUB.initialize;
1391: END IF;
1392:
1393: -- Initialize API return status to SUCCESS
1394: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1458: FND_MSG_PUB.Count_And_Get

1454: END IF;
1455: -- end add rosharma 28-Nov-2002
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_value_Rec;