APPS.AK_UPLOAD_GRP dependencies on FND_API

Line 113: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,

109: --
110: -- Upload data from data file to the database
111: --
112: AK_ON_OBJECTS_GRP.UPLOAD (
113: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,
114: p_api_version_number => 1.0,
115: p_init_msg_tbl => TRUE,
116: p_msg_count => l_msg_count,
117: p_msg_data => l_msg_data,

Line 133: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

129: if FND_MSG_PUB.Count_Msg > 0 then
130: FND_MSG_PUB.Reset;
131: --dbms_output.put_line('Messages: ');
132: for i in 1 .. FND_MSG_PUB.Count_Msg loop
133: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
134: --dbms_output.put_line(to_char(i) || substr(l_buffer_tbl(i),1,256) );
135: end loop;
136: FND_MSG_PUB.Initialize;
137: end if;

Line 156: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

152: p_return_status => l_return_status,
153: p_buffer_tbl => l_buffer_tbl,
154: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
155: );
156: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
157: (l_return_status = FND_API.G_RET_STS_ERROR) then
158: RAISE FND_API.G_EXC_ERROR;
159: end if;
160:

Line 157: (l_return_status = FND_API.G_RET_STS_ERROR) then

153: p_buffer_tbl => l_buffer_tbl,
154: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
155: );
156: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
157: (l_return_status = FND_API.G_RET_STS_ERROR) then
158: RAISE FND_API.G_EXC_ERROR;
159: end if;
160:
161: EXCEPTION

Line 158: RAISE FND_API.G_EXC_ERROR;

154: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
155: );
156: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
157: (l_return_status = FND_API.G_RET_STS_ERROR) then
158: RAISE FND_API.G_EXC_ERROR;
159: end if;
160:
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN

Line 162: WHEN FND_API.G_EXC_ERROR THEN

158: RAISE FND_API.G_EXC_ERROR;
159: end if;
160:
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
163: p_return_status := FND_API.G_RET_STS_ERROR;
164: WHEN OTHERS THEN
165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 163: p_return_status := FND_API.G_RET_STS_ERROR;

159: end if;
160:
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
163: p_return_status := FND_API.G_RET_STS_ERROR;
164: WHEN OTHERS THEN
165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
167: SUBSTR (SQLERRM, 1, 240) );

Line 165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
163: p_return_status := FND_API.G_RET_STS_ERROR;
164: WHEN OTHERS THEN
165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
167: SUBSTR (SQLERRM, 1, 240) );
168: FND_MSG_PUB.Add;
169: if FND_MSG_PUB.Count_Msg > 0 then

Line 173: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

169: if FND_MSG_PUB.Count_Msg > 0 then
170: FND_MSG_PUB.Reset;
171: if ( l_index is null ) then l_index := 0; end if;
172: for i in 1 .. FND_MSG_PUB.Count_Msg loop
173: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
174: --dbms_output.put_line(to_char(i) || substr(l_buffer_tbl(i),1,256) );
175: end loop;
176: FND_MSG_PUB.Initialize;
177: end if;