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_ITEM_SECTION_PVT dependencies on FND_API

Line 20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

16:
17: PROCEDURE create_item_sec_assoc
18: (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
23:
24: x_return_status OUT VARCHAR2,

Line 21: p_commit IN VARCHAR2 := FND_API.g_false,

17: PROCEDURE create_item_sec_assoc
18: (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
23:
24: x_return_status OUT VARCHAR2,
25: x_msg_count OUT NUMBER,

Line 22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

18: (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
23:
24: x_return_status OUT VARCHAR2,
25: x_msg_count OUT NUMBER,
26: x_msg_data OUT VARCHAR2,

Line 61: IF NOT FND_API.Compatible_API_Call ( l_api_version,

57: -- Standard Start of API savepoint
58: SAVEPOINT Create_Item_Sec_Assoc;
59:
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version,
62: p_api_version,
63: l_api_name,
64: G_PKG_NAME)
65: THEN

Line 66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

62: p_api_version,
63: l_api_name,
64: G_PKG_NAME)
65: THEN
66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )

Line 70: IF FND_API.to_Boolean( p_init_msg_list )

66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
77:
78:
79: -- Initialize API return status to SUCCESS
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82:
83: -- ******************************************************************
84: -- Validate Environment

Line 93: RAISE FND_API.G_EXC_ERROR;

89: THEN
90: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
91: FND_MSG_PUB.ADD;
92: END IF;
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:
96:
97: l_section_id_tbl := JTF_NUMBER_TABLE(1);

Line 134: IF x_return_status =FND_API.G_RET_STS_UNEXP_ERROR

130: , x_msg_count => x_msg_count
131: , x_msg_data => x_msg_data
132: );
133:
134: IF x_return_status =FND_API.G_RET_STS_UNEXP_ERROR
135: THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137:
138: ELSIF x_return_status =FND_API.G_RET_STS_ERROR

Line 136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

132: );
133:
134: IF x_return_status =FND_API.G_RET_STS_UNEXP_ERROR
135: THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137:
138: ELSIF x_return_status =FND_API.G_RET_STS_ERROR
139: OR l_dup_return_status =FND_API.G_RET_STS_ERROR
140: THEN

Line 138: ELSIF x_return_status =FND_API.G_RET_STS_ERROR

134: IF x_return_status =FND_API.G_RET_STS_UNEXP_ERROR
135: THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137:
138: ELSIF x_return_status =FND_API.G_RET_STS_ERROR
139: OR l_dup_return_status =FND_API.G_RET_STS_ERROR
140: THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;

Line 139: OR l_dup_return_status =FND_API.G_RET_STS_ERROR

135: THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137:
138: ELSIF x_return_status =FND_API.G_RET_STS_ERROR
139: OR l_dup_return_status =FND_API.G_RET_STS_ERROR
140: THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;
143:

Line 141: RAISE FND_API.G_EXC_ERROR;

137:
138: ELSIF x_return_status =FND_API.G_RET_STS_ERROR
139: OR l_dup_return_status =FND_API.G_RET_STS_ERROR
140: THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;
143:
144:
145: -- Standard check for p_commit

Line 146: IF FND_API.to_Boolean( p_commit )

142: END IF;
143:
144:
145: -- Standard check for p_commit
146: IF FND_API.to_Boolean( p_commit )
147: THEN
148: COMMIT WORK;
149: END IF;
150:

Line 161: WHEN FND_API.G_EXC_ERROR THEN

