DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_PVT dependencies on FND_API

Line 38: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

34: ( p_request_tbl IN OUT NOCOPY OE_ORDER_PUB.request_tbl_type
35: ,p_index IN NUMBER DEFAULT 1
36: ,x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2)
37: IS
38: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
39: --
40: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
41: --Start of bug 16085063
42: l_nameVal_tbl OE_ORDER_UTIL.nameVal_Tbl_Type;

Line 58: p_request_tbl(i).return_status := FND_API.G_RET_STS_SUCCESS;

54: p_request_tbl(i).request_type NOT IN (OE_GLOBALS.G_ACCEPT_FULFILLMENT,OE_GLOBALS.G_REJECT_FULFILLMENT) THEN
55: GOTO END_LOOP;
56: END IF;
57: -- Initialize each request's return_status as 'S'. It will be set to 'E' when required.
58: p_request_tbl(i).return_status := FND_API.G_RET_STS_SUCCESS;
59: IF p_request_tbl(i).entity_code = 'HEADER' THEN
60:
61: Build_Header_Acceptance_table(p_request_rec =>p_request_tbl(i)
62: ,x_return_status => l_return_status);

Line 68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

64: IF l_debug_level > 0 THEN
65: oe_debug_pub.add('sasi: p_request_rec return_status after Build_Header_Acceptance_table:'||p_request_tbl(i).return_status , 3);
66: END IF;
67:
68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: oe_debug_pub.add('sasi: p_request_rec return_status after Build_Header_Acceptance_table:'||p_request_tbl(i).return_status , 3);
66: END IF;
67:
68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73: p_request_tbl(i).processed := 'Y';

Line 70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

66: END IF;
67:
68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73: p_request_tbl(i).processed := 'Y';
74: ELSIF p_request_tbl(i).entity_code = 'LINE' THEN

Line 71: RAISE FND_API.G_EXC_ERROR;

67:
68: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73: p_request_tbl(i).processed := 'Y';
74: ELSIF p_request_tbl(i).entity_code = 'LINE' THEN
75:

Line 83: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add('sasi: p_request_rec return_status after Build_Line_Acceptance_table:'||p_request_tbl(i).return_status , 3);
81: END IF;
82:
83: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: END IF;

Line 84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

80: oe_debug_pub.add('sasi: p_request_rec return_status after Build_Line_Acceptance_table:'||p_request_tbl(i).return_status , 3);
81: END IF;
82:
83: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: END IF;
88: p_request_tbl(i).processed := 'Y';

Line 85: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

81: END IF;
82:
83: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: END IF;
88: p_request_tbl(i).processed := 'Y';
89: END IF;

Line 86: RAISE FND_API.G_EXC_ERROR;

82:
83: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: END IF;
88: p_request_tbl(i).processed := 'Y';
89: END IF;
90: << END_LOOP >> -- Label for requests that do not need to be processed

Line 131: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND NVL (Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N') = 'Y' THEN

127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance-progress_accepted_lines return status:'|| l_return_status , 1);
129: END IF;
130: --Start of bug 16085063
131: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND NVL (Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N') = 'Y' THEN
132: IF l_debug_level > 0 then
133: oe_debug_pub.add( 'OE_ACCEPTANCE_PVT - Raise Integration event for Customer Acceptance');
134: oe_debug_pub.add( 'g_line_id_tbl count: '|| g_line_id_tbl.count);
135: END IF;

Line 183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

179:
180: END LOOP;
181: END IF;
182: --End of bug 16085063
183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: END LOOP;
181: END IF;
182: --End of bug 16085063
183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:

Line 185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

181: END IF;
182: --End of bug 16085063
183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189: Reset_global_tbls;

Line 186: RAISE FND_API.G_EXC_ERROR;

182: --End of bug 16085063
183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189: Reset_global_tbls;
190:

Line 192: WHEN FND_API.G_EXC_ERROR THEN

188:
189: Reset_global_tbls;
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: RAISE FND_API.G_EXC_ERROR;
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: WHEN OTHERS THEN

Line 193: RAISE FND_API.G_EXC_ERROR;

189: Reset_global_tbls;
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: RAISE FND_API.G_EXC_ERROR;
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: WHEN OTHERS THEN
197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: RAISE FND_API.G_EXC_ERROR;
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: WHEN OTHERS THEN
197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: RAISE FND_API.G_EXC_ERROR;
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: WHEN OTHERS THEN
197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: OE_MSG_PUB.Add_Exc_Msg

Line 204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

200: ( G_PKG_NAME
201: , 'Process_Acceptance'
202: );
203: END IF;
204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
205: END Process_Acceptance;
206:
207: PROCEDURE Build_Header_Acceptance_table(p_request_rec IN OUT NOCOPY OE_ORDER_PUB.request_rec_type,
208: x_return_status OUT NOCOPY VARCHAR2)

Line 210: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

206:
207: PROCEDURE Build_Header_Acceptance_table(p_request_rec IN OUT NOCOPY OE_ORDER_PUB.request_rec_type,
208: x_return_status OUT NOCOPY VARCHAR2)
209: IS
210: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
211: l_header_id NUMBER := p_request_rec.entity_id;
212: l_line_id NUMBER;
213: CURSOR order_lines is
214: SELECT line_id

Line 232: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

228:
229: Build_Line_Acceptance_table(p_request_rec => p_request_rec
230: ,p_line_id => l_line_id
231: ,x_return_status => l_return_status);
232: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;

Line 233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

229: Build_Line_Acceptance_table(p_request_rec => p_request_rec
230: ,p_line_id => l_line_id
231: ,x_return_status => l_return_status);
232: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237:

Line 234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

230: ,p_line_id => l_line_id
231: ,x_return_status => l_return_status);
232: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237:
238: END LOOP;

Line 235: RAISE FND_API.G_EXC_ERROR;

231: ,x_return_status => l_return_status);
232: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237:
238: END LOOP;
239:

Line 254: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

250: PROCEDURE Build_Line_Acceptance_table(p_request_rec IN OUT NOCOPY OE_ORDER_PUB.request_rec_type
251: ,p_line_id IN NUMBER DEFAULT NULL
252: ,x_return_status OUT NOCOPY VARCHAR2)
253: IS
254: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
255: l_line_id NUMBER := nvl(p_line_id, p_request_rec.entity_id);
256: l_header_id NUMBER;
257: l_item_type_code VARCHAR2(30);
258: l_top_model_line_id NUMBER;

Line 321: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN

317: p_line_id => l_line_id,
318: x_index => l_notify_index,
319: x_return_status => l_notify_status);
320:
321: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: IF l_notify_index IS NOT NULL THEN

Line 322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

318: x_index => l_notify_index,
319: x_return_status => l_notify_status);
320:
321: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: IF l_notify_index IS NOT NULL THEN
326: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

Line 386: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN

382: p_line_id => l_line_id,
383: x_index => l_notify_index,
384: x_return_status => l_notify_status);
385:
386: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389:
390: IF l_notify_index IS NOT NULL THEN

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

383: x_index => l_notify_index,
384: x_return_status => l_notify_status);
385:
386: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389:
390: IF l_notify_index IS NOT NULL THEN
391: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

Line 435: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN

431: p_line_id => l_line_id,
432: x_index => l_notify_index,
433: x_return_status => l_notify_status);
434:
435: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: IF l_notify_index IS NOT NULL THEN

Line 436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

432: x_index => l_notify_index,
433: x_return_status => l_notify_status);
434:
435: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: IF l_notify_index IS NOT NULL THEN
440: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

Line 482: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN

478: p_line_id => l_line_id,
479: x_index => l_notify_index,
480: x_return_status => l_notify_status);
481:
482: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: IF l_notify_index IS NOT NULL THEN

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: x_index => l_notify_index,
480: x_return_status => l_notify_status);
481:
482: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: IF l_notify_index IS NOT NULL THEN
487: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

Line 532: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN

528: p_line_id => l_line_id,
529: x_index => l_notify_index,
530: x_return_status => l_notify_status);
531:
532: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END IF;
535:
536: IF l_notify_index IS NOT NULL THEN

Line 533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

529: x_index => l_notify_index,
530: x_return_status => l_notify_status);
531:
532: IF (l_notify_status <> FND_API.G_RET_STS_SUCCESS) THEN
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END IF;
535:
536: IF l_notify_index IS NOT NULL THEN
537: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

Line 560: p_request_rec.return_status := FND_API.G_RET_STS_ERROR;

