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 377: WHEN FND_API.G_EXC_ERROR THEN

373: WHEN ON_HOLD_ERROR THEN
374: x_return_status := 'H';
375: OE_MSG_PUB.reset_msg_context('HEADER');
376: ROLLBACK TO CLOSE_ORDER;
377: WHEN FND_API.G_EXC_ERROR THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: OE_MSG_PUB.reset_msg_context('HEADER');
380: ROLLBACK TO CLOSE_ORDER;
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: x_return_status := 'H';
375: OE_MSG_PUB.reset_msg_context('HEADER');
376: ROLLBACK TO CLOSE_ORDER;
377: WHEN FND_API.G_EXC_ERROR THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: OE_MSG_PUB.reset_msg_context('HEADER');
380: ROLLBACK TO CLOSE_ORDER;
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

377: WHEN FND_API.G_EXC_ERROR THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: OE_MSG_PUB.reset_msg_context('HEADER');
380: ROLLBACK TO CLOSE_ORDER;
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: OE_MSG_PUB.reset_msg_context('HEADER');
384: ROLLBACK TO CLOSE_ORDER;
385: WHEN OTHERS THEN

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

378: x_return_status := FND_API.G_RET_STS_ERROR;
379: OE_MSG_PUB.reset_msg_context('HEADER');
380: ROLLBACK TO CLOSE_ORDER;
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: OE_MSG_PUB.reset_msg_context('HEADER');
384: ROLLBACK TO CLOSE_ORDER;
385: WHEN OTHERS THEN
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: OE_MSG_PUB.reset_msg_context('HEADER');
384: ROLLBACK TO CLOSE_ORDER;
385: WHEN OTHERS THEN
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: IF FND_MSG_PUB.Check_Msg_Level
388: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
389: THEN
390: OE_MSG_PUB.Add_Exc_Msg

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

397: END CLOSE_ORDER;
398:
399: PROCEDURE CLOSE_LINE
400: (p_api_version_number IN NUMBER
401: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
402: ,p_line_id IN NUMBER
403: ,x_return_status OUT NOCOPY VARCHAR2
404: ,x_msg_count OUT NOCOPY NUMBER
405: ,x_msg_data OUT NOCOPY VARCHAR2

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

416: l_itemkey_sso NUMBER;
417: l_header_rec OE_Order_PUB.Header_Rec_Type;
418: l_return_status_gen VARCHAR2(30);
419: -- GENESIS --
420: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
421: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
422: l_org_id oe_order_lines_all.org_id%TYPE;
423: /* Customer Acceptance */
424: l_pending_acceptance VARCHAR2(1) := 'N';

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS;

432: END IF;
433:
434: SAVEPOINT CLOSE_LINE;
435:
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: OE_MSG_PUB.set_msg_context(
439: p_entity_code => 'LINE'
440: ,p_entity_id => p_line_id

Line 511: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

507: (p_line_id => p_line_id
508: ,x_line_tbl => l_old_line_tbl
509: ,x_return_status => x_return_status
510: );
511: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;

Line 512: RAISE FND_API.G_EXC_ERROR;

508: ,x_line_tbl => l_old_line_tbl
509: ,x_return_status => x_return_status
510: );
511: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:

Line 513: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

509: ,x_return_status => x_return_status
510: );
511: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:
517: OE_MSG_PUB.update_msg_context

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510: );
511: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:
517: OE_MSG_PUB.update_msg_context
518: ( p_entity_code => 'LINE'

Line 551: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND

547: ,x_return_status => x_return_status
548: ,x_msg_count => l_msg_count
549: ,x_msg_data => l_msg_data
550: );
551: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
552: l_check_hold_result = FND_API.G_TRUE )
553: THEN
554: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_HOLD_EXISTS');
555: OE_MSG_PUB.ADD;

Line 552: l_check_hold_result = FND_API.G_TRUE )

548: ,x_msg_count => l_msg_count
549: ,x_msg_data => l_msg_data
550: );
551: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
552: l_check_hold_result = FND_API.G_TRUE )
553: THEN
554: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_HOLD_EXISTS');
555: OE_MSG_PUB.ADD;
556: RAISE ON_HOLD_ERROR;

Line 557: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

553: THEN
554: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_HOLD_EXISTS');
555: OE_MSG_PUB.ADD;
556: RAISE ON_HOLD_ERROR;
557: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
558: RAISE FND_API.G_EXC_ERROR;
559: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;

Line 558: RAISE FND_API.G_EXC_ERROR;

554: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_HOLD_EXISTS');
555: OE_MSG_PUB.ADD;
556: RAISE ON_HOLD_ERROR;
557: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
558: RAISE FND_API.G_EXC_ERROR;
559: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562: END IF;

Line 559: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

555: OE_MSG_PUB.ADD;
556: RAISE ON_HOLD_ERROR;
557: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
558: RAISE FND_API.G_EXC_ERROR;
559: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562: END IF;
563:

Line 560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

556: RAISE ON_HOLD_ERROR;
557: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
558: RAISE FND_API.G_EXC_ERROR;
559: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562: END IF;
563:
564: --Customer Acceptance

Line 613: p_init_msg_list => FND_API.G_FALSE,

609:
610:
611: cst_revenuecogsmatch_grp.receive_closelineevent (
612: p_api_version => 1.0,
613: p_init_msg_list => FND_API.G_FALSE,
614: p_commit => FND_API.G_FALSE,
615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
616: x_return_status => l_return_status,
617: x_msg_count => x_msg_count,

Line 614: p_commit => FND_API.G_FALSE,

610:
611: cst_revenuecogsmatch_grp.receive_closelineevent (
612: p_api_version => 1.0,
613: p_init_msg_list => FND_API.G_FALSE,
614: p_commit => FND_API.G_FALSE,
615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
616: x_return_status => l_return_status,
617: x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data,

Line 615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

611: cst_revenuecogsmatch_grp.receive_closelineevent (
612: p_api_version => 1.0,
613: p_init_msg_list => FND_API.G_FALSE,
614: p_commit => FND_API.G_FALSE,
615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
616: x_return_status => l_return_status,
617: x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data,
619: p_revenue_event_line_id => p_line_id,

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

628: -- Also if there is any unexpected error, close line workflow activity would be in
629: -- Incomplete status and will rerun automatically, we will mark the flow_status_code
630: -- as 'NOTIFY_COSTING_ERROR';
631:
632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
633:
634: UPDATE oe_order_lines_all
635: SET flow_status_code='NOTIFY_COSTING_ERROR'
636: WHERE line_id = p_line_id;

Line 638: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

634: UPDATE oe_order_lines_all
635: SET flow_status_code='NOTIFY_COSTING_ERROR'
636: WHERE line_id = p_line_id;
637: x_return_status := l_return_status;
638: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: return;
640: END IF;
641:
642:

Line 667: RAISE FND_API.G_EXC_ERROR;

663:
664: IF l_debug_level > 0 THEN
665: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
666: END IF;
667: RAISE FND_API.G_EXC_ERROR;
668:
669: END IF;
670: ELSE
671: --Customer Acceptance

Line 689: RAISE FND_API.G_EXC_ERROR;

685:
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
688: END IF;
689: RAISE FND_API.G_EXC_ERROR;
690:
691: END IF;
692:
693:

Line 738: RAISE FND_API.G_EXC_ERROR;

734:
735: IF l_debug_level > 0 THEN
736: oe_debug_pub.add( 'ORG CONTEXT is not properly set for'||p_line_id , 1) ;
737: END IF;
738: RAISE FND_API.G_EXC_ERROR;
739:
740: END IF;
741:
742:

Line 762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
760: END IF;
761:
762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
763: RAISE FND_API.G_EXC_ERROR;
764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;

Line 763: RAISE FND_API.G_EXC_ERROR;

759: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
760: END IF;
761:
762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
763: RAISE FND_API.G_EXC_ERROR;
764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:

Line 764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

760: END IF;
761:
762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
763: RAISE FND_API.G_EXC_ERROR;
764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: IF l_notify_index is not null then

Line 765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

761:
762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
763: RAISE FND_API.G_EXC_ERROR;
764: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: IF l_notify_index is not null then
769: -- modify Global Picture

Line 801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

797: , x_return_status => x_return_status
798: , p_line_tbl => l_line_tbl
799: , p_old_line_tbl => l_old_line_tbl
800: );
801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
802: RAISE FND_API.G_EXC_ERROR;
803: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;

Line 802: RAISE FND_API.G_EXC_ERROR;

798: , p_line_tbl => l_line_tbl
799: , p_old_line_tbl => l_old_line_tbl
800: );
801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
802: RAISE FND_API.G_EXC_ERROR;
803: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806: END IF ; /* global entity index null check */

Line 803: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

799: , p_old_line_tbl => l_old_line_tbl
800: );
801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
802: RAISE FND_API.G_EXC_ERROR;
803: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806: END IF ; /* global entity index null check */
807:

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

