51: END IF;
52:
53: /* Initialize message list if p_init_msg_list is set to TRUE */
54: IF FND_API.To_Boolean(p_init_msg_list) THEN
55: FND_MSG_PUB.initialize;
56: END IF;
57:
58: /* Initialize API return status to success */
59:
88: COMMIT WORK;
89: END IF;
90:
91: /* Standard call to get message count and if count is 1, get message info */
92: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO IEX_ROUTING_PVT;
96: x_return_status := FND_API.G_RET_STS_ERROR;
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO IEX_ROUTING_PVT;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
99: ROLLBACK TO IEX_ROUTING_PVT;
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
97: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
99: ROLLBACK TO IEX_ROUTING_PVT;
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
102: WHEN OTHERS THEN
103: ROLLBACK TO IEX_ROUTING_PVT;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
102: WHEN OTHERS THEN
103: ROLLBACK TO IEX_ROUTING_PVT;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
106: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
107: END IF;
108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
109:
102: WHEN OTHERS THEN
103: ROLLBACK TO IEX_ROUTING_PVT;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
106: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
107: END IF;
108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
109:
110: END isCustomerOverdue;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
106: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
107: END IF;
108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
109:
110: END isCustomerOverdue;
111:
112: PROCEDURE getCollectors ( p_api_version in number,
142: END IF;
143:
144: /* Initialize message list if p_init_msg_list is set to TRUE */
145: IF FND_API.To_Boolean(p_init_msg_list) THEN
146: FND_MSG_PUB.initialize;
147: END IF;
148:
149: /* Initialize API return status to success */
150:
165: COMMIT WORK;
166: END IF;
167:
168: /* Standard call to get message count and if count is 1, get message info */
169: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: ROLLBACK TO IEX_ROUTING_PVT;
173: x_return_status := FND_API.G_RET_STS_ERROR;
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: ROLLBACK TO IEX_ROUTING_PVT;
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK TO IEX_ROUTING_PVT;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
174: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK TO IEX_ROUTING_PVT;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN OTHERS THEN
180: ROLLBACK TO IEX_ROUTING_PVT;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN OTHERS THEN
180: ROLLBACK TO IEX_ROUTING_PVT;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
184: END IF;
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
186:
179: WHEN OTHERS THEN
180: ROLLBACK TO IEX_ROUTING_PVT;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
184: END IF;
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
186:
187: END getCollectors;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
184: END IF;
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
186:
187: END getCollectors;
188:
189: END IEX_ROUTING_PVT;