DBA Data[Home] [Help]

APPS.AMW_EVALUATIONS_PKG dependencies on FND_API

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

28: p_OP_EFF IN VARCHAR2,
29: p_OV_EFF IN VARCHAR2,
30: p_PGMODE IN VARCHAR2,
31: p_EVALUATION_ID IN NUMBER,
32: p_commit in varchar2 := FND_API.G_FALSE,
33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: x_return_status out nocopy varchar2,
36: x_msg_count out nocopy number,

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

29: p_OV_EFF IN VARCHAR2,
30: p_PGMODE IN VARCHAR2,
31: p_EVALUATION_ID IN NUMBER,
32: p_commit in varchar2 := FND_API.G_FALSE,
33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: x_return_status out nocopy varchar2,
36: x_msg_count out nocopy number,
37: x_msg_data out nocopy varchar2,

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

30: p_PGMODE IN VARCHAR2,
31: p_EVALUATION_ID IN NUMBER,
32: p_commit in varchar2 := FND_API.G_FALSE,
33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: x_return_status out nocopy varchar2,
36: x_msg_count out nocopy number,
37: x_msg_data out nocopy varchar2,
38: p_EVALUATION_SET_STATUS_CODE IN VARCHAR2

Line 45: x_return_status := FND_API.G_RET_STS_SUCCESS;

41: L_API_NAME CONSTANT VARCHAR2(30) := 'insert_row';
42: l_evaluation_id number;
43:
44: begin
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46: IF FND_API.to_Boolean( p_init_msg_list ) THEN
47: FND_MSG_PUB.initialize;
48: END IF;
49: IF FND_GLOBAL.User_Id IS NULL THEN

Line 46: IF FND_API.to_Boolean( p_init_msg_list ) THEN

42: l_evaluation_id number;
43:
44: begin
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46: IF FND_API.to_Boolean( p_init_msg_list ) THEN
47: FND_MSG_PUB.initialize;
48: END IF;
49: IF FND_GLOBAL.User_Id IS NULL THEN
50: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 51: RAISE FND_API.G_EXC_ERROR;

47: FND_MSG_PUB.initialize;
48: END IF;
49: IF FND_GLOBAL.User_Id IS NULL THEN
50: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
51: RAISE FND_API.G_EXC_ERROR;
52: END IF;
53:
54:
55: if p_PGMODE = 'CR' then

Line 316: WHEN FND_API.G_EXC_ERROR THEN

312: end if; -- p_PGMODE = 'UP'
313:
314:
315: exception
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
320:

Line 318: x_return_status := FND_API.G_RET_STS_ERROR;

314:
315: exception
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: ROLLBACK;

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

315: exception
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: ROLLBACK;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

317: ROLLBACK;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: ROLLBACK;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
325:

Line 323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: ROLLBACK;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
325:
326: WHEN OTHERS THEN
327: ROLLBACK;

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

320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: ROLLBACK;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
325:
326: WHEN OTHERS THEN
327: ROLLBACK;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

324: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
325:
326: WHEN OTHERS THEN
327: ROLLBACK;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
332: END IF;

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

329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
332: END IF;
333: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
334:
335: end insert_row;
336:
337: