DBA Data[Home] [Help]

APPS.IEX_AGING_BUCKETS_PKG dependencies on FND_API

Line 2242: IF NOT FND_API.Compatible_API_Call (l_api_version,

2238:
2239: SAVEPOINT Query_Aging_lines;
2240:
2241: -- Standard call to check for call compatibility.
2242: IF NOT FND_API.Compatible_API_Call (l_api_version,
2243: p_api_version,
2244: l_api_name,
2245: G_PKG_NAME) THEN
2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2242: IF NOT FND_API.Compatible_API_Call (l_api_version,
2243: p_api_version,
2244: l_api_name,
2245: G_PKG_NAME) THEN
2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2247: END IF;
2248:
2249: -- Check p_init_msg_list
2250: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2250: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2247: END IF;
2248:
2249: -- Check p_init_msg_list
2250: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2251: FND_MSG_PUB.initialize;
2252: END IF;
2253:
2254:

Line 2267: x_return_status := FND_API.G_RET_STS_SUCCESS;

2263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2264: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Bucket Id >> ' || p_bucket_id );
2265: END IF;
2266:
2267: x_return_status := FND_API.G_RET_STS_SUCCESS;
2268:
2269: IEX_CURRENCY_PVT.GET_FUNCT_CURR(
2270: P_API_VERSION =>1.0,
2271: p_init_msg_list => 'T',

Line 3262: IF FND_API.To_Boolean(p_commit) THEN

3258: x_bucket_lines_tbl(l_total_rec).disputed_tran_amount :=
3259: l_total_disp_amount ;
3260:
3261: -- Standard check of p_commit
3262: IF FND_API.To_Boolean(p_commit) THEN
3263: COMMIT WORK;
3264: END IF;
3265:
3266: -- Standard call to get message count and if count is 1, get message info

Line 3283: WHEN FND_API.G_EXC_ERROR THEN

3279: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');
3280: END IF;
3281:
3282: EXCEPTION
3283: WHEN FND_API.G_EXC_ERROR THEN
3284: ROLLBACK TO Query_Aging_lines;
3285: x_return_status := FND_API.G_RET_STS_ERROR;
3286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3287:

Line 3285: x_return_status := FND_API.G_RET_STS_ERROR;

3281:
3282: EXCEPTION
3283: WHEN FND_API.G_EXC_ERROR THEN
3284: ROLLBACK TO Query_Aging_lines;
3285: x_return_status := FND_API.G_RET_STS_ERROR;
3286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3287:
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: ROLLBACK TO Query_Aging_lines;

Line 3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3284: ROLLBACK TO Query_Aging_lines;
3285: x_return_status := FND_API.G_RET_STS_ERROR;
3286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3287:
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: ROLLBACK TO Query_Aging_lines;
3290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3291: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3292:

Line 3290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3287:
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: ROLLBACK TO Query_Aging_lines;
3290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3291: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3292:
3293: WHEN OTHERS THEN
3294: ROLLBACK TO Query_Aging_lines;

Line 3295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3291: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3292:
3293: WHEN OTHERS THEN
3294: ROLLBACK TO Query_Aging_lines;
3295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3296: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3297: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3298: END IF;
3299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);