DBA Data[Home] [Help]

APPS.XLA_TB_BALANCE_PUB dependencies on FND_API

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

65: --============================================================================
66:
67: PROCEDURE upload_balances
68: (p_api_version IN NUMBER
69: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
70: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
71: ,x_return_status OUT NOCOPY VARCHAR2
72: ,x_msg_count OUT NOCOPY NUMBER
73: ,x_msg_data OUT NOCOPY VARCHAR2

Line 70: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

66:
67: PROCEDURE upload_balances
68: (p_api_version IN NUMBER
69: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
70: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
71: ,x_return_status OUT NOCOPY VARCHAR2
72: ,x_msg_count OUT NOCOPY NUMBER
73: ,x_msg_data OUT NOCOPY VARCHAR2
74: ,p_definition_code IN VARCHAR2

Line 106: IF NOT FND_API.Compatible_API_Call

102: END IF;
103:
104: SAVEPOINT Upload_Balances;
105:
106: IF NOT FND_API.Compatible_API_Call
107: (p_current_version_number => l_api_version
108: ,p_caller_version_number => p_api_version
109: ,p_api_name => l_api_name
110: ,p_pkg_name => G_PKG_NAME)

Line 113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

109: ,p_api_name => l_api_name
110: ,p_pkg_name => G_PKG_NAME)
111: THEN
112:
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114:
115: END IF;
116:
117: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 118: IF FND_API.to_Boolean( p_init_msg_list ) THEN

114:
115: END IF;
116:
117: -- Initialize message list if p_init_msg_list is set to TRUE.
118: IF FND_API.to_Boolean( p_init_msg_list ) THEN
119:
120: FND_MSG_PUB.initialize;
121:
122: END IF;

Line 125: x_return_status := FND_API.G_RET_STS_SUCCESS;

121:
122: END IF;
123:
124: -- Initialize API return status to success
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126:
127: xla_tb_balance_pkg.upload_balances
128: (p_api_version => p_api_version
129: ,p_init_msg_list => p_init_msg_list

Line 156: WHEN FND_API.G_EXC_ERROR THEN

152: (p_count => x_msg_count
153: ,p_data => x_msg_data);
154:
155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157:
158: ROLLBACK TO Upload_Balances;
159:
160: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 160: x_return_status := FND_API.G_RET_STS_ERROR ;

156: WHEN FND_API.G_EXC_ERROR THEN
157:
158: ROLLBACK TO Upload_Balances;
159:
160: x_return_status := FND_API.G_RET_STS_ERROR ;
161:
162: FND_MSG_PUB.Count_And_Get
163: (p_count => x_msg_count
164: ,p_data => x_msg_data);

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: FND_MSG_PUB.Count_And_Get
163: (p_count => x_msg_count
164: ,p_data => x_msg_data);
165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167:
168: ROLLBACK TO Upload_Balances;
169:
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167:
168: ROLLBACK TO Upload_Balances;
169:
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171:
172: FND_MSG_PUB.Count_And_Get
173: (p_count => x_msg_count
174: ,p_data => x_msg_data);

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

176: WHEN OTHERS THEN
177:
178: ROLLBACK TO Upload_Balances;
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181:
182: IF FND_MSG_PUB.Check_Msg_Level
183: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
184: THEN

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

195:
196:
197: PROCEDURE Upgrade_AP_Balances
198: (p_api_version IN NUMBER
199: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
200: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
201: ,x_return_status OUT NOCOPY VARCHAR2
202: ,x_msg_count OUT NOCOPY NUMBER
203: ,x_msg_data OUT NOCOPY VARCHAR2

Line 200: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

196:
197: PROCEDURE Upgrade_AP_Balances
198: (p_api_version IN NUMBER
199: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
200: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
201: ,x_return_status OUT NOCOPY VARCHAR2
202: ,x_msg_count OUT NOCOPY NUMBER
203: ,x_msg_data OUT NOCOPY VARCHAR2
204: ,p_balance_side_code IN VARCHAR2

Line 229: IF NOT FND_API.Compatible_API_Call

225: END IF;
226:
227: SAVEPOINT Upgrade_AP_Balances;
228:
229: IF NOT FND_API.Compatible_API_Call
230: (p_current_version_number => l_api_version
231: ,p_caller_version_number => p_api_version
232: ,p_api_name => l_api_name
233: ,p_pkg_name => G_PKG_NAME)

Line 236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

232: ,p_api_name => l_api_name
233: ,p_pkg_name => G_PKG_NAME)
234: THEN
235:
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237:
238: END IF;
239:
240: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 241: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 248: x_return_status := FND_API.G_RET_STS_SUCCESS;

244:
245: END IF;
246:
247: -- Initialize API return status to success
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250: xla_tb_balance_pkg.Upgrade_AP_Balances
251: (p_api_version => p_api_version
252: ,p_init_msg_list => p_init_msg_list

Line 275: WHEN FND_API.G_EXC_ERROR THEN

271: EXCEPTION
272: WHEN OTHERS THEN
273: raise;
274: /*
275: WHEN FND_API.G_EXC_ERROR THEN
276:
277: -- ROLLBACK TO Upgrade_AP_Balances;
278:
279: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 279: x_return_status := FND_API.G_RET_STS_ERROR ;

275: WHEN FND_API.G_EXC_ERROR THEN
276:
277: -- ROLLBACK TO Upgrade_AP_Balances;
278:
279: x_return_status := FND_API.G_RET_STS_ERROR ;
280:
281: FND_MSG_PUB.Count_And_Get
282: (p_count => x_msg_count
283: ,p_data => x_msg_data);

Line 285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

281: FND_MSG_PUB.Count_And_Get
282: (p_count => x_msg_count
283: ,p_data => x_msg_data);
284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286:
287: -- ROLLBACK TO Upgrade_AP_Balances;
288:
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286:
287: -- ROLLBACK TO Upgrade_AP_Balances;
288:
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
290:
291: FND_MSG_PUB.Count_And_Get
292: (p_count => x_msg_count
293: ,p_data => x_msg_data);

Line 299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

295: WHEN OTHERS THEN
296:
297: -- ROLLBACK TO Upgrade_AP_Balances;
298:
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
300:
301: IF FND_MSG_PUB.Check_Msg_Level
302: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
303: THEN