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

Line 61: l_return_status := FND_API.G_RET_STS_SUCCESS;

57: BEGIN
58: IF G_debug_flag = 'Y' THEN
59: oe_debug_pub.add('In Release_Order_CC_Hold');
60: END IF;
61: l_return_status := FND_API.G_RET_STS_SUCCESS;
62: IF G_debug_flag = 'Y' THEN
63: oe_debug_pub.add('Check if Holds exist to release ');
64: END IF;
65:

Line 88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

84: oe_debug_pub.add('Out Check_Holds ');
85: oe_debug_pub.add('l_return_status = '|| l_return_status );
86: oe_debug_pub.add('l_hold_result = '|| l_hold_result );
87: END IF;
88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;

Line 89: RAISE FND_API.G_EXC_ERROR;

85: oe_debug_pub.add('l_return_status = '|| l_return_status );
86: oe_debug_pub.add('l_hold_result = '|| l_hold_result );
87: END IF;
88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93: -- releasing the Hold

Line 90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

86: oe_debug_pub.add('l_hold_result = '|| l_hold_result );
87: END IF;
88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93: -- releasing the Hold
94: IF l_hold_result = FND_API.G_TRUE THEN

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: END IF;
88: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93: -- releasing the Hold
94: IF l_hold_result = FND_API.G_TRUE THEN
95: l_hold_source_rec.hold_id := 1; -- Credit Checking hold

Line 94: IF l_hold_result = FND_API.G_TRUE THEN

90: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93: -- releasing the Hold
94: IF l_hold_result = FND_API.G_TRUE THEN
95: l_hold_source_rec.hold_id := 1; -- Credit Checking hold
96: l_hold_source_rec.HOLD_ENTITY_CODE := 'O';
97: l_hold_source_rec.HOLD_ENTITY_ID := p_header_id;
98: --9865613 l_hold_release_rec.release_reason_code := 'AR_APPROVE';

Line 113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

109: x_msg_count => l_msg_count ,
110: x_msg_data => l_msg_data ,
111: x_return_status => l_return_status
112: );
113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
114: RAISE FND_API.G_EXC_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

Line 114: RAISE FND_API.G_EXC_ERROR;

110: x_msg_data => l_msg_data ,
111: x_return_status => l_return_status
112: );
113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
114: RAISE FND_API.G_EXC_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
118: IF G_debug_flag = 'Y' THEN

Line 115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

111: x_return_status => l_return_status
112: );
113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
114: RAISE FND_API.G_EXC_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
118: IF G_debug_flag = 'Y' THEN
119: oe_debug_pub.add('Released credit check hold on Header ID:'|| p_header_id);

Line 116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

112: );
113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
114: RAISE FND_API.G_EXC_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
118: IF G_debug_flag = 'Y' THEN
119: oe_debug_pub.add('Released credit check hold on Header ID:'|| p_header_id);
120: END IF;

Line 117: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

113: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
114: RAISE FND_API.G_EXC_ERROR;
115: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
118: IF G_debug_flag = 'Y' THEN
119: oe_debug_pub.add('Released credit check hold on Header ID:'|| p_header_id);
120: END IF;
121: END IF;

Line 177: l_return_status := FND_API.G_RET_STS_SUCCESS;

173: oe_debug_pub.add(' In Release_Line_CC_Hold');
174: oe_debug_pub.add('Processing line ID = '|| p_line_id );
175: END IF;
176:
177: l_return_status := FND_API.G_RET_STS_SUCCESS;
178:
179:
180: --checking whether HOLD exists
181: IF G_debug_flag = 'Y'

Line 208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

204: OE_DEBUG_PUB.ADD('l_return_status :'||l_return_status);
205: OE_DEBUG_PUB.ADD('l_hold_result :'||l_hold_result);
206: END IF;
207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;

Line 209: RAISE FND_API.G_EXC_ERROR;

205: OE_DEBUG_PUB.ADD('l_hold_result :'||l_hold_result);
206: END IF;
207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213: --end check hold exits

Line 210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

206: END IF;
207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213: --end check hold exits
214:

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213: --end check hold exits
214:
215: IF l_hold_result = FND_API.G_TRUE THEN

Line 215: IF l_hold_result = FND_API.G_TRUE THEN

211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213: --end check hold exits
214:
215: IF l_hold_result = FND_API.G_TRUE THEN
216: IF NVL(p_calling_action,'BOOKING') <> 'AUTO HOLD' THEN
217: l_hold_source_rec.hold_id := 1; -- Credit Checking hold
218: l_hold_source_rec.HOLD_ENTITY_CODE := 'O';
219: l_hold_source_rec.HOLD_ENTITY_ID := p_header_id;

Line 236: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

232: , x_msg_data => l_msg_data
233: , x_return_status => l_return_status
234: );
235:
236: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
237: IF NVL(G_hdr_hold_released,'N') = 'N'
238: THEN
239: l_cc_result_out := 'HDR_HOLD' ;
240: ELSE

Line 241: RAISE FND_API.G_EXC_ERROR;

237: IF NVL(G_hdr_hold_released,'N') = 'N'
238: THEN
239: l_cc_result_out := 'HDR_HOLD' ;
240: ELSE
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
244: IF NVL(G_hdr_hold_released,'N') = 'N'
245: THEN

