64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.to_Boolean( p_init_msg_list )
67: THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70:
71: -- Debug Message
72: -- IF PG_DEBUG < 10 THEN
96:
97: -- TEST TO CATCH ERROR HERE
98: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
99: FND_MESSAGE.SET_NAME('IEX', 'IEX_DISPUTE_FAILED');
100: FND_MSG_PUB.Add;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: RAISE FND_API.G_EXC_ERROR;
103:
104: END IF ;
115: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'PVT: ' || l_api_name || ' end');
116: END IF;
117:
118: -- Standard call to get message count and if count is 1, get message info.
119: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
120: p_data => x_msg_data);
121:
122:
123: EXCEPTION
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: ROLLBACK TO create_dispute_pub;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: ROLLBACK TO create_dispute_pub;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
127: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: ROLLBACK TO create_dispute_pub;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
132: WHEN OTHERS THEN
133: ROLLBACK TO create_dispute_pub;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
132: WHEN OTHERS THEN
133: ROLLBACK TO create_dispute_pub;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
138: END IF;
139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
133: ROLLBACK TO create_dispute_pub;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
138: END IF;
139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
140:
141: END create_dispute;
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
138: END IF;
139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
140:
141: END create_dispute;
142:
143:
181:
182: -- Initialize message list if p_init_msg_list is set to TRUE.
183: IF FND_API.to_Boolean( p_init_msg_list )
184: THEN
185: FND_MSG_PUB.initialize;
186: END IF;
187:
188: -- Debug Message
189: -- IF PG_DEBUG < 10 THEN
206: x_msg_data := l_msg_data ;
207:
208: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
209: FND_MESSAGE.SET_NAME('IEX', 'IEX_DISPUTE_DELINQUENT_FAILED');
210: FND_MSG_PUB.Add;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: RAISE FND_API.G_EXC_ERROR;
213:
214: END IF ;
221: IEX_DEBUG_PUB.logMessage('is_delinquency_dispute: ' || 'PVT: ' || l_api_name || ' end');
222: END IF;
223:
224: -- Standard call to get message count and if count is 1, get message info.
225: FND_MSG_PUB.Count_And_Get
226: ( p_count => x_msg_count,
227: p_data => x_msg_data
228: );
229:
230: EXCEPTION
231: WHEN FND_API.G_EXC_ERROR THEN
232: ROLLBACK TO is_delinquency_pvt;
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: ROLLBACK TO is_delinquency_pvt;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: ROLLBACK TO is_delinquency_pvt;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
239: WHEN OTHERS THEN
240: ROLLBACK TO is_delinquency_pvt;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
239: WHEN OTHERS THEN
240: ROLLBACK TO is_delinquency_pvt;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
243: THEN
244: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
245: END IF;
246: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
240: ROLLBACK TO is_delinquency_pvt;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
243: THEN
244: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
245: END IF;
246: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
247:
248: END is_delinquency_dispute;
242: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
243: THEN
244: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
245: END IF;
246: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
247:
248: END is_delinquency_dispute;
249:
250: --Start bug 6856035 gnramasa 28th May 08
334: IEX_DEBUG_PUB.logMessage('Cancel_Dispute: ' || 'PVT: ' || l_api_name || ' end');
335: END IF;
336:
337: -- Standard call to get message count and if count is 1, get message info.
338: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
339: p_data => x_msg_data);
340:
341:
342: EXCEPTION
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO cancel_dispute_pub;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
348: ROLLBACK TO cancel_dispute_pub;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
348: ROLLBACK TO cancel_dispute_pub;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
351: WHEN OTHERS THEN
352: ROLLBACK TO cancel_dispute_pub;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
351: WHEN OTHERS THEN
352: ROLLBACK TO cancel_dispute_pub;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
355: THEN
356: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
357: END IF;
358: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
352: ROLLBACK TO cancel_dispute_pub;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
355: THEN
356: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
357: END IF;
358: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
359:
360: END cancel_dispute;
354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
355: THEN
356: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
357: END IF;
358: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
359:
360: END cancel_dispute;
361: --End bug 6856035 gnramasa 28th May 08
362: