54: END IF;
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: -- Initialize API return status to SUCCESS
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
60: -- Initialize API return status to SUCCESS
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: -- Standard callto get message count and if count is 1, get message info.
64: FND_MSG_PUB.Count_And_Get
65: ( p_count => x_msg_count,
66: p_data => x_msg_data
67: );
68: EXCEPTION
68: EXCEPTION
69: WHEN FND_API.G_EXC_ERROR THEN
70: ROLLBACK TO CallWorkFlow_PUB;
71: x_return_status := FND_API.G_RET_STS_ERROR ;
72: FND_MSG_PUB.Count_And_Get
73: ( p_count => x_msg_count,
74: p_data => x_msg_data
75: );
76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: );
76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
77: ROLLBACK TO CallWorkFlow_PUB;
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
79: FND_MSG_PUB.Count_And_Get
80: ( p_count => x_msg_count,
81: p_data => x_msg_data
82: );
83: WHEN l_wf_excep THEN
84: ROLLBACK TO CallWorkFlow_PUB;
85: WHEN OTHERS THEN
86: ROLLBACK TO CallWorkFlow_PUB;
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: IF FND_MSG_PUB.Check_Msg_Level
89: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
90: THEN
91: FND_MSG_PUB.Add_Exc_Msg
92: ( G_PKG_NAME ,
85: WHEN OTHERS THEN
86: ROLLBACK TO CallWorkFlow_PUB;
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: IF FND_MSG_PUB.Check_Msg_Level
89: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
90: THEN
91: FND_MSG_PUB.Add_Exc_Msg
92: ( G_PKG_NAME ,
93: l_api_name
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: IF FND_MSG_PUB.Check_Msg_Level
89: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
90: THEN
91: FND_MSG_PUB.Add_Exc_Msg
92: ( G_PKG_NAME ,
93: l_api_name
94: );
95: END IF;
92: ( G_PKG_NAME ,
93: l_api_name
94: );
95: END IF;
96: FND_MSG_PUB.Count_And_Get
97: ( p_count => x_msg_count ,
98: p_data => x_msg_data
99: );
100:
136: END IF;
137: -- Initialize message list if p_init_msg_list is set to TRUE.
138: IF FND_API.to_Boolean( p_init_msg_list )
139: THEN
140: FND_MSG_PUB.initialize;
141: END IF;
142:
143: EXCEPTION
144: WHEN FND_API.G_EXC_ERROR THEN
254: END IF;
255: -- Initialize message list if p_init_msg_list is set to TRUE.
256: IF FND_API.to_Boolean( p_init_msg_list )
257: THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260: -- Initialize API return status to SUCCESS
261: FOR wf_err_data_rec in wf_err_data_csr LOOP
262: BEGIN