Line 243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

239: l_cc_result_out := 'HDR_HOLD' ;
240: ELSE
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
244: IF NVL(G_hdr_hold_released,'N') = 'N'
245: THEN
246: l_cc_result_out := 'HDR_HOLD' ;
247: ELSE

Line 248: RAISE FND_API.G_EXC_ERROR;

244: IF NVL(G_hdr_hold_released,'N') = 'N'
245: THEN
246: l_cc_result_out := 'HDR_HOLD' ;
247: ELSE
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
251: l_cc_result_out := 'PASS_REL';
252: END IF;

Line 250: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN

246: l_cc_result_out := 'HDR_HOLD' ;
247: ELSE
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
251: l_cc_result_out := 'PASS_REL';
252: END IF;
253: END IF; -- check calling action
254: ELSE

Line 444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

440: FROM ar_cmgt_credit_requests
441: WHERE credit_request_id = l_credit_request_id;
442: EXCEPTION
443: WHEN NO_DATA_FOUND THEN
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: END;
446:
447: -- set security context
448: FND_GLOBAL.apps_initialize

Line 491: IF l_return_status = FND_API.G_RET_STS_ERROR

487: , x_conversion_status => l_conversion_status
488: , x_return_status => l_return_status
489: );
490:
491: IF l_return_status = FND_API.G_RET_STS_ERROR
492: THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
495: THEN

Line 493: RAISE FND_API.G_EXC_ERROR;

489: );
490:
491: IF l_return_status = FND_API.G_RET_STS_ERROR
492: THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
495: THEN
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;

Line 494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

490:
491: IF l_return_status = FND_API.G_RET_STS_ERROR
492: THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
495: THEN
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498:

Line 496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

492: THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
495: THEN
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498:
499: --check if the order_amount has been changed
500: --if amount has not been changed, release the hold

Line 545: IF l_return_status = FND_API.G_RET_STS_ERROR

541: , x_amount => l_new_amount
542: , x_conversion_status => l_conversion_status
543: , x_return_status => l_return_status
544: );
545: IF l_return_status = FND_API.G_RET_STS_ERROR
546: THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
549: THEN

Line 547: RAISE FND_API.G_EXC_ERROR;

543: , x_return_status => l_return_status
544: );
545: IF l_return_status = FND_API.G_RET_STS_ERROR
546: THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
549: THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;

Line 548: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

544: );
545: IF l_return_status = FND_API.G_RET_STS_ERROR
546: THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
549: THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552: --Check if amount per bill-to site has been changed

Line 550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

546: THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
549: THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552: --Check if amount per bill-to site has been changed
553: --if amount has not been changed, release holds for bill_to site
554: IF l_new_amount = l_trx_amount THEN

Line 597: IF l_return_status = FND_API.G_RET_STS_ERROR

593: , x_amount => l_new_amount
594: , x_conversion_status => l_conversion_status
595: , x_return_status => l_return_status
596: );
597: IF l_return_status = FND_API.G_RET_STS_ERROR
598: THEN
599: RAISE FND_API.G_EXC_ERROR;
600: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
601: THEN

Line 599: RAISE FND_API.G_EXC_ERROR;

595: , x_return_status => l_return_status
596: );
597: IF l_return_status = FND_API.G_RET_STS_ERROR
598: THEN
599: RAISE FND_API.G_EXC_ERROR;
600: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
601: THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;

Line 600: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

596: );
597: IF l_return_status = FND_API.G_RET_STS_ERROR
598: THEN
599: RAISE FND_API.G_EXC_ERROR;
600: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
601: THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604: IF l_new_amount = l_trx_amount THEN

Line 602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

598: THEN
599: RAISE FND_API.G_EXC_ERROR;
600: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
601: THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604: IF l_new_amount = l_trx_amount THEN
605: --OPEN the cursor for all lines
606: FOR c_line IN lines_csr(p_header_id =>l_source_column1)

Line 649: IF l_return_status = FND_API.G_RET_STS_ERROR

645: , x_amount => l_new_amount
646: , x_conversion_status => l_conversion_status
647: , x_return_status => l_return_status
648: );
649: IF l_return_status = FND_API.G_RET_STS_ERROR
650: THEN
651: RAISE FND_API.G_EXC_ERROR;
652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
653: THEN

Line 651: RAISE FND_API.G_EXC_ERROR;

647: , x_return_status => l_return_status
648: );
649: IF l_return_status = FND_API.G_RET_STS_ERROR
650: THEN
651: RAISE FND_API.G_EXC_ERROR;
652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
653: THEN
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: END IF;

Line 652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

648: );
649: IF l_return_status = FND_API.G_RET_STS_ERROR
650: THEN
651: RAISE FND_API.G_EXC_ERROR;
652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
653: THEN
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: END IF;
656: IF l_new_amount = l_trx_amount THEN

Line 654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

650: THEN
651: RAISE FND_API.G_EXC_ERROR;
652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
653: THEN
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: END IF;
656: IF l_new_amount = l_trx_amount THEN
657: --OPEN the cursor for all lines
658: FOR c_line IN lines_csr(p_header_id =>l_source_column1)