83: iex_debug_pub.logmessage('IEX-2 Start Invoking Creating New Delinquency Workflow');
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list )
86: THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90:
91:
152: l_parameter_list.DELETE;
153:
154:
155: -- Standard call to get message count and if count is 1, get message info.
156: FND_MSG_PUB.Count_And_Get
157: ( p_count => x_msg_count,
158: p_data => x_msg_data
159: );
160:
162: EXCEPTION
163: WHEN FND_API.G_EXC_ERROR THEN
164: ROLLBACK TO invoke_new_del_status_wf;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO invoke_new_del_status_wf;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO invoke_new_del_status_wf;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
172:
173: WHEN OTHERS THEN
174: ROLLBACK TO invoke_new_del_status_wf;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172:
173: WHEN OTHERS THEN
174: ROLLBACK TO invoke_new_del_status_wf;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
177: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
178: END IF;
179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
180: --End bug 6740370 gnramasa 11th Jan 08
173: WHEN OTHERS THEN
174: ROLLBACK TO invoke_new_del_status_wf;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
177: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
178: END IF;
179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
180: --End bug 6740370 gnramasa 11th Jan 08
181: ----------------------------------
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
177: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
178: END IF;
179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
180: --End bug 6740370 gnramasa 11th Jan 08
181: ----------------------------------
182: END invoke_new_del_status_wf;
183:
254:
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:
261:
262:
311: l_parameter_list.DELETE;
312:
313:
314: -- Standard call to get message count and if count is 1, get message info.
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count,
317: p_data => x_msg_data
318: );
319:
321: EXCEPTION
322: WHEN FND_API.G_EXC_ERROR THEN
323: ROLLBACK TO invoke_new_del_status_wf;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: ROLLBACK TO invoke_new_del_status_wf;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: ROLLBACK TO invoke_new_del_status_wf;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
331:
332: WHEN OTHERS THEN
333: ROLLBACK TO invoke_new_del_status_wf;
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331:
332: WHEN OTHERS THEN
333: ROLLBACK TO invoke_new_del_status_wf;
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
336: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
337: END IF;
338: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
339: --End bug 6740370 gnramasa 11th Jan 08
332: WHEN OTHERS THEN
333: ROLLBACK TO invoke_new_del_status_wf;
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
336: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
337: END IF;
338: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
339: --End bug 6740370 gnramasa 11th Jan 08
340: ----------------------------------
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
336: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
337: END IF;
338: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
339: --End bug 6740370 gnramasa 11th Jan 08
340: ----------------------------------
341: END invoke_upd_del_status_wf;
342: