10:
11: PROCEDURE start_workflow
12: (
13: p_api_version IN NUMBER := 1.0,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_delinquency_id IN NUMBER,
17: p_repossession_id IN NUMBER,
18: p_third_party_id IN NUMBER,
11: PROCEDURE start_workflow
12: (
13: p_api_version IN NUMBER := 1.0,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_delinquency_id IN NUMBER,
17: p_repossession_id IN NUMBER,
18: p_third_party_id IN NUMBER,
19: p_third_party_name IN NUMBER,
38: -- Standard Start of API savepoint
39: SAVEPOINT START_WORKFLOW;
40:
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
43: p_api_version,
44: l_api_name,
45: G_PKG_NAME)
46: THEN
43: p_api_version,
44: l_api_name,
45: G_PKG_NAME)
46: THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
50:
51: -- Initialize message list if p_init_msg_list is set to TRUE.
48: END IF;
49:
50:
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF FND_API.to_Boolean( p_init_msg_list )
53: THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
62: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
63:
64:
65: -- Initialize API return status to SUCCESS
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: itemtype := 'IEXDELRE';
69: workflowprocess := 'REP_NOTE';
70:
129: p_data => x_msg_data
130: );
131:
132: EXCEPTION
133: WHEN FND_API.G_EXC_ERROR THEN
134: as_utility_pvt.HANDLE_EXCEPTIONS(
135: P_API_NAME => L_API_NAME
136: ,P_PKG_NAME => G_PKG_NAME
137: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
139: ,X_MSG_COUNT => X_MSG_COUNT
140: ,X_MSG_DATA => X_MSG_DATA
141: ,X_RETURN_STATUS => X_RETURN_STATUS);
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: as_utility_pvt.HANDLE_EXCEPTIONS(
145: P_API_NAME => L_API_NAME
146: ,P_PKG_NAME => G_PKG_NAME
147: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR