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.OE_ORDER_CLOSE_UTIL dependencies on FND_API

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70: WHEN OTHERS THEN
71: IF l_debug_level > 0 THEN
72: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
73: END IF;
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END;
76: END LOOP;
77: --
78: CLOSE c_adjustment_header;

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: WHEN OTHERS THEN
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
99: END IF;
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END;
102: --
103: END LOOP;
104: CLOSE c_adjustment_line;

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: WHEN OTHERS THEN
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
122: END IF;
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END DELETE_ADJUSTMENTS;
125:
126: PROCEDURE CLOSE_ORDER
127: (p_api_version_number IN NUMBER

Line 128: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

124: END DELETE_ADJUSTMENTS;
125:
126: PROCEDURE CLOSE_ORDER
127: (p_api_version_number IN NUMBER
128: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
129: ,p_header_id IN NUMBER
130: ,x_return_status OUT NOCOPY VARCHAR2
131:
132: ,x_msg_count OUT NOCOPY NUMBER

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150: BEGIN
151:
152: SAVEPOINT CLOSE_ORDER;
153:
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: OE_MSG_PUB.set_msg_context(
157: p_entity_code => 'HEADER'
158: ,p_entity_id => p_header_id

Line 168: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

164: (p_header_id => p_header_id
165: ,p_x_header_rec => l_old_header_rec
166: ,x_return_status => x_return_status
167: );
168: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;

Line 169: RAISE FND_API.G_EXC_ERROR;

165: ,p_x_header_rec => l_old_header_rec
166: ,x_return_status => x_return_status
167: );
168: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:

Line 170: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

166: ,x_return_status => x_return_status
167: );
168: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: OE_MSG_PUB.update_msg_context(

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: );
168: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
169: RAISE FND_API.G_EXC_ERROR;
170: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: OE_MSG_PUB.update_msg_context(
175: p_entity_code => 'HEADER'

Line 205: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND

201: );
202:
203: END IF;
204:
205: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
206: l_check_hold_result = FND_API.G_TRUE )
207: THEN
208: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_ORDER_HOLD_EXISTS');
209: OE_MSG_PUB.ADD;

Line 206: l_check_hold_result = FND_API.G_TRUE )

202:
203: END IF;
204:
205: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
206: l_check_hold_result = FND_API.G_TRUE )
207: THEN
208: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_ORDER_HOLD_EXISTS');
209: OE_MSG_PUB.ADD;
210: RAISE ON_HOLD_ERROR;

Line 211: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

207: THEN
208: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_ORDER_HOLD_EXISTS');
209: OE_MSG_PUB.ADD;
210: RAISE ON_HOLD_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
212: RAISE FND_API.G_EXC_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;

Line 212: RAISE FND_API.G_EXC_ERROR;

208: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_ORDER_HOLD_EXISTS');
209: OE_MSG_PUB.ADD;
210: RAISE ON_HOLD_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
212: RAISE FND_API.G_EXC_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216:

Line 213: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

209: OE_MSG_PUB.ADD;
210: RAISE ON_HOLD_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
212: RAISE FND_API.G_EXC_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216:
217:

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: RAISE ON_HOLD_ERROR;
211: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
212: RAISE FND_API.G_EXC_ERROR;
213: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216:
217:
218: -- Set the open flag and flow status on the header

Line 247: RAISE FND_API.G_EXC_ERROR;

243:
244: IF l_debug_level > 0 THEN
245: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_header_id , 1) ;
246: END IF;
247: RAISE FND_API.G_EXC_ERROR;
248:
249: END IF;
250:
251: DELETE_ADJUSTMENTS(p_header_id => p_header_id);

Line 289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
287: END IF;
288:
289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;
291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;

Line 290: RAISE FND_API.G_EXC_ERROR;

286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
287: END IF;
288:
289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;
291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294:

Line 291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

287: END IF;
288:
289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;
291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294:
295: -- Process requests is TRUE so still need to call it, but don't need to notify

Line 292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

288:
289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;
291: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294:
295: -- Process requests is TRUE so still need to call it, but don't need to notify
296: IF l_debug_level > 0 THEN

Line 307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

303: , x_return_status => x_return_status
304: , p_header_rec => l_header_rec
305: , p_old_header_rec => l_old_header_rec
306: );
307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;

Line 308: RAISE FND_API.G_EXC_ERROR;

304: , p_header_rec => l_header_rec
305: , p_old_header_rec => l_old_header_rec
306: );
307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312: END IF ; /* global entity index null check */

Line 309: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

305: , p_old_header_rec => l_old_header_rec
306: );
307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312: END IF ; /* global entity index null check */
313:

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

306: );
307: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312: END IF ; /* global entity index null check */
313:
314: ELSE /* in pre-pack H code */

Line 328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

324: , x_return_status => x_return_status
325: , p_header_rec => l_header_rec
326: , p_old_header_rec => l_old_header_rec
327: );
328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;

Line 329: RAISE FND_API.G_EXC_ERROR;

325: , p_header_rec => l_header_rec
326: , p_old_header_rec => l_old_header_rec
327: );
328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: END IF; /* code set is pack H or higher */

Line 330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

326: , p_old_header_rec => l_old_header_rec
327: );
328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: END IF; /* code set is pack H or higher */
334: -- jolin end

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327: );
328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: END IF; /* code set is pack H or higher */
334: -- jolin end
335:

Line 387: WHEN FND_API.G_EXC_ERROR THEN

383: WHEN ON_HOLD_ERROR THEN
384: x_return_status := 'H';
385: OE_MSG_PUB.reset_msg_context('HEADER');
386: ROLLBACK TO CLOSE_ORDER;
387: WHEN FND_API.G_EXC_ERROR THEN
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: OE_MSG_PUB.reset_msg_context('HEADER');
390: ROLLBACK TO CLOSE_ORDER;
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 388: x_return_status := FND_API.G_RET_STS_ERROR;

384: x_return_status := 'H';
385: OE_MSG_PUB.reset_msg_context('HEADER');
386: ROLLBACK TO CLOSE_ORDER;
387: WHEN FND_API.G_EXC_ERROR THEN
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: OE_MSG_PUB.reset_msg_context('HEADER');
390: ROLLBACK TO CLOSE_ORDER;
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

387: WHEN FND_API.G_EXC_ERROR THEN
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: OE_MSG_PUB.reset_msg_context('HEADER');
390: ROLLBACK TO CLOSE_ORDER;
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: OE_MSG_PUB.reset_msg_context('HEADER');
394: ROLLBACK TO CLOSE_ORDER;
395: WHEN OTHERS THEN

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

388: x_return_status := FND_API.G_RET_STS_ERROR;
389: OE_MSG_PUB.reset_msg_context('HEADER');
390: ROLLBACK TO CLOSE_ORDER;
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: OE_MSG_PUB.reset_msg_context('HEADER');
394: ROLLBACK TO CLOSE_ORDER;
395: WHEN OTHERS THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: OE_MSG_PUB.reset_msg_context('HEADER');
394: ROLLBACK TO CLOSE_ORDER;
395: WHEN OTHERS THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF FND_MSG_PUB.Check_Msg_Level
398: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN
400: OE_MSG_PUB.Add_Exc_Msg

Line 411: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

407: END CLOSE_ORDER;
408:
409: PROCEDURE CLOSE_LINE
410: (p_api_version_number IN NUMBER
411: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
412: ,p_line_id IN NUMBER
413: ,x_return_status OUT NOCOPY VARCHAR2
414: ,x_msg_count OUT NOCOPY NUMBER
415: ,x_msg_data OUT NOCOPY VARCHAR2

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

426: l_itemkey_sso NUMBER;
427: l_header_rec OE_Order_PUB.Header_Rec_Type;
428: l_return_status_gen VARCHAR2(30);
429: -- GENESIS --
430: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
431: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
432: l_org_id oe_order_lines_all.org_id%TYPE;
433: /* Customer Acceptance */
434: l_pending_acceptance VARCHAR2(1) := 'N';

Line 446: x_return_status := FND_API.G_RET_STS_SUCCESS;

442: END IF;
443:
444: SAVEPOINT CLOSE_LINE;
445:
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: OE_MSG_PUB.set_msg_context(
449: p_entity_code => 'LINE'
450: ,p_entity_id => p_line_id

Line 521: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

517: (p_line_id => p_line_id
518: ,x_line_tbl => l_old_line_tbl
519: ,x_return_status => x_return_status
520: );
521: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;

Line 522: RAISE FND_API.G_EXC_ERROR;

518: ,x_line_tbl => l_old_line_tbl
519: ,x_return_status => x_return_status
520: );
521: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:

Line 523: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

519: ,x_return_status => x_return_status
520: );
521: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: OE_MSG_PUB.update_msg_context

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520: );
521: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: OE_MSG_PUB.update_msg_context
528: ( p_entity_code => 'LINE'

Line 561: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND

557: ,x_return_status => x_return_status
558: ,x_msg_count => l_msg_count
559: ,x_msg_data => l_msg_data
560: );
561: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
562: l_check_hold_result = FND_API.G_TRUE )
563: THEN
564: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_HOLD_EXISTS');
565: OE_MSG_PUB.ADD;

Line 562: l_check_hold_result = FND_API.G_TRUE )

558: ,x_msg_count => l_msg_count
559: ,x_msg_data => l_msg_data
560: );
561: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
562: l_check_hold_result = FND_API.G_TRUE )
563: THEN
564: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_HOLD_EXISTS');
565: OE_MSG_PUB.ADD;
566: RAISE ON_HOLD_ERROR;

Line 567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

563: THEN
564: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_HOLD_EXISTS');
565: OE_MSG_PUB.ADD;
566: RAISE ON_HOLD_ERROR;
567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
568: RAISE FND_API.G_EXC_ERROR;
569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;

Line 568: RAISE FND_API.G_EXC_ERROR;

564: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_HOLD_EXISTS');
565: OE_MSG_PUB.ADD;
566: RAISE ON_HOLD_ERROR;
567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
568: RAISE FND_API.G_EXC_ERROR;
569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: END IF;

Line 569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

565: OE_MSG_PUB.ADD;
566: RAISE ON_HOLD_ERROR;
567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
568: RAISE FND_API.G_EXC_ERROR;
569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: END IF;
573:

Line 570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

566: RAISE ON_HOLD_ERROR;
567: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
568: RAISE FND_API.G_EXC_ERROR;
569: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: END IF;
573:
574: --Customer Acceptance

Line 623: p_init_msg_list => FND_API.G_FALSE,

619:
620:
621: cst_revenuecogsmatch_grp.receive_closelineevent (
622: p_api_version => 1.0,
623: p_init_msg_list => FND_API.G_FALSE,
624: p_commit => FND_API.G_FALSE,
625: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
626: x_return_status => l_return_status,
627: x_msg_count => x_msg_count,

Line 624: p_commit => FND_API.G_FALSE,

620:
621: cst_revenuecogsmatch_grp.receive_closelineevent (
622: p_api_version => 1.0,
623: p_init_msg_list => FND_API.G_FALSE,
624: p_commit => FND_API.G_FALSE,
625: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
626: x_return_status => l_return_status,
627: x_msg_count => x_msg_count,
628: x_msg_data => x_msg_data,

Line 625: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

621: cst_revenuecogsmatch_grp.receive_closelineevent (
622: p_api_version => 1.0,
623: p_init_msg_list => FND_API.G_FALSE,
624: p_commit => FND_API.G_FALSE,
625: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
626: x_return_status => l_return_status,
627: x_msg_count => x_msg_count,
628: x_msg_data => x_msg_data,
629: p_revenue_event_line_id => p_line_id,

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

638: -- Also if there is any unexpected error, close line workflow activity would be in
639: -- Incomplete status and will rerun automatically, we will mark the flow_status_code
640: -- as 'NOTIFY_COSTING_ERROR';
641:
642: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
643:
644: UPDATE oe_order_lines_all
645: SET flow_status_code='NOTIFY_COSTING_ERROR'
646: WHERE line_id = p_line_id;

Line 648: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

644: UPDATE oe_order_lines_all
645: SET flow_status_code='NOTIFY_COSTING_ERROR'
646: WHERE line_id = p_line_id;
647: x_return_status := l_return_status;
648: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: return;
650: END IF;
651:
652:

Line 706: RAISE FND_API.G_EXC_ERROR;

702:
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
705: END IF;
706: RAISE FND_API.G_EXC_ERROR;
707:
708: END IF;
709:
710:

Line 755: RAISE FND_API.G_EXC_ERROR;

751:
752: IF l_debug_level > 0 THEN
753: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
754: END IF;
755: RAISE FND_API.G_EXC_ERROR;
756:
757: END IF;
758:
759:

Line 779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
777: END IF;
778:
779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
780: RAISE FND_API.G_EXC_ERROR;
781: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;

Line 780: RAISE FND_API.G_EXC_ERROR;

776: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
777: END IF;
778:
779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
780: RAISE FND_API.G_EXC_ERROR;
781: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:

Line 781: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

777: END IF;
778:
779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
780: RAISE FND_API.G_EXC_ERROR;
781: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:
785: IF l_notify_index is not null then

Line 782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

778:
779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
780: RAISE FND_API.G_EXC_ERROR;
781: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:
785: IF l_notify_index is not null then
786: -- modify Global Picture

Line 818: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

814: , x_return_status => x_return_status
815: , p_line_tbl => l_line_tbl
816: , p_old_line_tbl => l_old_line_tbl
817: );
818: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;

Line 819: RAISE FND_API.G_EXC_ERROR;

815: , p_line_tbl => l_line_tbl
816: , p_old_line_tbl => l_old_line_tbl
817: );
818: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823: END IF ; /* global entity index null check */

Line 820: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

816: , p_old_line_tbl => l_old_line_tbl
817: );
818: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823: END IF ; /* global entity index null check */
824:

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

817: );
818: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823: END IF ; /* global entity index null check */
824:
825: ELSE /* in pre-pack H code */

Line 839: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

835: , x_return_status => x_return_status
836: , p_line_tbl => l_line_tbl
837: , p_old_line_tbl => l_old_line_tbl
838: );
839: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
840: RAISE FND_API.G_EXC_ERROR;
841: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;

Line 840: RAISE FND_API.G_EXC_ERROR;

836: , p_line_tbl => l_line_tbl
837: , p_old_line_tbl => l_old_line_tbl
838: );
839: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
840: RAISE FND_API.G_EXC_ERROR;
841: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844: END IF; /* code set is pack H or higher */

Line 841: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

837: , p_old_line_tbl => l_old_line_tbl
838: );
839: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
840: RAISE FND_API.G_EXC_ERROR;
841: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844: END IF; /* code set is pack H or higher */
845: -- jolin end

Line 842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

838: );
839: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
840: RAISE FND_API.G_EXC_ERROR;
841: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844: END IF; /* code set is pack H or higher */
845: -- jolin end
846:

Line 907: IF l_return_status_gen = FND_API.G_RET_STS_SUCCESS THEN

903: IF l_debug_level > 0 THEN
904: oe_debug_pub.add( ' GENESIS :CLOSE LINE: RETURN STATUS'||l_return_status_gen);
905: END IF;
906:
907: IF l_return_status_gen = FND_API.G_RET_STS_SUCCESS THEN
908: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec
909: ,p_line_rec => l_line_tbl(1) -- Bug 8442372
910: ,p_hdr_req_id => l_itemkey_sso
911: ,p_lin_req_id => l_itemkey_sso

Line 924: WHEN FND_API.G_EXC_ERROR THEN

920: WHEN ON_HOLD_ERROR THEN
921: x_return_status := 'H';
922: OE_MSG_PUB.Reset_Msg_Context('LINE');
923: ROLLBACK TO CLOSE_LINE;
924: WHEN FND_API.G_EXC_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: OE_MSG_PUB.Reset_Msg_Context('LINE');
927: ROLLBACK TO CLOSE_LINE;
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 925: x_return_status := FND_API.G_RET_STS_ERROR;

921: x_return_status := 'H';
922: OE_MSG_PUB.Reset_Msg_Context('LINE');
923: ROLLBACK TO CLOSE_LINE;
924: WHEN FND_API.G_EXC_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: OE_MSG_PUB.Reset_Msg_Context('LINE');
927: ROLLBACK TO CLOSE_LINE;
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

924: WHEN FND_API.G_EXC_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: OE_MSG_PUB.Reset_Msg_Context('LINE');
927: ROLLBACK TO CLOSE_LINE;
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: OE_MSG_PUB.Reset_Msg_Context('LINE');
931: ROLLBACK TO CLOSE_LINE;
932: WHEN OTHERS THEN

Line 929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

925: x_return_status := FND_API.G_RET_STS_ERROR;
926: OE_MSG_PUB.Reset_Msg_Context('LINE');
927: ROLLBACK TO CLOSE_LINE;
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: OE_MSG_PUB.Reset_Msg_Context('LINE');
931: ROLLBACK TO CLOSE_LINE;
932: WHEN OTHERS THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: OE_MSG_PUB.Reset_Msg_Context('LINE');
931: ROLLBACK TO CLOSE_LINE;
932: WHEN OTHERS THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: IF FND_MSG_PUB.Check_Msg_Level
935: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
936: THEN
937: OE_MSG_PUB.Add_Exc_Msg