800: );
801: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
802: RAISE FND_API.G_EXC_ERROR;
803: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806: END IF ; /* global entity index null check */
807:
808: ELSE /* in pre-pack H code */

Line 822: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

818: , x_return_status => x_return_status
819: , p_line_tbl => l_line_tbl
820: , p_old_line_tbl => l_old_line_tbl
821: );
822: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
823: RAISE FND_API.G_EXC_ERROR;
824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
826: END IF;

Line 823: RAISE FND_API.G_EXC_ERROR;

819: , p_line_tbl => l_line_tbl
820: , p_old_line_tbl => l_old_line_tbl
821: );
822: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
823: RAISE FND_API.G_EXC_ERROR;
824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
826: END IF;
827: END IF; /* code set is pack H or higher */

Line 824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

820: , p_old_line_tbl => l_old_line_tbl
821: );
822: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
823: RAISE FND_API.G_EXC_ERROR;
824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
826: END IF;
827: END IF; /* code set is pack H or higher */
828: -- jolin end

Line 825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

821: );
822: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
823: RAISE FND_API.G_EXC_ERROR;
824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
826: END IF;
827: END IF; /* code set is pack H or higher */
828: -- jolin end
829:

Line 882: IF l_return_status_gen = FND_API.G_RET_STS_SUCCESS THEN

878:
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( ' GENESIS :CLOSE LINE: RETURN STATUS'||l_return_status_gen);
881: END IF;
882: IF l_return_status_gen = FND_API.G_RET_STS_SUCCESS THEN
883: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec
884: ,p_line_rec => null
885: ,p_hdr_req_id => l_itemkey_sso
886: ,p_lin_req_id => l_itemkey_sso

Line 897: WHEN FND_API.G_EXC_ERROR THEN

893: WHEN ON_HOLD_ERROR THEN
894: x_return_status := 'H';
895: OE_MSG_PUB.Reset_Msg_Context('LINE');
896: ROLLBACK TO CLOSE_LINE;
897: WHEN FND_API.G_EXC_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: OE_MSG_PUB.Reset_Msg_Context('LINE');
900: ROLLBACK TO CLOSE_LINE;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 898: x_return_status := FND_API.G_RET_STS_ERROR;

894: x_return_status := 'H';
895: OE_MSG_PUB.Reset_Msg_Context('LINE');
896: ROLLBACK TO CLOSE_LINE;
897: WHEN FND_API.G_EXC_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: OE_MSG_PUB.Reset_Msg_Context('LINE');
900: ROLLBACK TO CLOSE_LINE;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

897: WHEN FND_API.G_EXC_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: OE_MSG_PUB.Reset_Msg_Context('LINE');
900: ROLLBACK TO CLOSE_LINE;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: OE_MSG_PUB.Reset_Msg_Context('LINE');
904: ROLLBACK TO CLOSE_LINE;
905: WHEN OTHERS THEN

Line 902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

898: x_return_status := FND_API.G_RET_STS_ERROR;
899: OE_MSG_PUB.Reset_Msg_Context('LINE');
900: ROLLBACK TO CLOSE_LINE;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: OE_MSG_PUB.Reset_Msg_Context('LINE');
904: ROLLBACK TO CLOSE_LINE;
905: WHEN OTHERS THEN
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: OE_MSG_PUB.Reset_Msg_Context('LINE');
904: ROLLBACK TO CLOSE_LINE;
905: WHEN OTHERS THEN
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: IF FND_MSG_PUB.Check_Msg_Level
908: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: OE_MSG_PUB.Add_Exc_Msg