APPS.IES_TRANSACTION_UTIL_PUB dependencies on FND_API

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

29:
30: PROCEDURE update_status_to_completed
31: (
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34: p_commit IN VARCHAR2 := FND_API.G_TRUE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_transaction_id IN NUMBER,
37: x_return_status OUT NOCOPY VARCHAR2,

Line 34: p_commit IN VARCHAR2 := FND_API.G_TRUE,

30: PROCEDURE update_status_to_completed
31: (
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34: p_commit IN VARCHAR2 := FND_API.G_TRUE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_transaction_id IN NUMBER,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,

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

31: (
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34: p_commit IN VARCHAR2 := FND_API.G_TRUE,
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_transaction_id IN NUMBER,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2

Line 43: l_encoded VARCHAR2(1) := FND_API.G_FALSE;

39: x_msg_data OUT NOCOPY VARCHAR2
40: ) IS
41: l_api_name CONSTANT VARCHAR2(30) := 'update_status_to_completed';
42: l_api_version CONSTANT NUMBER := 1.0;
43: l_encoded VARCHAR2(1) := FND_API.G_FALSE;
44: l_status NUMBER;
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT update_status_to_completed_sp;

Line 49: IF NOT FND_API.Compatible_API_Call ( l_api_version,

45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT update_status_to_completed_sp;
48: -- Standard call to check for call compatibility
49: IF NOT FND_API.Compatible_API_Call ( l_api_version,
50: p_api_version,
51: l_api_name,
52: G_PKG_NAME)
53: THEN

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

50: p_api_version,
51: l_api_name,
52: G_PKG_NAME)
53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56: -- initialize message list if p_init_msg_list is set to TRUE
57: IF FND_API.To_Boolean( p_init_msg_list ) THEN
58: FND_MSG_PUB.initialize;

Line 57: IF FND_API.To_Boolean( p_init_msg_list ) THEN

53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56: -- initialize message list if p_init_msg_list is set to TRUE
57: IF FND_API.To_Boolean( p_init_msg_list ) THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: -- Initialize the API return status to success

Line 62: x_return_status := FND_API.G_RET_STS_SUCCESS;

58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: -- Initialize the API return status to success
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63: BEGIN
64: -- API body
65: l_status := getTransactionStatus(p_transaction_id);
66: if (l_status = 1) then

Line 73: RAISE FND_API.G_EXC_ERROR;

69: else
70: FND_MESSAGE.SET_NAME('IES', 'IES_STATUS_UPDATE_ERROR');
71: FND_MSG_PUB.Add;
72:
73: RAISE FND_API.G_EXC_ERROR;
74: end if;
75: END;
76:
77: -- Signify Success

Line 87: IF FND_API.To_Boolean( p_commit ) THEN

83:
84: -- End of API body
85:
86: -- Standard check of p_commit
87: IF FND_API.To_Boolean( p_commit ) THEN
88: COMMIT WORK;
89: END IF;
90:
91: -- Standard call to get message count and if count is 1, get message info

Line 99: WHEN FND_API.G_EXC_ERROR THEN

95: p_data => x_msg_data
96: );
97:
98: EXCEPTION
99: WHEN FND_API.G_EXC_ERROR THEN
100: ROLLBACK TO update_status_to_completed_sp;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102:
103: FND_MSG_PUB.Count_And_Get

Line 101: x_return_status := FND_API.G_RET_STS_ERROR;

97:
98: EXCEPTION
99: WHEN FND_API.G_EXC_ERROR THEN
100: ROLLBACK TO update_status_to_completed_sp;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102:
103: FND_MSG_PUB.Count_And_Get
104: ( p_encoded => l_encoded,
105: p_count => x_msg_count,

Line 109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

105: p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108:
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO update_status_to_completed_sp;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112:
113: FND_MSG_PUB.Count_And_Get

Line 111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

107: );
108:
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO update_status_to_completed_sp;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112:
113: FND_MSG_PUB.Count_And_Get
114: ( p_encoded => l_encoded,
115: p_count => x_msg_count,

Line 121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

117: );
118:
119: WHEN OTHERS THEN
120: ROLLBACK TO update_status_to_completed_sp;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122:
123: IF FND_MSG_PUB.Check_Msg_Level
124: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN