[Home] [Help]
40: l_dummy NUMBER;
41:
42:
43: BEGIN
44: -- Standard Start of API savepoint
45: SAVEPOINT CREATE_Upgrade_Track_Error_PVT;
46:
47: -- Initialize message list if p_init_msg_list is set to TRUE.
48: IF FND_API.to_Boolean( p_init_msg_list )
66: --
67: -- End of API body
68: --
69:
70: -- Standard check for p_commit
71: IF FND_API.to_Boolean( p_commit )
72: THEN
73: COMMIT WORK;
74: END IF;
73: COMMIT WORK;
74: END IF;
75:
76:
77: -- Standard call to get message count and if count is 1, get message info.
78: FND_MSG_PUB.Count_And_Get
79: (p_count => x_msg_count,
80: p_data => x_msg_data
81: );
83:
84: WHEN FND_API.G_EXC_ERROR THEN
85: ROLLBACK TO CREATE_Upgrade_Track_Error_PVT;
86: x_return_status := FND_API.G_RET_STS_ERROR;
87: -- Standard call to get message count and if count=1, get the message
88: FND_MSG_PUB.Count_And_Get (
89: p_encoded => FND_API.G_FALSE,
90: p_count => x_msg_count,
91: p_data => x_msg_data
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95: ROLLBACK TO CREATE_Upgrade_Track_Error_PVT;
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: -- Standard call to get message count and if count=1, get the message
98: FND_MSG_PUB.Count_And_Get (
99: p_encoded => FND_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data
107: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
108: THEN
109: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
110: END IF;
111: -- Standard call to get message count and if count=1, get the message
112: FND_MSG_PUB.Count_And_Get (
113: p_encoded => FND_API.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data
136: l_tar_upgrade_track_error_rec AMS_Upgrade_Track_Error_PVT.upgrade_track_error_rec_type := P_upgrade_track_error_rec;
137: l_rowid ROWID;
138:
139: BEGIN
140: -- Standard Start of API savepoint
141: SAVEPOINT UPDATE_Upgrade_Track_Error_PVT;
142:
143:
144: -- Initialize message list if p_init_msg_list is set to TRUE.
165: --
166: -- End of API body.
167: --
168:
169: -- Standard check for p_commit
170: IF FND_API.to_Boolean( p_commit )
171: THEN
172: COMMIT WORK;
173: END IF;
172: COMMIT WORK;
173: END IF;
174:
175:
176: -- Standard call to get message count and if count is 1, get message info.
177: FND_MSG_PUB.Count_And_Get
178: (p_count => x_msg_count,
179: p_data => x_msg_data
180: );
182:
183: WHEN FND_API.G_EXC_ERROR THEN
184: ROLLBACK TO UPDATE_Upgrade_Track_Error_PVT;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (
188: p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: ROLLBACK TO UPDATE_Upgrade_Track_Error_PVT;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: -- Standard call to get message count and if count=1, get the message
197: FND_MSG_PUB.Count_And_Get (
198: p_encoded => FND_API.G_FALSE,
199: p_count => x_msg_count,
200: p_data => x_msg_data
206: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
207: THEN
208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
209: END IF;
210: -- Standard call to get message count and if count=1, get the message
211: FND_MSG_PUB.Count_And_Get (
212: p_encoded => FND_API.G_FALSE,
213: p_count => x_msg_count,
214: p_data => x_msg_data
233: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
234: l_object_version_number NUMBER;
235:
236: BEGIN
237: -- Standard Start of API savepoint
238: SAVEPOINT DELETE_Upgrade_Track_Error_PVT;
239:
240: -- Initialize message list if p_init_msg_list is set to TRUE.
241: IF FND_API.to_Boolean( p_init_msg_list )
257: --
258: -- End of API body
259: --
260:
261: -- Standard check for p_commit
262: IF FND_API.to_Boolean( p_commit )
263: THEN
264: COMMIT WORK;
265: END IF;
264: COMMIT WORK;
265: END IF;
266:
267:
268: -- Standard call to get message count and if count is 1, get message info.
269: FND_MSG_PUB.Count_And_Get
270: (p_count => x_msg_count,
271: p_data => x_msg_data
272: );
274:
275: WHEN FND_API.G_EXC_ERROR THEN
276: ROLLBACK TO DELETE_Upgrade_Track_Error_PVT;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: -- Standard call to get message count and if count=1, get the message
279: FND_MSG_PUB.Count_And_Get (
280: p_encoded => FND_API.G_FALSE,
281: p_count => x_msg_count,
282: p_data => x_msg_data
284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: ROLLBACK TO DELETE_Upgrade_Track_Error_PVT;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,
292: p_data => x_msg_data
298: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
299: THEN
300: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
301: END IF;
302: -- Standard call to get message count and if count=1, get the message
303: FND_MSG_PUB.Count_And_Get (
304: p_encoded => FND_API.G_FALSE,
305: p_count => x_msg_count,
306: p_data => x_msg_data