eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on FND_API

Line 22: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

18: | 14-NOV-2002 mchang Create.
19: *=======================================================================*/
20: PROCEDURE Default_Claim_Line(
21: p_api_version IN NUMBER
22: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
23: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
24:
25: ,x_return_status OUT NOCOPY VARCHAR2
26: ,x_msg_data OUT NOCOPY VARCHAR2

Line 23: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

19: *=======================================================================*/
20: PROCEDURE Default_Claim_Line(
21: p_api_version IN NUMBER
22: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
23: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
24:
25: ,x_return_status OUT NOCOPY VARCHAR2
26: ,x_msg_data OUT NOCOPY VARCHAR2
27: ,x_msg_count OUT NOCOPY NUMBER

Line 51: x_return_status := FND_API.g_ret_sts_success;

47: OZF_Utility_PVT.debug_message(l_full_name||' : start');
48: END IF;
49:
50: -- Initialize API return status to sucess
51: x_return_status := FND_API.g_ret_sts_success;
52:
53: ------------------------------------------------
54: IF p_x_claim_line_rec.source_object_class IS NULL THEN
55: p_x_claim_line_rec.source_object_id := NULL;

Line 67: IF p_def_from_tbl_flag = FND_API.g_false THEN

63: OPEN csr_settlement_method(p_x_claim_line_rec.claim_id);
64: FETCH csr_settlement_method INTO l_settlement_method;
65: CLOSE csr_settlement_method;
66:
67: IF p_def_from_tbl_flag = FND_API.g_false THEN
68: IF l_settlement_method = 'RMA' THEN
69: OZF_OM_VALIDATION_PVT.Default_Claim_Line(
70: p_api_version => l_api_version
71: ,p_init_msg_list => p_init_msg_list

Line 78: IF l_return_status = FND_API.g_ret_sts_error THEN

74: ,x_msg_data => x_msg_data
75: ,x_msg_count => x_msg_count
76: ,p_x_claim_line_rec => p_x_claim_line_rec
77: );
78: IF l_return_status = FND_API.g_ret_sts_error THEN
79: RAISE FND_API.g_exc_error;
80: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
81: RAISE FND_API.g_exc_unexpected_error;
82: END IF;

Line 79: RAISE FND_API.g_exc_error;

75: ,x_msg_count => x_msg_count
76: ,p_x_claim_line_rec => p_x_claim_line_rec
77: );
78: IF l_return_status = FND_API.g_ret_sts_error THEN
79: RAISE FND_API.g_exc_error;
80: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
81: RAISE FND_API.g_exc_unexpected_error;
82: END IF;
83: END IF;

Line 80: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

76: ,p_x_claim_line_rec => p_x_claim_line_rec
77: );
78: IF l_return_status = FND_API.g_ret_sts_error THEN
79: RAISE FND_API.g_exc_error;
80: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
81: RAISE FND_API.g_exc_unexpected_error;
82: END IF;
83: END IF;
84: END IF;

Line 81: RAISE FND_API.g_exc_unexpected_error;

77: );
78: IF l_return_status = FND_API.g_ret_sts_error THEN
79: RAISE FND_API.g_exc_error;
80: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
81: RAISE FND_API.g_exc_unexpected_error;
82: END IF;
83: END IF;
84: END IF;
85:

Line 90: WHEN FND_API.G_EXC_ERROR THEN

86: IF OZF_DEBUG_HIGH_ON THEN
87: OZF_Utility_PVT.debug_message(l_full_name||' : end');
88: END IF;
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_ERROR;
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: WHEN OTHERS THEN

Line 91: x_return_status := FND_API.G_RET_STS_ERROR;

87: OZF_Utility_PVT.debug_message(l_full_name||' : end');
88: END IF;
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_ERROR;
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: WHEN OTHERS THEN
95: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

88: END IF;
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_ERROR;
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: WHEN OTHERS THEN
95: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
96: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_ERROR;
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: WHEN OTHERS THEN
95: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
96: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
97: END IF;

Line 98: x_return_status := FND_API.g_ret_sts_unexp_error;

94: WHEN OTHERS THEN
95: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
96: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
97: END IF;
98: x_return_status := FND_API.g_ret_sts_unexp_error;
99:
100: END Default_Claim_Line;
101:
102:

Line 145: x_return_status := FND_API.g_ret_sts_success;

141: OZF_Utility_PVT.debug_message(l_full_name||' : start');
142: END IF;
143:
144: -- Initialize API return status to sucess
145: x_return_status := FND_API.g_ret_sts_success;
146:
147: i := p_x_claim_line_tbl.FIRST;
148: IF i IS NOT NULL THEN
149: LOOP

Line 159: ,p_def_from_tbl_flag => FND_API.g_true

155: ,x_return_status => l_return_status
156: ,x_msg_data => x_msg_data
157: ,x_msg_count => x_msg_count
158: ,p_x_claim_line_rec => l_claim_line_rec
159: ,p_def_from_tbl_flag => FND_API.g_true
160: );
161: p_x_claim_line_tbl(i) := l_claim_line_rec;
162: IF l_return_status = FND_API.g_ret_sts_error THEN
163: RAISE FND_API.g_exc_error;

Line 162: IF l_return_status = FND_API.g_ret_sts_error THEN

158: ,p_x_claim_line_rec => l_claim_line_rec
159: ,p_def_from_tbl_flag => FND_API.g_true
160: );
161: p_x_claim_line_tbl(i) := l_claim_line_rec;
162: IF l_return_status = FND_API.g_ret_sts_error THEN
163: RAISE FND_API.g_exc_error;
164: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
165: RAISE FND_API.g_exc_unexpected_error;
166: END IF;

Line 163: RAISE FND_API.g_exc_error;

159: ,p_def_from_tbl_flag => FND_API.g_true
160: );
161: p_x_claim_line_tbl(i) := l_claim_line_rec;
162: IF l_return_status = FND_API.g_ret_sts_error THEN
163: RAISE FND_API.g_exc_error;
164: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
165: RAISE FND_API.g_exc_unexpected_error;
166: END IF;
167: EXIT WHEN i = p_x_claim_line_tbl.LAST;

Line 164: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

160: );
161: p_x_claim_line_tbl(i) := l_claim_line_rec;
162: IF l_return_status = FND_API.g_ret_sts_error THEN
163: RAISE FND_API.g_exc_error;
164: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
165: RAISE FND_API.g_exc_unexpected_error;
166: END IF;
167: EXIT WHEN i = p_x_claim_line_tbl.LAST;
168: i := p_x_claim_line_tbl.NEXT(i);

Line 165: RAISE FND_API.g_exc_unexpected_error;

161: p_x_claim_line_tbl(i) := l_claim_line_rec;
162: IF l_return_status = FND_API.g_ret_sts_error THEN
163: RAISE FND_API.g_exc_error;
164: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
165: RAISE FND_API.g_exc_unexpected_error;
166: END IF;
167: EXIT WHEN i = p_x_claim_line_tbl.LAST;
168: i := p_x_claim_line_tbl.NEXT(i);
169: END LOOP;

Line 185: IF l_return_status = FND_API.g_ret_sts_error THEN

181: ,x_msg_data => x_msg_data
182: ,x_msg_count => x_msg_count
183: ,p_x_claim_line_tbl => p_x_claim_line_tbl
184: );
185: IF l_return_status = FND_API.g_ret_sts_error THEN
186: RAISE FND_API.g_exc_error;
187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
188: RAISE FND_API.g_exc_unexpected_error;
189: END IF;

Line 186: RAISE FND_API.g_exc_error;

182: ,x_msg_count => x_msg_count
183: ,p_x_claim_line_tbl => p_x_claim_line_tbl
184: );
185: IF l_return_status = FND_API.g_ret_sts_error THEN
186: RAISE FND_API.g_exc_error;
187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
188: RAISE FND_API.g_exc_unexpected_error;
189: END IF;
190: END IF;

Line 187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

183: ,p_x_claim_line_tbl => p_x_claim_line_tbl
184: );
185: IF l_return_status = FND_API.g_ret_sts_error THEN
186: RAISE FND_API.g_exc_error;
187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
188: RAISE FND_API.g_exc_unexpected_error;
189: END IF;
190: END IF;
191: END IF;

Line 188: RAISE FND_API.g_exc_unexpected_error;

184: );
185: IF l_return_status = FND_API.g_ret_sts_error THEN
186: RAISE FND_API.g_exc_error;
187: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
188: RAISE FND_API.g_exc_unexpected_error;
189: END IF;
190: END IF;
191: END IF;
192:

Line 197: WHEN FND_API.G_EXC_ERROR THEN

193: IF OZF_DEBUG_HIGH_ON THEN
194: OZF_Utility_PVT.debug_message(l_full_name||' : end');
195: END IF;
196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: WHEN OTHERS THEN

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: OZF_Utility_PVT.debug_message(l_full_name||' : end');
195: END IF;
196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: WHEN OTHERS THEN
202: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

195: END IF;
196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: WHEN OTHERS THEN
202: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
203: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: WHEN OTHERS THEN
202: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
203: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
204: END IF;

Line 205: x_return_status := FND_API.g_ret_sts_unexp_error;

201: WHEN OTHERS THEN
202: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
203: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
204: END IF;
205: x_return_status := FND_API.g_ret_sts_unexp_error;
206:
207: END Default_Claim_Line_Tbl;
208:
209:

Line 222: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

218: | 30-NOV-2002 mchang Create.
219: *=======================================================================*/
220: PROCEDURE Validate_Claim_Line(
221: p_api_version IN NUMBER
222: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
223: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
224:
225: ,x_return_status OUT NOCOPY VARCHAR2
226: ,x_msg_data OUT NOCOPY VARCHAR2

Line 223: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

219: *=======================================================================*/
220: PROCEDURE Validate_Claim_Line(
221: p_api_version IN NUMBER
222: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
223: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
224:
225: ,x_return_status OUT NOCOPY VARCHAR2
226: ,x_msg_data OUT NOCOPY VARCHAR2
227: ,x_msg_count OUT NOCOPY NUMBER

Line 252: x_return_status := FND_API.g_ret_sts_success;

248: OZF_Utility_PVT.debug_message(l_full_name||' : start');
249: END IF;
250:
251: -- Initialize API return status to sucess
252: x_return_status := FND_API.g_ret_sts_success;
253:
254: OPEN csr_settlement_method(p_claim_line_rec.claim_id);
255: FETCH csr_settlement_method INTO l_settlement_method;
256: CLOSE csr_settlement_method;

Line 258: IF p_val_from_tbl_flag = FND_API.g_false THEN

254: OPEN csr_settlement_method(p_claim_line_rec.claim_id);
255: FETCH csr_settlement_method INTO l_settlement_method;
256: CLOSE csr_settlement_method;
257:
258: IF p_val_from_tbl_flag = FND_API.g_false THEN
259: IF l_settlement_method = 'RMA' THEN
260: OZF_OM_VALIDATION_PVT.Validate_Claim_Line(
261: p_api_version => l_api_version
262: ,p_init_msg_list => p_init_msg_list

Line 269: IF l_return_status = FND_API.g_ret_sts_error THEN

265: ,x_msg_data => x_msg_data
266: ,x_msg_count => x_msg_count
267: ,p_claim_line_rec => p_claim_line_rec
268: );
269: IF l_return_status = FND_API.g_ret_sts_error THEN
270: RAISE FND_API.g_exc_error;
271: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
272: RAISE FND_API.g_exc_unexpected_error;
273: END IF;

Line 270: RAISE FND_API.g_exc_error;

266: ,x_msg_count => x_msg_count
267: ,p_claim_line_rec => p_claim_line_rec
268: );
269: IF l_return_status = FND_API.g_ret_sts_error THEN
270: RAISE FND_API.g_exc_error;
271: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
272: RAISE FND_API.g_exc_unexpected_error;
273: END IF;
274: END IF;

Line 271: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

267: ,p_claim_line_rec => p_claim_line_rec
268: );
269: IF l_return_status = FND_API.g_ret_sts_error THEN
270: RAISE FND_API.g_exc_error;
271: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
272: RAISE FND_API.g_exc_unexpected_error;
273: END IF;
274: END IF;
275: END IF;