157: (p_count => x_msg_count,
158: p_data => x_msg_data
159: );
160: EXCEPTION
161: WHEN FND_API.G_EXC_ERROR THEN
162: ROLLBACK TO Create_Item_Sec_Assoc;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: -- Standard call to get message count and if count=1, get the message
165: FND_MSG_PUB.Count_And_Get (

Line 163: x_return_status := FND_API.G_RET_STS_ERROR;

159: );
160: EXCEPTION
161: WHEN FND_API.G_EXC_ERROR THEN
162: ROLLBACK TO Create_Item_Sec_Assoc;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: -- Standard call to get message count and if count=1, get the message
165: FND_MSG_PUB.Count_And_Get (
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,

Line 166: p_encoded => FND_API.G_FALSE,

162: ROLLBACK TO Create_Item_Sec_Assoc;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: -- Standard call to get message count and if count=1, get the message
165: FND_MSG_PUB.Count_And_Get (
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Create_Item_Sec_Assoc;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: -- Standard call to get message count and if count=1, get the message
174: FND_MSG_PUB.Count_And_Get (

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

168: p_data => x_msg_data
169: );
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Create_Item_Sec_Assoc;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: -- Standard call to get message count and if count=1, get the message
174: FND_MSG_PUB.Count_And_Get (
175: p_encoded => FND_API.G_FALSE,
176: p_count => x_msg_count,

Line 175: p_encoded => FND_API.G_FALSE,

171: ROLLBACK TO Create_Item_Sec_Assoc;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: -- Standard call to get message count and if count=1, get the message
174: FND_MSG_PUB.Count_And_Get (
175: p_encoded => FND_API.G_FALSE,
176: p_count => x_msg_count,
177: p_data => x_msg_data
178: );
179: WHEN OTHERS THEN

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: p_data => x_msg_data
178: );
179: WHEN OTHERS THEN
180: ROLLBACK TO Create_Item_Sec_Assoc;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
183: THEN
184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
185: END IF;

Line 188: p_encoded => FND_API.G_FALSE,

184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
185: END IF;
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: END create_item_sec_assoc;

Line 203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

199:
200: PROCEDURE Delete_item_sec_assoc
201: (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
204: p_commit IN VARCHAR2 := FND_API.g_false,
205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
206:
207: x_return_status OUT VARCHAR2,

Line 204: p_commit IN VARCHAR2 := FND_API.g_false,

200: PROCEDURE Delete_item_sec_assoc
201: (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
204: p_commit IN VARCHAR2 := FND_API.g_false,
205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
206:
207: x_return_status OUT VARCHAR2,
208: x_msg_count OUT NUMBER,

Line 205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

201: (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
204: p_commit IN VARCHAR2 := FND_API.g_false,
205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
206:
207: x_return_status OUT VARCHAR2,
208: x_msg_count OUT NUMBER,
209: x_msg_data OUT VARCHAR2,

Line 234: IF NOT FND_API.Compatible_API_Call ( l_api_version,

230: -- Standard Start of API savepoint
231: SAVEPOINT Delete_item_sec_assoc;
232:
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call ( l_api_version,
235: p_api_version,
236: l_api_name,
237: G_PKG_NAME)
238: THEN

Line 239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

235: p_api_version,
236: l_api_name,
237: G_PKG_NAME)
238: THEN
239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
240: END IF;
241:
242: -- Initialize message list if p_init_msg_list is set to TRUE.
243: IF FND_API.to_Boolean( p_init_msg_list )

Line 243: IF FND_API.to_Boolean( p_init_msg_list )

239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
240: END IF;
241:
242: -- Initialize message list if p_init_msg_list is set to TRUE.
243: IF FND_API.to_Boolean( p_init_msg_list )
244: THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247:

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: -- AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
250:
251:
252: -- Initialize API return status to SUCCESS
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255:
256: -- ******************************************************************
257: -- Validate Environment

Line 266: RAISE FND_API.G_EXC_ERROR;

262: THEN
263: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
264: FND_MSG_PUB.ADD;
265: END IF;
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268:
269: l_section_id_tbl(1) := p_section_rec.section_id;
270: l_inv_id_tbl(1) := p_section_rec.inventory_item_id;

Line 290: IF x_return_status =FND_API.G_RET_STS_UNEXP_ERROR

286: , x_msg_data => x_msg_data
287: );
288:
289:
290: IF x_return_status =FND_API.G_RET_STS_UNEXP_ERROR
291: THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: ELSIF x_return_status =FND_API.G_RET_STS_ERROR
294: THEN

Line 292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

288:
289:
290: IF x_return_status =FND_API.G_RET_STS_UNEXP_ERROR
291: THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: ELSIF x_return_status =FND_API.G_RET_STS_ERROR
294: THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;

Line 293: ELSIF x_return_status =FND_API.G_RET_STS_ERROR

289:
290: IF x_return_status =FND_API.G_RET_STS_UNEXP_ERROR
291: THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: ELSIF x_return_status =FND_API.G_RET_STS_ERROR
294: THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297:

Line 295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

291: THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: ELSIF x_return_status =FND_API.G_RET_STS_ERROR
294: THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297:
298:
299: -- Standard check for p_commit

Line 300: IF FND_API.to_Boolean( p_commit )

296: END IF;
297:
298:
299: -- Standard check for p_commit
300: IF FND_API.to_Boolean( p_commit )
301: THEN
302: COMMIT WORK;
303: END IF;
304:

Line 315: WHEN FND_API.G_EXC_ERROR THEN

311: (p_count => x_msg_count,
312: p_data => x_msg_data
313: );
314: EXCEPTION
315: WHEN FND_API.G_EXC_ERROR THEN
316: ROLLBACK TO Delete_item_sec_assoc;
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: -- Standard call to get message count and if count=1, get the message
319: FND_MSG_PUB.Count_And_Get (

Line 317: x_return_status := FND_API.G_RET_STS_ERROR;

313: );
314: EXCEPTION
315: WHEN FND_API.G_EXC_ERROR THEN
316: ROLLBACK TO Delete_item_sec_assoc;
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: -- Standard call to get message count and if count=1, get the message
319: FND_MSG_PUB.Count_And_Get (
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_msg_count,

Line 320: p_encoded => FND_API.G_FALSE,

316: ROLLBACK TO Delete_item_sec_assoc;
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: -- Standard call to get message count and if count=1, get the message
319: FND_MSG_PUB.Count_And_Get (
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_msg_count,
322: p_data => x_msg_data
323: );
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

320: p_encoded => FND_API.G_FALSE,
321: p_count => x_msg_count,
322: p_data => x_msg_data
323: );
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO Delete_item_sec_assoc;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: -- Standard call to get message count and if count=1, get the message
328: FND_MSG_PUB.Count_And_Get (

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322: p_data => x_msg_data
323: );
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO Delete_item_sec_assoc;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: -- Standard call to get message count and if count=1, get the message
328: FND_MSG_PUB.Count_And_Get (
329: p_encoded => FND_API.G_FALSE,
330: p_count => x_msg_count,

Line 329: p_encoded => FND_API.G_FALSE,

325: ROLLBACK TO Delete_item_sec_assoc;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: -- Standard call to get message count and if count=1, get the message
328: FND_MSG_PUB.Count_And_Get (
329: p_encoded => FND_API.G_FALSE,
330: p_count => x_msg_count,
331: p_data => x_msg_data
332: );
333: WHEN OTHERS THEN

Line 335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

331: p_data => x_msg_data
332: );
333: WHEN OTHERS THEN
334: ROLLBACK TO Delete_item_sec_assoc;
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
337: THEN
338: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
339: END IF;

Line 342: p_encoded => FND_API.G_FALSE,

338: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
339: END IF;
340: -- Standard call to get message count and if count=1, get the message
341: FND_MSG_PUB.Count_And_Get (
342: p_encoded => FND_API.G_FALSE,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: END Delete_item_sec_assoc;