DBA Data[Home] [Help]

APPS.IEX_WF_DEL_STATUS_PUB dependencies on FND_API

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

12:
13: PROCEDURE start_workflow
14: (
15: p_api_version IN NUMBER := 1.0,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_delinquency_id IN NUMBER,
19: p_repossession_id IN NUMBER,
20: p_litigation_id IN NUMBER,

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

13: PROCEDURE start_workflow
14: (
15: p_api_version IN NUMBER := 1.0,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_delinquency_id IN NUMBER,
19: p_repossession_id IN NUMBER,
20: p_litigation_id IN NUMBER,
21: p_writeoff_id IN NUMBER,

Line 46: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

42: -- Standard Start of API savepoint
43: SAVEPOINT START_WORKFLOW;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
47: p_api_version,
48: l_api_name,
49: G_PKG_NAME)
50: THEN

Line 51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

47: p_api_version,
48: l_api_name,
49: G_PKG_NAME)
50: THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53:
54:
55: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 56: IF FND_API.to_Boolean( p_init_msg_list )

52: END IF;
53:
54:
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: IF FND_API.to_Boolean( p_init_msg_list )
57: THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Public API: ' || l_api_name || ' start');
65: IEX_DEBUG_PUB.logMessage(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
66: END IF;
67: -- Initialize API return status to SUCCESS
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: itemtype := 'IEXDELST';
71: workflowprocess := 'DEL_STATUS';
72:

Line 136: WHEN FND_API.G_EXC_ERROR THEN

132: p_data => x_msg_data
133: );
134:
135: EXCEPTION
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO START_WORKFLOW;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134:
135: EXCEPTION
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO START_WORKFLOW;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: ROLLBACK TO START_WORKFLOW;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO START_WORKFLOW;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: ROLLBACK TO START_WORKFLOW;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: ROLLBACK TO START_WORKFLOW;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO START_WORKFLOW;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO START_WORKFLOW;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
150: END IF;