Line 272: RAISE FND_API.g_exc_unexpected_error;

268: );
269: IF l_return_status = FND_API.g_ret_sts_error THEN
270: RAISE FND_API.g_exc_error;
271: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
272: RAISE FND_API.g_exc_unexpected_error;
273: END IF;
274: END IF;
275: END IF;
276:

Line 281: WHEN FND_API.G_EXC_ERROR THEN

277: IF OZF_DEBUG_HIGH_ON THEN
278: OZF_Utility_PVT.debug_message(l_full_name||' : end');
279: END IF;
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: WHEN OTHERS THEN

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278: OZF_Utility_PVT.debug_message(l_full_name||' : end');
279: END IF;
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: WHEN OTHERS THEN
286: IF OZF_DEBUG_LOW_ON THEN

Line 283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

279: END IF;
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: WHEN OTHERS THEN
286: IF OZF_DEBUG_LOW_ON THEN
287: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: WHEN OTHERS THEN
286: IF OZF_DEBUG_LOW_ON THEN
287: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
288: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');

Line 291: x_return_status := FND_API.g_ret_sts_unexp_error;

287: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
288: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
289: FND_MSG_PUB.Add;
290: END IF;
291: x_return_status := FND_API.g_ret_sts_unexp_error;
292:
293: END Validate_Claim_Line;
294:
295:

Line 308: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

304: | 30-NOV-2002 mchang Create.
305: *=======================================================================*/
306: PROCEDURE Validate_Claim_Line_Tbl(
307: p_api_version IN NUMBER
308: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
309: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
310:
311: ,x_return_status OUT NOCOPY VARCHAR2
312: ,x_msg_data OUT NOCOPY VARCHAR2

Line 309: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

305: *=======================================================================*/
306: PROCEDURE Validate_Claim_Line_Tbl(
307: p_api_version IN NUMBER
308: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
309: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
310:
311: ,x_return_status OUT NOCOPY VARCHAR2
312: ,x_msg_data OUT NOCOPY VARCHAR2
313: ,x_msg_count OUT NOCOPY NUMBER

Line 340: x_return_status := FND_API.g_ret_sts_success;

336: OZF_Utility_PVT.debug_message(l_full_name||' : start');
337: END IF;
338:
339: -- Initialize API return status to sucess
340: x_return_status := FND_API.g_ret_sts_success;
341:
342: i := p_claim_line_tbl.FIRST ;
343: IF i IS NOT NULL THEN
344: LOOP

Line 354: ,p_val_from_tbl_flag => FND_API.g_true

350: ,x_return_status => l_return_status
351: ,x_msg_data => x_msg_data
352: ,x_msg_count => x_msg_count
353: ,p_claim_line_rec => l_claim_line_rec
354: ,p_val_from_tbl_flag => FND_API.g_true
355: );
356: IF l_return_status = FND_API.g_ret_sts_error THEN
357: RAISE FND_API.g_exc_error;
358: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 356: IF l_return_status = FND_API.g_ret_sts_error THEN

352: ,x_msg_count => x_msg_count
353: ,p_claim_line_rec => l_claim_line_rec
354: ,p_val_from_tbl_flag => FND_API.g_true
355: );
356: IF l_return_status = FND_API.g_ret_sts_error THEN
357: RAISE FND_API.g_exc_error;
358: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
359: RAISE FND_API.g_exc_unexpected_error;
360: END IF;

Line 357: RAISE FND_API.g_exc_error;

353: ,p_claim_line_rec => l_claim_line_rec
354: ,p_val_from_tbl_flag => FND_API.g_true
355: );
356: IF l_return_status = FND_API.g_ret_sts_error THEN
357: RAISE FND_API.g_exc_error;
358: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
359: RAISE FND_API.g_exc_unexpected_error;
360: END IF;
361: EXIT WHEN i = p_claim_line_tbl.LAST;

Line 358: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

354: ,p_val_from_tbl_flag => FND_API.g_true
355: );
356: IF l_return_status = FND_API.g_ret_sts_error THEN
357: RAISE FND_API.g_exc_error;
358: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
359: RAISE FND_API.g_exc_unexpected_error;
360: END IF;
361: EXIT WHEN i = p_claim_line_tbl.LAST;
362: i := p_claim_line_tbl.NEXT(i);

Line 359: RAISE FND_API.g_exc_unexpected_error;

355: );
356: IF l_return_status = FND_API.g_ret_sts_error THEN
357: RAISE FND_API.g_exc_error;
358: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
359: RAISE FND_API.g_exc_unexpected_error;
360: END IF;
361: EXIT WHEN i = p_claim_line_tbl.LAST;
362: i := p_claim_line_tbl.NEXT(i);
363: END LOOP;

Line 379: IF l_return_status = FND_API.g_ret_sts_error THEN

375: ,x_msg_data => x_msg_data
376: ,x_msg_count => x_msg_count
377: ,p_claim_line_tbl => p_claim_line_tbl
378: );
379: IF l_return_status = FND_API.g_ret_sts_error THEN
380: RAISE FND_API.g_exc_error;
381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
382: RAISE FND_API.g_exc_unexpected_error;
383: END IF;

Line 380: RAISE FND_API.g_exc_error;

376: ,x_msg_count => x_msg_count
377: ,p_claim_line_tbl => p_claim_line_tbl
378: );
379: IF l_return_status = FND_API.g_ret_sts_error THEN
380: RAISE FND_API.g_exc_error;
381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
382: RAISE FND_API.g_exc_unexpected_error;
383: END IF;
384: END IF;

Line 381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

