eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_UPGRADE_TRACK_ERROR_PVT dependencies on FND_API

Line 24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

20:
21: -- Hint: Primary key needs to be returned.
22: PROCEDURE Create_Upgrade_Track_Error(
23: p_api_version_number IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,

Line 25: p_commit IN VARCHAR2 := FND_API.G_FALSE,

21: -- Hint: Primary key needs to be returned.
22: PROCEDURE Create_Upgrade_Track_Error(
23: p_api_version_number IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2,

Line 26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

22: PROCEDURE Create_Upgrade_Track_Error(
23: p_api_version_number IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2,
30:

Line 39: l_org_id NUMBER := FND_API.G_MISS_NUM;

35: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Upgrade_Track_Error';
36: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
37: l_return_status_full VARCHAR2(1);
38: l_object_version_number NUMBER := 1;
39: l_org_id NUMBER := FND_API.G_MISS_NUM;
40: l_dummy NUMBER;
41:
42:
43: BEGIN

Line 48: IF FND_API.to_Boolean( p_init_msg_list )

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 )
49: THEN
50: FND_MSG_PUB.initialize;
51: END IF;
52:

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: p_language => p_upgrade_track_error_rec.language,
61: p_error_message => p_upgrade_track_error_rec.error_message,
62: p_proposed_action => p_upgrade_track_error_rec.proposed_action);
63:
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: --
67: -- End of API body
68: --

Line 71: IF FND_API.to_Boolean( p_commit )

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;
75:

Line 84: WHEN FND_API.G_EXC_ERROR THEN

80: p_data => x_msg_data
81: );
82: EXCEPTION
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 (

Line 86: x_return_status := FND_API.G_RET_STS_ERROR;

82: EXCEPTION
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,

Line 89: p_encoded => FND_API.G_FALSE,

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
92: );
93:

Line 94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

90: p_count => x_msg_count,
91: p_data => x_msg_data
92: );
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 (

Line 96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

92: );
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,

Line 99: p_encoded => FND_API.G_FALSE,

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
102: );
103:

Line 106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

102: );
103:
104: WHEN OTHERS THEN
105: ROLLBACK TO CREATE_Upgrade_Track_Error_PVT;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 113: p_encoded => FND_API.G_FALSE,

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
116: );
117: End Create_Upgrade_Track_Error;

Line 122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

118:
119:
120: PROCEDURE Update_Upgrade_Track_Error(
121: p_api_version_number IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_upgrade_track_error_rec IN upgrade_track_error_rec_type,
126: x_return_status OUT NOCOPY VARCHAR2,

Line 123: p_commit IN VARCHAR2 := FND_API.G_FALSE,

119:
120: PROCEDURE Update_Upgrade_Track_Error(
121: p_api_version_number IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_upgrade_track_error_rec IN upgrade_track_error_rec_type,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,

Line 124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

120: PROCEDURE Update_Upgrade_Track_Error(
121: p_api_version_number IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_upgrade_track_error_rec IN upgrade_track_error_rec_type,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2

Line 145: IF FND_API.to_Boolean( p_init_msg_list )

141: SAVEPOINT UPDATE_Upgrade_Track_Error_PVT;
142:
143:
144: -- Initialize message list if p_init_msg_list is set to TRUE.
145: IF FND_API.to_Boolean( p_init_msg_list )
146: THEN
147: FND_MSG_PUB.initialize;
148: END IF;
149:

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148: END IF;
149:
150:
151: -- Initialize API return status to SUCCESS
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154:
155: -- Invoke table handler(AMS_UPGRADE_TRACK_ERROR_PKG.Update_Row)
156: AMS_UPGRADE_TRACK_ERROR_PKG.Update_Row(

Line 170: IF FND_API.to_Boolean( p_commit )

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;
174:

Line 183: WHEN FND_API.G_EXC_ERROR THEN

179: p_data => x_msg_data
180: );
181: EXCEPTION
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 (

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

181: EXCEPTION
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,

Line 188: p_encoded => FND_API.G_FALSE,

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
191: );
192:

Line 193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

189: p_count => x_msg_count,
190: p_data => x_msg_data
191: );
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 (

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: );
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,

Line 198: p_encoded => FND_API.G_FALSE,

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
201: );
202:

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

201: );
202:
203: WHEN OTHERS THEN
204: ROLLBACK TO UPDATE_Upgrade_Track_Error_PVT;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 212: p_encoded => FND_API.G_FALSE,

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
215: );
216: End Update_Upgrade_Track_Error;

Line 221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

217:
218:
219: PROCEDURE Delete_Upgrade_Track_Error(
220: p_api_version_number IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,

Line 222: p_commit IN VARCHAR2 := FND_API.G_FALSE,

218:
219: PROCEDURE Delete_Upgrade_Track_Error(
220: p_api_version_number IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,

Line 223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

219: PROCEDURE Delete_Upgrade_Track_Error(
220: p_api_version_number IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_object_code IN Number,

Line 241: IF FND_API.to_Boolean( p_init_msg_list )

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 )
242: THEN
243: FND_MSG_PUB.initialize;
244: END IF;
245:

Line 247: x_return_status := FND_API.G_RET_STS_SUCCESS;

243: FND_MSG_PUB.initialize;
244: END IF;
245:
246: -- Initialize API return status to SUCCESS
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248:
249: --
250: -- Api body
251: --

Line 262: IF FND_API.to_Boolean( p_commit )

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;
266:

Line 275: WHEN FND_API.G_EXC_ERROR THEN

271: p_data => x_msg_data
272: );
273: EXCEPTION
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 (

Line 277: x_return_status := FND_API.G_RET_STS_ERROR;

273: EXCEPTION
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,

Line 280: p_encoded => FND_API.G_FALSE,

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
283: );
284:

Line 285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

281: p_count => x_msg_count,
282: p_data => x_msg_data
283: );
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 (

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283: );
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,

Line 290: p_encoded => FND_API.G_FALSE,

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
293: );
294:

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

293: );
294:
295: WHEN OTHERS THEN
296: ROLLBACK TO DELETE_Upgrade_Track_Error_PVT;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 304: p_encoded => FND_API.G_FALSE,

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
307: );
308: End Delete_Upgrade_Track_Error;