[Home] [Help]
55: FROM AMS_IMP_SOURCE_LINES
56: WHERE IMPORT_SOURCE_LINE_ID = l_id;
57:
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT CREATE_Is_Line_PVT;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT CREATE_Is_Line_PVT;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
64: p_api_version_number,
65: l_api_name,
66: G_PKG_NAME)
445: --
446: -- End of API body
447: --
448:
449: -- Standard check for p_commit
450: IF FND_API.to_Boolean( p_commit )
451: THEN
452: COMMIT WORK;
453: END IF;
458:
459: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
460: END IF;
461:
462: -- Standard call to get message count and if count is 1, get message info.
463: FND_MSG_PUB.Count_And_Get
464: (p_count => x_msg_count,
465: p_data => x_msg_data
466: );
472:
473: WHEN FND_API.G_EXC_ERROR THEN
474: ROLLBACK TO CREATE_Is_Line_PVT;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: -- Standard call to get message count and if count=1, get the message
477: FND_MSG_PUB.Count_And_Get (
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO CREATE_Is_Line_PVT;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: -- Standard call to get message count and if count=1, get the message
487: FND_MSG_PUB.Count_And_Get (
488: p_encoded => FND_API.G_FALSE,
489: p_count => x_msg_count,
490: p_data => x_msg_data
496: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
497: THEN
498: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
499: END IF;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (
502: p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data
544: l_batchId NUMBER;
545: l_user_status_id NUMBER;
546:
547: BEGIN
548: -- Standard Start of API savepoint
549: SAVEPOINT UPDATE_Is_Line_PVT;
550:
551: -- Standard call to check for call compatibility.
552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
547: BEGIN
548: -- Standard Start of API savepoint
549: SAVEPOINT UPDATE_Is_Line_PVT;
550:
551: -- Standard call to check for call compatibility.
552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
553: p_api_version_number,
554: l_api_name,
555: G_PKG_NAME)
984: --
985: -- End of API body.
986: --
987:
988: -- Standard check for p_commit
989: IF FND_API.to_Boolean( p_commit )
990: THEN
991: COMMIT WORK;
992: END IF;
997:
998: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
999: END IF;
1000:
1001: -- Standard call to get message count and if count is 1, get message info.
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );
1011:
1012: WHEN FND_API.G_EXC_ERROR THEN
1013: ROLLBACK TO UPDATE_Is_Line_PVT;
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: -- Standard call to get message count and if count=1, get the message
1016: FND_MSG_PUB.Count_And_Get (
1017: p_encoded => FND_API.G_FALSE,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1021:
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023: ROLLBACK TO UPDATE_Is_Line_PVT;
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: -- Standard call to get message count and if count=1, get the message
1026: FND_MSG_PUB.Count_And_Get (
1027: p_encoded => FND_API.G_FALSE,
1028: p_count => x_msg_count,
1029: p_data => x_msg_data
1035: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1036: THEN
1037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1038: END IF;
1039: -- Standard call to get message count and if count=1, get the message
1040: FND_MSG_PUB.Count_And_Get (
1041: p_encoded => FND_API.G_FALSE,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data
1062: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1063: l_object_version_number NUMBER;
1064:
1065: BEGIN
1066: -- Standard Start of API savepoint
1067: SAVEPOINT DELETE_Is_Line_PVT;
1068:
1069: -- Standard call to check for call compatibility.
1070: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1065: BEGIN
1066: -- Standard Start of API savepoint
1067: SAVEPOINT DELETE_Is_Line_PVT;
1068:
1069: -- Standard call to check for call compatibility.
1070: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1071: p_api_version_number,
1072: l_api_name,
1073: G_PKG_NAME)
1106: --
1107: -- End of API body
1108: --
1109:
1110: -- Standard check for p_commit
1111: IF FND_API.to_Boolean( p_commit )
1112: THEN
1113: COMMIT WORK;
1114: END IF;
1119:
1120: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1121: END IF;
1122:
1123: -- Standard call to get message count and if count is 1, get message info.
1124: FND_MSG_PUB.Count_And_Get
1125: (p_count => x_msg_count,
1126: p_data => x_msg_data
1127: );
1133:
1134: WHEN FND_API.G_EXC_ERROR THEN
1135: ROLLBACK TO DELETE_Is_Line_PVT;
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137: -- Standard call to get message count and if count=1, get the message
1138: FND_MSG_PUB.Count_And_Get (
1139: p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data
1143:
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: ROLLBACK TO DELETE_Is_Line_PVT;
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: -- Standard call to get message count and if count=1, get the message
1148: FND_MSG_PUB.Count_And_Get (
1149: p_encoded => FND_API.G_FALSE,
1150: p_count => x_msg_count,
1151: p_data => x_msg_data
1157: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1158: THEN
1159: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1160: END IF;
1161: -- Standard call to get message count and if count=1, get the message
1162: FND_MSG_PUB.Count_And_Get (
1163: p_encoded => FND_API.G_FALSE,
1164: p_count => x_msg_count,
1165: p_data => x_msg_data
1207: THEN
1208: FND_MSG_PUB.initialize;
1209: END IF;
1210:
1211: -- Standard call to check for call compatibility.
1212: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1213: p_api_version_number,
1214: l_api_name,
1215: G_PKG_NAME)
1263:
1264: WHEN FND_API.G_EXC_ERROR THEN
1265: ROLLBACK TO LOCK_Is_Line_PVT;
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267: -- Standard call to get message count and if count=1, get the message
1268: FND_MSG_PUB.Count_And_Get (
1269: p_encoded => FND_API.G_FALSE,
1270: p_count => x_msg_count,
1271: p_data => x_msg_data
1273:
1274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1275: ROLLBACK TO LOCK_Is_Line_PVT;
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: -- Standard call to get message count and if count=1, get the message
1278: FND_MSG_PUB.Count_And_Get (
1279: p_encoded => FND_API.G_FALSE,
1280: p_count => x_msg_count,
1281: p_data => x_msg_data
1287: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1288: THEN
1289: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1290: END IF;
1291: -- Standard call to get message count and if count=1, get the message
1292: FND_MSG_PUB.Count_And_Get (
1293: p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data
3010: l_object_version_number NUMBER;
3011: l_is_line_rec AMS_Is_Line_PVT.is_line_rec_type;
3012:
3013: BEGIN
3014: -- Standard Start of API savepoint
3015: SAVEPOINT VALIDATE_Is_Line_;
3016:
3017: -- Standard call to check for call compatibility.
3018: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3013: BEGIN
3014: -- Standard Start of API savepoint
3015: SAVEPOINT VALIDATE_Is_Line_;
3016:
3017: -- Standard call to check for call compatibility.
3018: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3019: p_api_version_number,
3020: l_api_name,
3021: G_PKG_NAME)
3080:
3081: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3082: END IF;
3083:
3084: -- Standard call to get message count and if count is 1, get message info.
3085: FND_MSG_PUB.Count_And_Get
3086: (p_count => x_msg_count,
3087: p_data => x_msg_data
3088: );
3094:
3095: WHEN FND_API.G_EXC_ERROR THEN
3096: ROLLBACK TO VALIDATE_Is_Line_;
3097: x_return_status := FND_API.G_RET_STS_ERROR;
3098: -- Standard call to get message count and if count=1, get the message
3099: FND_MSG_PUB.Count_And_Get (
3100: p_encoded => FND_API.G_FALSE,
3101: p_count => x_msg_count,
3102: p_data => x_msg_data
3104:
3105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3106: ROLLBACK TO VALIDATE_Is_Line_;
3107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3108: -- Standard call to get message count and if count=1, get the message
3109: FND_MSG_PUB.Count_And_Get (
3110: p_encoded => FND_API.G_FALSE,
3111: p_count => x_msg_count,
3112: p_data => x_msg_data
3118: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3119: THEN
3120: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3121: END IF;
3122: -- Standard call to get message count and if count=1, get the message
3123: FND_MSG_PUB.Count_And_Get (
3124: p_encoded => FND_API.G_FALSE,
3125: p_count => x_msg_count,
3126: p_data => x_msg_data
3156: IF (AMS_DEBUG_HIGH_ON) THEN
3157:
3158: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
3159: END IF;
3160: -- Standard call to get message count and if count is 1, get message info.
3161: FND_MSG_PUB.Count_And_Get
3162: (p_count => x_msg_count,
3163: p_data => x_msg_data
3164: );