377: ,p_claim_line_tbl => p_claim_line_tbl
378: );
379: IF l_return_status = FND_API.g_ret_sts_error THEN
380: RAISE FND_API.g_exc_error;
381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
382: RAISE FND_API.g_exc_unexpected_error;
383: END IF;
384: END IF;
385: END IF;

Line 382: RAISE FND_API.g_exc_unexpected_error;

378: );
379: IF l_return_status = FND_API.g_ret_sts_error THEN
380: RAISE FND_API.g_exc_error;
381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
382: RAISE FND_API.g_exc_unexpected_error;
383: END IF;
384: END IF;
385: END IF;
386:

Line 388: RAISE FND_API.G_EXC_ERROR;

384: END IF;
385: END IF;
386:
387: IF l_error THEN
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390:
391:
392: IF OZF_DEBUG_HIGH_ON THEN

Line 396: WHEN FND_API.G_EXC_ERROR THEN

392: IF OZF_DEBUG_HIGH_ON THEN
393: OZF_Utility_PVT.debug_message(l_full_name||' : end');
394: END IF;
395: EXCEPTION
396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: WHEN OTHERS THEN

Line 397: x_return_status := FND_API.G_RET_STS_ERROR;

393: OZF_Utility_PVT.debug_message(l_full_name||' : end');
394: END IF;
395: EXCEPTION
396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: WHEN OTHERS THEN
401: IF OZF_DEBUG_LOW_ON THEN

Line 398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

394: END IF;
395: EXCEPTION
396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: WHEN OTHERS THEN
401: IF OZF_DEBUG_LOW_ON THEN
402: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: EXCEPTION
396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: WHEN OTHERS THEN
401: IF OZF_DEBUG_LOW_ON THEN
402: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
403: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');

Line 406: x_return_status := FND_API.g_ret_sts_unexp_error;

402: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
403: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
404: FND_MSG_PUB.Add;
405: END IF;
406: x_return_status := FND_API.g_ret_sts_unexp_error;
407:
408: END Validate_Claim_Line_Tbl;
409:
410:

Line 498: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

