APPS.ZPB_EXCEPTION_ALERT dependencies on FND_API

Line 628: p_init_msg_list => FND_API.G_FALSE,

624:
625: ZPB_LOG.WRITE_EVENT_TR ('ZPB_EXCEPTION_ALERT.WF_RUN_EXCEPTION', 'ZPB_WF_BEGEXCPRUN');
626:
627: zpb_excp_pvt.run_exception(p_api_version => 1.0,
628: p_init_msg_list => FND_API.G_FALSE,
629: p_commit => FND_API.G_TRUE,
630: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
631: x_return_status => x_return_status,
632: x_msg_count => x_msg_count,

Line 629: p_commit => FND_API.G_TRUE,

625: ZPB_LOG.WRITE_EVENT_TR ('ZPB_EXCEPTION_ALERT.WF_RUN_EXCEPTION', 'ZPB_WF_BEGEXCPRUN');
626:
627: zpb_excp_pvt.run_exception(p_api_version => 1.0,
628: p_init_msg_list => FND_API.G_FALSE,
629: p_commit => FND_API.G_TRUE,
630: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
631: x_return_status => x_return_status,
632: x_msg_count => x_msg_count,
633: x_msg_data => x_msg_data,

Line 630: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

626:
627: zpb_excp_pvt.run_exception(p_api_version => 1.0,
628: p_init_msg_list => FND_API.G_FALSE,
629: p_commit => FND_API.G_TRUE,
630: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
631: x_return_status => x_return_status,
632: x_msg_count => x_msg_count,
633: x_msg_data => x_msg_data,
634: p_task_id => taskID,

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

2092: AddMsg in varchar2 default NULL,
2093: Dtype in varchar2 default NULL,
2094: Dvalue in number default NULL,
2095: p_api_version IN NUMBER,
2096: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2097: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2098: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2099: x_return_status OUT nocopy varchar2,
2100: x_msg_count OUT nocopy number,

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

2093: Dtype in varchar2 default NULL,
2094: Dvalue in number default NULL,
2095: p_api_version IN NUMBER,
2096: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2097: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2098: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2099: x_return_status OUT nocopy varchar2,
2100: x_msg_count OUT nocopy number,
2101: x_msg_data OUT nocopy varchar2)

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

2094: Dvalue in number default NULL,
2095: p_api_version IN NUMBER,
2096: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2097: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2098: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2099: x_return_status OUT nocopy varchar2,
2100: x_msg_count OUT nocopy number,
2101: x_msg_data OUT nocopy varchar2)
2102:

Line 2155: IF NOT FND_API.Compatible_API_Call( l_api_version,

2151:
2152: -- Standard Start of API savepoint
2153: SAVEPOINT zpb_request_explanation;
2154: -- Standard call to check for call compatibility.
2155: IF NOT FND_API.Compatible_API_Call( l_api_version,
2156: p_api_version,
2157: l_api_name,
2158: G_PKG_NAME)
2159: THEN

Line 2160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2156: p_api_version,
2157: l_api_name,
2158: G_PKG_NAME)
2159: THEN
2160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2161: END IF;
2162: -- Initialize message list if p_init_msg_list is set to TRUE.
2163: IF FND_API.to_Boolean(p_init_msg_list) THEN
2164: FND_MSG_PUB.initialize;

Line 2163: IF FND_API.to_Boolean(p_init_msg_list) THEN

2159: THEN
2160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2161: END IF;
2162: -- Initialize message list if p_init_msg_list is set to TRUE.
2163: IF FND_API.to_Boolean(p_init_msg_list) THEN
2164: FND_MSG_PUB.initialize;
2165: END IF;
2166: -- Initialize API return status to success
2167: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2167: x_return_status := FND_API.G_RET_STS_SUCCESS;

2163: IF FND_API.to_Boolean(p_init_msg_list) THEN
2164: FND_MSG_PUB.initialize;
2165: END IF;
2166: -- Initialize API return status to success
2167: x_return_status := FND_API.G_RET_STS_SUCCESS;
2168:
2169:
2170: -- Begin REQUEST_EXPLANATIONS code
2171: select ITEM_KEY into ItemKey

Line 2447: IF FND_API.To_Boolean( p_commit ) THEN

2443: return;
2444: */
2445:
2446: -- Standard check of p_commit.
2447: IF FND_API.To_Boolean( p_commit ) THEN
2448: COMMIT WORK;
2449: END IF;
2450:
2451: -- Standard call to get message count and if count is 1, get message info.

Line 2466: WHEN FND_API.G_EXC_ERROR THEN

2462: raise;
2463: */
2464:
2465:
2466: WHEN FND_API.G_EXC_ERROR THEN
2467: ROLLBACK TO zpb_request_explanation;
2468: x_return_status := FND_API.G_RET_STS_ERROR;
2469: FND_MSG_PUB.Count_And_Get(
2470: p_count => x_msg_count,

Line 2468: x_return_status := FND_API.G_RET_STS_ERROR;

2464:
2465:
2466: WHEN FND_API.G_EXC_ERROR THEN
2467: ROLLBACK TO zpb_request_explanation;
2468: x_return_status := FND_API.G_RET_STS_ERROR;
2469: FND_MSG_PUB.Count_And_Get(
2470: p_count => x_msg_count,
2471: p_data => x_msg_data
2472: );

Line 2473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2469: FND_MSG_PUB.Count_And_Get(
2470: p_count => x_msg_count,
2471: p_data => x_msg_data
2472: );
2473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2474: ROLLBACK TO zpb_request_explanation;
2475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2476: FND_MSG_PUB.Count_And_Get(
2477: p_count => x_msg_count,

Line 2475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2471: p_data => x_msg_data
2472: );
2473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2474: ROLLBACK TO zpb_request_explanation;
2475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2476: FND_MSG_PUB.Count_And_Get(
2477: p_count => x_msg_count,
2478: p_data => x_msg_data
2479: );

Line 2482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2478: p_data => x_msg_data
2479: );
2480: WHEN OTHERS THEN
2481: ROLLBACK TO zpb_request_explanation;
2482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2484: FND_MSG_PUB.Add_Exc_Msg(
2485: G_PKG_NAME,
2486: l_api_name