556: ELSE
557: IF l_debug_level > 0 THEN
558: OE_DEBUG_PUB.Add('Acceptance not allowed for this line. setting retun status of request_rec to E:'||l_line_id);
559: END IF;
560: p_request_rec.return_status := FND_API.G_RET_STS_ERROR;
561: END IF;
562: END IF; -- sys param check
563: END IF;
564: EXCEPTION

Line 576: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

572:
573: PROCEDURE Progress_Accepted_lines
574: (x_return_status OUT NOCOPY Varchar2)
575: IS
576: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
577: l_msg_count NUMBER;
578: l_msg_data VARCHAR2(2000);
579: l_line_flex_rec ar_deferral_reasons_grp.line_flex_rec;
580: --

Line 632: p_init_msg_list => FND_API.G_FALSE,

628:
629:
630: cst_revenuecogsmatch_grp.receive_closelineevent (
631: p_api_version => 1.0,
632: p_init_msg_list => FND_API.G_FALSE,
633: p_commit => FND_API.G_FALSE,
634: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
635: x_return_status => l_return_status,
636: x_msg_count => l_msg_count,

Line 633: p_commit => FND_API.G_FALSE,

629:
630: cst_revenuecogsmatch_grp.receive_closelineevent (
631: p_api_version => 1.0,
632: p_init_msg_list => FND_API.G_FALSE,
633: p_commit => FND_API.G_FALSE,
634: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
635: x_return_status => l_return_status,
636: x_msg_count => l_msg_count,
637: x_msg_data => l_msg_data,

Line 634: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

630: cst_revenuecogsmatch_grp.receive_closelineevent (
631: p_api_version => 1.0,
632: p_init_msg_list => FND_API.G_FALSE,
633: p_commit => FND_API.G_FALSE,
634: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
635: x_return_status => l_return_status,
636: x_msg_count => l_msg_count,
637: x_msg_data => l_msg_data,
638: p_revenue_event_line_id => g_line_id_tbl(i),

Line 654: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

650:
651: END IF;
652:
653:
654: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
655:
656: UPDATE oe_order_lines_all
657: SET flow_status_code='NOTIFY_COSTING_ERROR'
658: WHERE line_id = g_line_id_tbl(i);

Line 660: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

656: UPDATE oe_order_lines_all
657: SET flow_status_code='NOTIFY_COSTING_ERROR'
658: WHERE line_id = g_line_id_tbl(i);
659: x_return_status := l_return_status;
660: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: return;
662: END IF;
663: -- End Bug 8859412
664:

Line 680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

676: oe_debug_pub.add('return status from OE_AR_Acceptance_GRP.Get_interface_attributes : '||l_return_status); --added for bug 16085063
677: END IF;
678:
679:
680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: -- no need to raise if the info cannot be derived. just do not call AR.
683: --ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
684: -- RAISE FND_API.G_EXC_ERROR;

Line 681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

677: END IF;
678:
679:
680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: -- no need to raise if the info cannot be derived. just do not call AR.
683: --ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
684: -- RAISE FND_API.G_EXC_ERROR;
685: END IF;

Line 683: --ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

679:
680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: -- no need to raise if the info cannot be derived. just do not call AR.
683: --ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
684: -- RAISE FND_API.G_EXC_ERROR;
685: END IF;
686:
687: IF l_line_flex_rec.interface_line_attribute6 IS NOT NULL THEN

Line 684: -- RAISE FND_API.G_EXC_ERROR;

680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: -- no need to raise if the info cannot be derived. just do not call AR.
683: --ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
684: -- RAISE FND_API.G_EXC_ERROR;
685: END IF;
686:
687: IF l_line_flex_rec.interface_line_attribute6 IS NOT NULL THEN
688: IF l_debug_level > 0 THEN

Line 703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add('return status from AR api '||l_return_status);
701: END IF;
702:
703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
706: RAISE FND_API.G_EXC_ERROR;
707: END IF;

Line 704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

700: oe_debug_pub.add('return status from AR api '||l_return_status);
701: END IF;
702:
703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
706: RAISE FND_API.G_EXC_ERROR;
707: END IF;
708: END IF;

Line 705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

701: END IF;
702:
703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
706: RAISE FND_API.G_EXC_ERROR;
707: END IF;
708: END IF;
709:

Line 706: RAISE FND_API.G_EXC_ERROR;

702:
703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
706: RAISE FND_API.G_EXC_ERROR;
707: END IF;
708: END IF;
709:
710: END IF;