494: | 24-OCT-2002 mchang Create.
495: *=======================================================================*/
496: PROCEDURE Complete_Claim_Validation(
497: p_api_version IN NUMBER
498: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
499: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
500:
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_data OUT NOCOPY VARCHAR2

Line 499: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

495: *=======================================================================*/
496: PROCEDURE Complete_Claim_Validation(
497: p_api_version IN NUMBER
498: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
499: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
500:
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_data OUT NOCOPY VARCHAR2
503: ,x_msg_count OUT NOCOPY NUMBER

Line 512: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;

508: IS
509: l_api_version CONSTANT NUMBER := 1.0;
510: l_api_name CONSTANT VARCHAR2(30) := 'Complete_Claim_Validation';
511: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
512: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;
513:
514: --Added claim_currency_amount check for bug 6828924.
515: CURSOR csr_claim_line(cv_claim_id IN NUMBER) IS
516: SELECT claim_line_id

Line 686: x_return_status := FND_API.g_ret_sts_success;

682: OZF_Utility_PVT.debug_message(l_full_name||' : start');
683: END IF;
684:
685: -- Initialize API return status to sucess
686: x_return_status := FND_API.g_ret_sts_success;
687:
688: x_claim_rec := p_claim_rec;
689:
690: ---------------------------

Line 710: IF (p_claim_rec.payment_method IS NULL OR p_claim_rec.payment_method = FND_API.G_MISS_CHAR

706: IF OZF_DEBUG_HIGH_ON THEN
707: OZF_Utility_PVT.debug_message('p_claim_rec.payment_method:' || p_claim_rec.payment_method);
708: END IF;
709:
710: IF (p_claim_rec.payment_method IS NULL OR p_claim_rec.payment_method = FND_API.G_MISS_CHAR
711: OR p_claim_rec.payment_method = '' ) THEN
712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
713: FND_MESSAGE.set_name('OZF', 'OZF_SETL_PAYMETHOD_REQ');
714: FND_MSG_PUB.add;

Line 716: RAISE FND_API.G_EXC_ERROR;

712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
713: FND_MESSAGE.set_name('OZF', 'OZF_SETL_PAYMETHOD_REQ');
714: FND_MSG_PUB.add;
715: END IF;
716: RAISE FND_API.G_EXC_ERROR;
717: END IF;
718:
719: -- Query Claim Line records
720: OPEN csr_claim_line(p_claim_rec.claim_id);

Line 735: IF l_line_earnings_flag = FND_API.g_true THEN

731: , l_line_src_obj_line_id
732: , l_line_item_id;
733: EXIT WHEN csr_claim_line%NOTFOUND;
734:
735: IF l_line_earnings_flag = FND_API.g_true THEN
736: l_asso_earnings_exist :=TRUE;
737:
738: IF NOT l_offr_perf_flag_err THEN
739: -- offer performance checking (1)

Line 744: IF l_line_perf_comp_flag <> FND_API.g_true THEN

740: OPEN csr_asso_offr_performance(l_claim_line_id);
741: LOOP
742: FETCH csr_asso_offr_performance INTO l_asso_offr_perf_id;
743: EXIT WHEN csr_asso_offr_performance%NOTFOUND;
744: IF l_line_perf_comp_flag <> FND_API.g_true THEN
745: l_offr_perf_flag_err := TRUE;
746: EXIT;
747: END IF;
748: END LOOP;

Line 759: IF l_line_perf_comp_flag <> FND_API.g_true THEN

755: OPEN csr_line_offr_performance(l_claim_line_id);
756: LOOP
757: FETCH csr_line_offr_performance INTO l_asso_offr_perf_id;
758: EXIT WHEN csr_line_offr_performance%NOTFOUND;
759: IF l_line_perf_comp_flag <> FND_API.g_true THEN
760: l_offr_perf_flag_err := TRUE;
761: EXIT;
762: END IF;
763: END LOOP;

Line 840: RAISE FND_API.G_EXC_ERROR;

836: END LOOP;
837: CLOSE csr_claim_line;
838:
839: IF l_error THEN
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842:
843: ---------------------- Validation -----------------------------
844: -----------------------------------------------------

Line 884: RAISE FND_API.G_EXC_ERROR;

880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
881: FND_MESSAGE.set_name('OZF', 'OZF_POST_ASSO_PAYMETHOD_ERR');
882: FND_MSG_PUB.add;
883: END IF;
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886: ELSE
887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
888: FND_MESSAGE.set_name('OZF', 'OZF_SETL_ASSO_PAYMETHOD_ERR');

Line 891: RAISE FND_API.G_EXC_ERROR;

887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
888: FND_MESSAGE.set_name('OZF', 'OZF_SETL_ASSO_PAYMETHOD_ERR');
889: FND_MSG_PUB.add;
890: END IF;
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;
893: END IF;
894:
895: ---------------------------

Line 904: RAISE FND_API.G_EXC_ERROR;

900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
901: FND_MESSAGE.set_name('OZF', 'OZF_SETL_COMP_LINE_UTIL_ERR');
902: FND_MSG_PUB.add;
903: END IF;
904: RAISE FND_API.G_EXC_ERROR;
905: END IF;
906:
907: -- raise error if performance complete is required.
908: IF l_offr_perf_flag_err THEN

Line 913: RAISE FND_API.G_EXC_ERROR;

909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
910: FND_MESSAGE.set_name('OZF', 'OZF_SETL_COMP_LINE_PERF_ERR');
911: FND_MSG_PUB.add;
912: END IF;
913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915:
916: --//Bugfix : 13069412
917: OPEN csr_sum_line_amt(p_claim_rec.claim_id);

Line 934: RAISE FND_API.G_EXC_ERROR;

930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
931: FND_MESSAGE.set_name('OZF', 'OZF_SETL_LINE_AMT_ERR');
932: FND_MSG_PUB.add;
933: END IF;
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936:
937: -- For payment_method other then credit memo or debit memo without specifying payment_reference,
938: -- sum of line.claim_currency_amount should be equal to amount_remaining in claim.

Line 951: RAISE FND_API.G_EXC_ERROR;

947: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
948: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_SETL_AMOUNT_ERR');
949: FND_MSG_PUB.add;
950: END IF;
951: RAISE FND_API.G_EXC_ERROR;
952: ELSIF l_line_sum_curr_amt <> p_claim_rec.amount_remaining THEN
953: IF p_claim_rec.payment_method IN ('CREDIT_MEMO',
954: 'DEBIT_MEMO',
955: 'RMA',

Line 968: RAISE FND_API.G_EXC_ERROR;

964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
965: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_SETL_AMOUNT_ERR');
966: FND_MSG_PUB.add;
967: END IF;
968: RAISE FND_API.G_EXC_ERROR;
969: END IF;
970: END IF;
971:
972: ---------------------------

Line 993: RAISE FND_API.G_EXC_ERROR;

989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
990: FND_MESSAGE.set_name('OZF', 'OZF_SETL_COMP_LINE_PROM_ERR');
991: FND_MSG_PUB.add;
992: END IF;
993: RAISE FND_API.G_EXC_ERROR;
994: END IF;
995:
996:
997: ---------------------------

Line 1005: RAISE FND_API.G_EXC_ERROR;

1001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1002: FND_MESSAGE.set_name('OZF', 'OZF_SETL_OWNER_REQ');
1003: FND_MSG_PUB.add;
1004: END IF;
1005: RAISE FND_API.G_EXC_ERROR;
1006: END IF;
1007:
1008: ---------------------------
1009: -- GL Date: should fall into an open period if entered.

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1042: FND_MESSAGE.set_name('OZF', 'OZF_SETL_GLDATE_INVALID');
1043: FND_MSG_PUB.add;
1044: END IF;
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:
1048: ELSIF p_claim_rec.payment_method IN ('CHECK', 'CONTRA_CHARGE','EFT','WIRE','AP_DEBIT','AP_DEFAULT') THEN
1049: IF NOT gl_date_in_open(

Line 1058: RAISE FND_API.G_EXC_ERROR;

1054: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1055: FND_MESSAGE.set_name('OZF', 'OZF_SETL_GLDATE_INVALID');
1056: FND_MSG_PUB.add;
1057: END IF;
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060: END IF;
1061: ELSE
1062:

Line 1068: RAISE FND_API.G_EXC_ERROR;

1064: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1065: FND_MESSAGE.set_name('OZF', 'OZF_SETL_GLDATE_DRIVE_ERR');
1066: FND_MSG_PUB.add;
1067: END IF;
1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070: END IF;
1071:
1072:

Line 1088: ,p_init_msg_list => FND_API.g_false

1084: ) THEN
1085:
1086: OZF_AR_VALIDATION_PVT.Complete_AR_Validation(
1087: p_api_version => l_api_version
1088: ,p_init_msg_list => FND_API.g_false
1089: ,p_commit => FND_API.g_false
1090: ,p_validation_level => FND_API.g_valid_level_full
1091: ,x_return_status => l_return_status
1092: ,x_msg_data => x_msg_data

Line 1089: ,p_commit => FND_API.g_false

1085:
1086: OZF_AR_VALIDATION_PVT.Complete_AR_Validation(
1087: p_api_version => l_api_version
1088: ,p_init_msg_list => FND_API.g_false
1089: ,p_commit => FND_API.g_false
1090: ,p_validation_level => FND_API.g_valid_level_full
1091: ,x_return_status => l_return_status
1092: ,x_msg_data => x_msg_data
1093: ,x_msg_count => x_msg_count

Line 1090: ,p_validation_level => FND_API.g_valid_level_full

1086: OZF_AR_VALIDATION_PVT.Complete_AR_Validation(
1087: p_api_version => l_api_version
1088: ,p_init_msg_list => FND_API.g_false
1089: ,p_commit => FND_API.g_false
1090: ,p_validation_level => FND_API.g_valid_level_full
1091: ,x_return_status => l_return_status
1092: ,x_msg_data => x_msg_data
1093: ,x_msg_count => x_msg_count
1094: ,p_claim_rec => p_claim_rec

Line 1096: IF l_return_status = FND_API.g_ret_sts_error THEN

1092: ,x_msg_data => x_msg_data
1093: ,x_msg_count => x_msg_count
1094: ,p_claim_rec => p_claim_rec
1095: );
1096: IF l_return_status = FND_API.g_ret_sts_error THEN
1097: RAISE FND_API.g_exc_error;
1098: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1099: RAISE FND_API.g_exc_unexpected_error;
1100: END IF;

Line 1097: RAISE FND_API.g_exc_error;

1093: ,x_msg_count => x_msg_count
1094: ,p_claim_rec => p_claim_rec
1095: );
1096: IF l_return_status = FND_API.g_ret_sts_error THEN
1097: RAISE FND_API.g_exc_error;
1098: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1099: RAISE FND_API.g_exc_unexpected_error;
1100: END IF;
1101:

Line 1098: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1094: ,p_claim_rec => p_claim_rec
1095: );
1096: IF l_return_status = FND_API.g_ret_sts_error THEN
1097: RAISE FND_API.g_exc_error;
1098: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1099: RAISE FND_API.g_exc_unexpected_error;
1100: END IF;
1101:
1102: /*------------------------------------------------------------------------------*

Line 1099: RAISE FND_API.g_exc_unexpected_error;

1095: );
1096: IF l_return_status = FND_API.g_ret_sts_error THEN
1097: RAISE FND_API.g_exc_error;
1098: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1099: RAISE FND_API.g_exc_unexpected_error;
1100: END IF;
1101:
1102: /*------------------------------------------------------------------------------*
1103: | RMA Validation |

Line 1108: ,p_init_msg_list => FND_API.g_false

1104: *------------------------------------------------------------------------------*/
1105: ELSIF p_claim_rec.payment_method = 'RMA' THEN
1106: OZF_AR_VALIDATION_PVT.Complete_AR_Validation(
1107: p_api_version => l_api_version
1108: ,p_init_msg_list => FND_API.g_false
1109: ,p_commit => FND_API.g_false
1110: ,p_validation_level => FND_API.g_valid_level_full
1111: ,x_return_status => l_return_status
1112: ,x_msg_data => x_msg_data

Line 1109: ,p_commit => FND_API.g_false

1105: ELSIF p_claim_rec.payment_method = 'RMA' THEN
1106: OZF_AR_VALIDATION_PVT.Complete_AR_Validation(
1107: p_api_version => l_api_version
1108: ,p_init_msg_list => FND_API.g_false
1109: ,p_commit => FND_API.g_false
1110: ,p_validation_level => FND_API.g_valid_level_full
1111: ,x_return_status => l_return_status
1112: ,x_msg_data => x_msg_data
1113: ,x_msg_count => x_msg_count

Line 1110: ,p_validation_level => FND_API.g_valid_level_full

1106: OZF_AR_VALIDATION_PVT.Complete_AR_Validation(
1107: p_api_version => l_api_version
1108: ,p_init_msg_list => FND_API.g_false
1109: ,p_commit => FND_API.g_false
1110: ,p_validation_level => FND_API.g_valid_level_full
1111: ,x_return_status => l_return_status
1112: ,x_msg_data => x_msg_data
1113: ,x_msg_count => x_msg_count
1114: ,p_claim_rec => p_claim_rec

Line 1116: IF l_return_status = FND_API.g_ret_sts_error THEN

1112: ,x_msg_data => x_msg_data
1113: ,x_msg_count => x_msg_count
1114: ,p_claim_rec => p_claim_rec
1115: );
1116: IF l_return_status = FND_API.g_ret_sts_error THEN
1117: RAISE FND_API.g_exc_error;
1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1119: RAISE FND_API.g_exc_unexpected_error;
1120: END IF;

Line 1117: RAISE FND_API.g_exc_error;

1113: ,x_msg_count => x_msg_count
1114: ,p_claim_rec => p_claim_rec
1115: );
1116: IF l_return_status = FND_API.g_ret_sts_error THEN
1117: RAISE FND_API.g_exc_error;
1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1119: RAISE FND_API.g_exc_unexpected_error;
1120: END IF;
1121:

Line 1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1114: ,p_claim_rec => p_claim_rec
1115: );
1116: IF l_return_status = FND_API.g_ret_sts_error THEN
1117: RAISE FND_API.g_exc_error;
1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1119: RAISE FND_API.g_exc_unexpected_error;
1120: END IF;
1121:
1122: OZF_OM_VALIDATION_PVT.Complete_RMA_Validation(

Line 1119: RAISE FND_API.g_exc_unexpected_error;

1115: );
1116: IF l_return_status = FND_API.g_ret_sts_error THEN
1117: RAISE FND_API.g_exc_error;
1118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1119: RAISE FND_API.g_exc_unexpected_error;
1120: END IF;
1121:
1122: OZF_OM_VALIDATION_PVT.Complete_RMA_Validation(
1123: p_api_version => l_api_version

Line 1124: ,p_init_msg_list => FND_API.g_false

1120: END IF;
1121:
1122: OZF_OM_VALIDATION_PVT.Complete_RMA_Validation(
1123: p_api_version => l_api_version
1124: ,p_init_msg_list => FND_API.g_false
1125: ,p_validation_level => FND_API.g_valid_level_full
1126: ,x_return_status => l_return_status
1127: ,x_msg_data => x_msg_data
1128: ,x_msg_count => x_msg_count

Line 1125: ,p_validation_level => FND_API.g_valid_level_full

1121:
1122: OZF_OM_VALIDATION_PVT.Complete_RMA_Validation(
1123: p_api_version => l_api_version
1124: ,p_init_msg_list => FND_API.g_false
1125: ,p_validation_level => FND_API.g_valid_level_full
1126: ,x_return_status => l_return_status
1127: ,x_msg_data => x_msg_data
1128: ,x_msg_count => x_msg_count
1129: ,p_claim_rec => p_claim_rec

Line 1132: IF l_return_status = FND_API.g_ret_sts_error THEN

1128: ,x_msg_count => x_msg_count
1129: ,p_claim_rec => p_claim_rec
1130: ,x_claim_rec => x_claim_rec
1131: );
1132: IF l_return_status = FND_API.g_ret_sts_error THEN
1133: RAISE FND_API.g_exc_error;
1134: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1135: RAISE FND_API.g_exc_unexpected_error;
1136: END IF;

Line 1133: RAISE FND_API.g_exc_error;

1129: ,p_claim_rec => p_claim_rec
1130: ,x_claim_rec => x_claim_rec
1131: );
1132: IF l_return_status = FND_API.g_ret_sts_error THEN
1133: RAISE FND_API.g_exc_error;
1134: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1135: RAISE FND_API.g_exc_unexpected_error;
1136: END IF;
1137:

Line 1134: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1130: ,x_claim_rec => x_claim_rec
1131: );
1132: IF l_return_status = FND_API.g_ret_sts_error THEN
1133: RAISE FND_API.g_exc_error;
1134: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1135: RAISE FND_API.g_exc_unexpected_error;
1136: END IF;
1137:
1138: /*------------------------------------------------------------------------------*

Line 1135: RAISE FND_API.g_exc_unexpected_error;

1131: );
1132: IF l_return_status = FND_API.g_ret_sts_error THEN
1133: RAISE FND_API.g_exc_error;
1134: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1135: RAISE FND_API.g_exc_unexpected_error;
1136: END IF;
1137:
1138: /*------------------------------------------------------------------------------*
1139: | AP Validation (CHECK,EFT,WIRE,AP_DEBIT,AP_DEFAULT |

Line 1150: RAISE FND_API.G_EXC_ERROR;

1146: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1147: FND_MESSAGE.set_name('OZF', 'OZF_SETL_PAYABLES_SOURCE_NULL');
1148: FND_MSG_PUB.add;
1149: END IF;
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:
1153: -----------------------------------------------------
1154: -- Vendor_Id

Line 1162: RAISE FND_API.G_EXC_ERROR;

1158: FND_MESSAGE.set_name('OZF', 'OZF_SETL_VENDOR_REQ');
1159: FND_MESSAGE.set_token('PAY_METHOD', OZF_Utility_Pvt.get_lookup_meaning('OZF_PAYMENT_METHOD', p_claim_rec.payment_method));
1160: FND_MSG_PUB.add;
1161: END IF;
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164:
1165: -----------------------------------------------------
1166: -- Vendor_Site_Id

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170: FND_MESSAGE.set_name('OZF', 'OZF_SETL_VENDOR_SITE_REQ');
1171: FND_MESSAGE.set_token('PAY_METHOD', OZF_Utility_Pvt.get_lookup_meaning('OZF_PAYMENT_METHOD', p_claim_rec.payment_method));
1172: FND_MSG_PUB.add;
1173: END IF;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:
1177: -------------------------------------------------------
1178: --Check for active vendor and vendor site(Bug 14236524 )

Line 1190: RAISE FND_API.G_EXC_ERROR;

1186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1187: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_SETL_VENDOR_INACTIVE');
1188: FND_MSG_PUB.add;
1189: END IF;
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;
1192: END IF;
1193: -----------------------------------------------------
1194: -- Vendor Clearing Account

Line 1197: IF l_gl_acc_checking = FND_API.g_true THEN

1193: -----------------------------------------------------
1194: -- Vendor Clearing Account
1195: -----------------------------------------------------
1196: -- vendor clearing account must exist in system parameter
1197: IF l_gl_acc_checking = FND_API.g_true THEN
1198: IF l_vendor_in_sys IS NULL THEN
1199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1200: FND_MESSAGE.set_name('OZF', 'OZF_SETL_VENCLRACC_REQ');
1201: FND_MSG_PUB.add;

Line 1203: RAISE FND_API.G_EXC_ERROR;

1199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1200: FND_MESSAGE.set_name('OZF', 'OZF_SETL_VENCLRACC_REQ');
1201: FND_MSG_PUB.add;
1202: END IF;
1203: RAISE FND_API.G_EXC_ERROR;
1204: END IF;
1205: END IF;
1206:
1207: /*------------------------------------------------------------------------------*

Line 1219: RAISE FND_API.G_EXC_ERROR;

1215: FND_MESSAGE.set_name('OZF', 'OZF_SETL_VENDOR_REQ');
1216: FND_MESSAGE.set_token('PAY_METHOD', OZF_Utility_Pvt.get_lookup_meaning('OZF_PAYMENT_METHOD', p_claim_rec.payment_method));
1217: FND_MSG_PUB.add;
1218: END IF;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221:
1222: -- check vendor_site_id
1223: IF p_claim_rec.vendor_site_id IS NULL THEN

Line 1229: RAISE FND_API.G_EXC_ERROR;

1225: FND_MESSAGE.set_name('OZF', 'OZF_SETL_VENDOR_SITE_REQ');
1226: FND_MESSAGE.set_token('PAY_METHOD', OZF_Utility_Pvt.get_lookup_meaning('OZF_PAYMENT_METHOD', p_claim_rec.payment_method));
1227: FND_MSG_PUB.add;
1228: END IF;
1229: RAISE FND_API.G_EXC_ERROR;
1230: END IF;
1231:
1232:
1233: /*------------------------------------------------------------------------------*

Line 1247: WHEN FND_API.G_EXC_ERROR THEN

1243: IF OZF_DEBUG_HIGH_ON THEN
1244: OZF_Utility_PVT.debug_message(l_full_name||' : end');
1245: END IF;
1246: EXCEPTION
1247: WHEN FND_API.G_EXC_ERROR THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: WHEN OTHERS THEN

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR;

1244: OZF_Utility_PVT.debug_message(l_full_name||' : end');
1245: END IF;
1246: EXCEPTION
1247: WHEN FND_API.G_EXC_ERROR THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: WHEN OTHERS THEN
1252: IF OZF_DEBUG_LOW_ON THEN

Line 1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1245: END IF;
1246: EXCEPTION
1247: WHEN FND_API.G_EXC_ERROR THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: WHEN OTHERS THEN
1252: IF OZF_DEBUG_LOW_ON THEN
1253: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1246: EXCEPTION
1247: WHEN FND_API.G_EXC_ERROR THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: WHEN OTHERS THEN
1252: IF OZF_DEBUG_LOW_ON THEN
1253: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1254: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');

Line 1257: x_return_status := FND_API.g_ret_sts_unexp_error;

1253: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1254: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
1255: FND_MSG_PUB.Add;
1256: END IF;
1257: x_return_status := FND_API.g_ret_sts_unexp_error;
1258:
1259: END Complete_Claim_Validation;
1260:
1261: /*=======================================================================*

Line 1287: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;

1283: IS
1284: l_api_version CONSTANT NUMBER := 1.0;
1285: l_api_name CONSTANT VARCHAR2(30) := 'Complete_Claim';
1286: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1287: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;
1288:
1289: BEGIN
1290: IF OZF_DEBUG_HIGH_ON THEN
1291: OZF_Utility_PVT.debug_message(l_full_name||' : start');

Line 1295: x_return_status := FND_API.g_ret_sts_success;

1291: OZF_Utility_PVT.debug_message(l_full_name||' : start');
1292: END IF;
1293:
1294: -- Initialize API return status to sucess
1295: x_return_status := FND_API.g_ret_sts_success;
1296:
1297: IF p_x_claim_rec.payment_method = 'RMA' THEN
1298: IF p_x_claim_rec.order_type_id IS NULL THEN
1299: OZF_OM_VALIDATION_PVT.Get_Default_Order_Type(

Line 1301: ,p_init_msg_list => FND_API.g_false

1297: IF p_x_claim_rec.payment_method = 'RMA' THEN
1298: IF p_x_claim_rec.order_type_id IS NULL THEN
1299: OZF_OM_VALIDATION_PVT.Get_Default_Order_Type(
1300: p_api_version => l_api_version
1301: ,p_init_msg_list => FND_API.g_false
1302: ,p_validation_level => FND_API.g_valid_level_full
1303: ,x_return_status => l_return_status
1304: ,x_msg_data => x_msg_data
1305: ,x_msg_count => x_msg_count

Line 1302: ,p_validation_level => FND_API.g_valid_level_full

1298: IF p_x_claim_rec.order_type_id IS NULL THEN
1299: OZF_OM_VALIDATION_PVT.Get_Default_Order_Type(
1300: p_api_version => l_api_version
1301: ,p_init_msg_list => FND_API.g_false
1302: ,p_validation_level => FND_API.g_valid_level_full
1303: ,x_return_status => l_return_status
1304: ,x_msg_data => x_msg_data
1305: ,x_msg_count => x_msg_count
1306: ,p_reason_code_id => p_x_claim_rec.reason_code_id

Line 1311: IF l_return_status = FND_API.g_ret_sts_error THEN

1307: ,p_claim_type_id => p_x_claim_rec.claim_type_id
1308: ,p_set_of_books_id => p_x_claim_rec.set_of_books_id
1309: ,x_order_type_id => p_x_claim_rec.order_type_id
1310: );
1311: IF l_return_status = FND_API.g_ret_sts_error THEN
1312: RAISE FND_API.g_exc_error;
1313: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1314: RAISE FND_API.g_exc_unexpected_error;
1315: END IF;

Line 1312: RAISE FND_API.g_exc_error;

1308: ,p_set_of_books_id => p_x_claim_rec.set_of_books_id
1309: ,x_order_type_id => p_x_claim_rec.order_type_id
1310: );
1311: IF l_return_status = FND_API.g_ret_sts_error THEN
1312: RAISE FND_API.g_exc_error;
1313: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1314: RAISE FND_API.g_exc_unexpected_error;
1315: END IF;
1316: END IF;

Line 1313: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1309: ,x_order_type_id => p_x_claim_rec.order_type_id
1310: );
1311: IF l_return_status = FND_API.g_ret_sts_error THEN
1312: RAISE FND_API.g_exc_error;
1313: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1314: RAISE FND_API.g_exc_unexpected_error;
1315: END IF;
1316: END IF;
1317: ELSE

Line 1314: RAISE FND_API.g_exc_unexpected_error;

1310: );
1311: IF l_return_status = FND_API.g_ret_sts_error THEN
1312: RAISE FND_API.g_exc_error;
1313: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1314: RAISE FND_API.g_exc_unexpected_error;
1315: END IF;
1316: END IF;
1317: ELSE
1318: -- erase RMA transaction type if not for RMA settlement.

Line 1333: WHEN FND_API.G_EXC_ERROR THEN

1329: OZF_Utility_PVT.debug_message(l_full_name||' : end');
1330: END IF;
1331:
1332: EXCEPTION
1333: WHEN FND_API.G_EXC_ERROR THEN
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337: WHEN OTHERS THEN

Line 1334: x_return_status := FND_API.G_RET_STS_ERROR;

1330: END IF;
1331:
1332: EXCEPTION
1333: WHEN FND_API.G_EXC_ERROR THEN
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337: WHEN OTHERS THEN
1338: IF OZF_DEBUG_LOW_ON THEN

Line 1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1331:
1332: EXCEPTION
1333: WHEN FND_API.G_EXC_ERROR THEN
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337: WHEN OTHERS THEN
1338: IF OZF_DEBUG_LOW_ON THEN
1339: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1332: EXCEPTION
1333: WHEN FND_API.G_EXC_ERROR THEN
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337: WHEN OTHERS THEN
1338: IF OZF_DEBUG_LOW_ON THEN
1339: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1340: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');

Line 1343: x_return_status := FND_API.g_ret_sts_unexp_error;

1339: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1340: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Error');
1341: FND_MSG_PUB.Add;
1342: END IF;
1343: x_return_status := FND_API.g_ret_sts_unexp_error;
1344:
1345: END Complete_Claim;
1346:
1347: