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.AMW_EXCEPTIONS_PKG dependencies on FND_API

Line 30: p_commit in varchar2 := FND_API.G_FALSE,

26: p_Transaction_Type IN Varchar2,
27: p_Justification IN Varchar2,
28: p_person_party_id IN Number,
29: p_existing_ex_id IN Number,
30: p_commit in varchar2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: x_return_status out nocopy varchar2,
34: x_msg_count out nocopy number,

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

27: p_Justification IN Varchar2,
28: p_person_party_id IN Number,
29: p_existing_ex_id IN Number,
30: p_commit in varchar2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: x_return_status out nocopy varchar2,
34: x_msg_count out nocopy number,
35: x_msg_data out nocopy varchar2

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

28: p_person_party_id IN Number,
29: p_existing_ex_id IN Number,
30: p_commit in varchar2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: x_return_status out nocopy varchar2,
34: x_msg_count out nocopy number,
35: x_msg_data out nocopy varchar2
36: ) is

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

46: l_sp_disp_name varchar2(100);
47:
48:
49: begin
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51: IF FND_API.to_Boolean( p_init_msg_list ) THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54: IF FND_GLOBAL.User_Id IS NULL THEN

Line 51: IF FND_API.to_Boolean( p_init_msg_list ) THEN

47:
48:
49: begin
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51: IF FND_API.to_Boolean( p_init_msg_list ) THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54: IF FND_GLOBAL.User_Id IS NULL THEN
55: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 56: RAISE FND_API.G_EXC_ERROR;

52: FND_MSG_PUB.initialize;
53: END IF;
54: IF FND_GLOBAL.User_Id IS NULL THEN
55: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
56: RAISE FND_API.G_EXC_ERROR;
57: END IF;
58:
59: if ( (p_Object_Type = 'PROCESS_VARIANT_ADD') AND (p_Transaction_Type = 'DELETE_EXIST') ) then
60: delete from amw_exceptions_tl where exception_id IN

Line 223: WHEN FND_API.G_EXC_ERROR THEN

219:
220: end if; -- (p_Object_Type = 'PROCESS_VARIANT_ADD') AND (p_Transaction_Type = 'DELETE_EXIST')
221:
222: exception
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
227:

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221:
222: exception
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: ROLLBACK;

Line 226: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

222: exception
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: ROLLBACK;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

224: ROLLBACK;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: ROLLBACK;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
232:

Line 230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

226: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: ROLLBACK;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
232:
233: WHEN OTHERS THEN
234: ROLLBACK;

Line 231: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: ROLLBACK;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
232:
233: WHEN OTHERS THEN
234: ROLLBACK;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
232:
233: WHEN OTHERS THEN
234: ROLLBACK;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
239: END IF;

Line 240: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
239: END IF;
240: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
241:
242: end insert_exception_header_row;
243:
244:

Line 252: p_commit in varchar2 := FND_API.G_FALSE,

248: procedure insert_exceptions_reasons_row (
249: p_EXCEPTION_ID in number,
250: p_REASON_CODE in varchar2,
251: p_existing_ex_id IN Number,
252: p_commit in varchar2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: x_return_status out nocopy varchar2,
256: x_msg_count out nocopy number,

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

249: p_EXCEPTION_ID in number,
250: p_REASON_CODE in varchar2,
251: p_existing_ex_id IN Number,
252: p_commit in varchar2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: x_return_status out nocopy varchar2,
256: x_msg_count out nocopy number,
257: x_msg_data out nocopy varchar2

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

250: p_REASON_CODE in varchar2,
251: p_existing_ex_id IN Number,
252: p_commit in varchar2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255: x_return_status out nocopy varchar2,
256: x_msg_count out nocopy number,
257: x_msg_data out nocopy varchar2
258: ) is

Line 263: x_return_status := FND_API.G_RET_STS_SUCCESS;

259:
260: L_API_NAME CONSTANT VARCHAR2(30) := 'insert_exceptions_reasons_row';
261:
262: begin
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: IF FND_API.to_Boolean( p_init_msg_list ) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267: IF FND_GLOBAL.User_Id IS NULL THEN

Line 264: IF FND_API.to_Boolean( p_init_msg_list ) THEN

260: L_API_NAME CONSTANT VARCHAR2(30) := 'insert_exceptions_reasons_row';
261:
262: begin
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: IF FND_API.to_Boolean( p_init_msg_list ) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267: IF FND_GLOBAL.User_Id IS NULL THEN
268: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 269: RAISE FND_API.G_EXC_ERROR;

265: FND_MSG_PUB.initialize;
266: END IF;
267: IF FND_GLOBAL.User_Id IS NULL THEN
268: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: if p_existing_ex_id <> 0 then
273: delete from amw_exceptions_reasons where exception_id = p_existing_ex_id;

Line 299: WHEN FND_API.G_EXC_ERROR THEN

295: );
296: end if; -- p_existing_ex_id 0
297:
298: exception
299: WHEN FND_API.G_EXC_ERROR THEN
300: ROLLBACK;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

297:
298: exception
299: WHEN FND_API.G_EXC_ERROR THEN
300: ROLLBACK;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK;

Line 302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

298: exception
299: WHEN FND_API.G_EXC_ERROR THEN
300: ROLLBACK;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

300: ROLLBACK;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:

Line 306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:
309: WHEN OTHERS THEN
310: ROLLBACK;

Line 307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:
309: WHEN OTHERS THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:
309: WHEN OTHERS THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
315: END IF;

Line 316: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
315: END IF;
316: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
317:
318: end insert_exceptions_reasons_row;
319:
320: