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,
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,
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
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.
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:
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:
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
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;
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
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;
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;