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.

[Home] [Help]

APPS.PO_AP_INVOICE_MATCH_GRP dependencies on FND_API

Line 26: -- FND_API.G_RET_STS_SUCCESS if update succeeds

22: -- An object of PO_AP_DIST_REC_TYPE
23: --OUT:
24: --x_return_status
25: -- Apps API param. Value is VARCHAR2(1)
26: -- FND_API.G_RET_STS_SUCCESS if update succeeds
27: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
28: --x_msg_data
29: -- Contains the error details in the case of UNEXP_ERROR or ERROR
30: -------------------------------------------------------------------------

Line 27: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

23: --OUT:
24: --x_return_status
25: -- Apps API param. Value is VARCHAR2(1)
26: -- FND_API.G_RET_STS_SUCCESS if update succeeds
27: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
28: --x_msg_data
29: -- Contains the error details in the case of UNEXP_ERROR or ERROR
30: -------------------------------------------------------------------------
31: PROCEDURE update_document_ap_values(

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52: p_dist_changes_rec.dump_to_log;
53: END IF;
54:
55: -- Initialize return status and msg data
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57: x_msg_data := NULL;
58:
59: d_position := 10;
60:

Line 61: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN

57: x_msg_data := NULL;
58:
59: d_position := 10;
60:
61: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: d_position := 20;

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

58:
59: d_position := 10;
60:
61: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: d_position := 20;
66:

Line 206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

202: ROLLBACK TO update_document_ap_values_SP;
203: IF PO_LOG.d_exc THEN
204: PO_LOG.exc(d_mod,d_position,SQLERRM);
205: END IF;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: FND_MESSAGE.set_name('PO', 'PO_ALL_TRACE_ERROR');
208: FND_MESSAGE.set_token('FILE', 'POXAPINB.pls');
209: FND_MESSAGE.set_token('ERR_NUMBER', SQLERRM(SQLCODE));
210: FND_MESSAGE.set_token('SUBROUTINE', l_api_name);

Line 237: -- FND_API.G_RET_STS_SUCCESS if calculation succeeds

233: -- The amount must be passed in using the PO currency
234: --OUT:
235: --x_return_status
236: -- Apps API Std param. Value is VARCHAR2(1)
237: -- FND_API.G_RET_STS_SUCCESS if calculation succeeds
238: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
239: --x_msg_data
240: -- Contains the error details in the case of UNEXP_ERROR or ERROR
241: --x_amount_to_retain_tbl

Line 238: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

234: --OUT:
235: --x_return_status
236: -- Apps API Std param. Value is VARCHAR2(1)
237: -- FND_API.G_RET_STS_SUCCESS if calculation succeeds
238: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
239: --x_msg_data
240: -- Contains the error details in the case of UNEXP_ERROR or ERROR
241: --x_amount_to_retain_tbl
242: -- Each tbl entry corresponds to 1 entry (with same index) in

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: PO_LOG.proc_begin(d_mod,'p_line_loc_match_amt_tbl',p_line_loc_match_amt_tbl);
267: END IF;
268:
269: -- Initialize out parameters
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271: x_msg_data := NULL;
272: x_amount_to_retain_tbl:= po_tbl_number();
273: x_amount_to_retain_tbl.extend;
274:

Line 277: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN

273: x_amount_to_retain_tbl.extend;
274:
275: d_position := 10;
276:
277: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280:
281: d_position := 20;

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274:
275: d_position := 10;
276:
277: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280:
281: d_position := 20;
282:

Line 349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

345: WHEN OTHERS THEN
346: IF PO_LOG.d_exc THEN
347: PO_LOG.exc(d_mod,d_position,SQLERRM);
348: END IF;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MESSAGE.set_name('PO', 'PO_ALL_TRACE_ERROR');
351: FND_MESSAGE.set_token('FILE', 'POXAPINB.pls');
352: FND_MESSAGE.set_token('ERR_NUMBER', SQLERRM(SQLCODE));
353: FND_MESSAGE.set_token('SUBROUTINE', l_api_name);

Line 389: -- (a) FND_API.G_RET_STS_SUCCESS if successful

385: -- x_ship_amt_cancelled
386: -- The cancelled amount on the PO shipment corresponding to the rcv transaction
387: -- id passed
388: -- x_ret_status
389: -- (a) FND_API.G_RET_STS_SUCCESS if successful
390: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
391: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
392: -- x_msg_count
393: -- The number of error messages to be returned (1 in this case)

Line 390: -- (b) FND_API.G_RET_STS_ERROR if known error occurs

386: -- The cancelled amount on the PO shipment corresponding to the rcv transaction
387: -- id passed
388: -- x_ret_status
389: -- (a) FND_API.G_RET_STS_SUCCESS if successful
390: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
391: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
392: -- x_msg_count
393: -- The number of error messages to be returned (1 in this case)
394: -- x_msg_data

Line 391: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

387: -- id passed
388: -- x_ret_status
389: -- (a) FND_API.G_RET_STS_SUCCESS if successful
390: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
391: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
392: -- x_msg_count
393: -- The number of error messages to be returned (1 in this case)
394: -- x_msg_data
395: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

Line 415: x_ret_status := FND_API.G_RET_STS_SUCCESS;

411:
412: BEGIN
413:
414: -- Initialize return status and msg data
415: x_ret_status := FND_API.G_RET_STS_SUCCESS;
416: x_msg_count := 0;
417: x_msg_data := NULL;
418:
419: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

Line 419: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

415: x_ret_status := FND_API.G_RET_STS_SUCCESS;
416: x_msg_count := 0;
417: x_msg_data := NULL;
418:
419: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
420: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: END IF;
422:
423: -- SQL What : Gets the amount and amount cancelled on the PO shipments corresponding to the

Line 420: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

416: x_msg_count := 0;
417: x_msg_data := NULL;
418:
419: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
420: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: END IF;
422:
423: -- SQL What : Gets the amount and amount cancelled on the PO shipments corresponding to the
424: -- Receive transaction_id

Line 438: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

434: AND rt.transaction_id = p_receive_transaction_id;
435:
436: EXCEPTION
437: WHEN OTHERS THEN
438: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: END;
440:
441:
442: -----------------------------------------------------------------------------------------------

Line 469: -- (a) FND_API.G_RET_STS_SUCCESS if successful

465: -- The amount ordered on the PO distribution
466: -- x_dist_amt_cancelled
467: -- The cancelled amount on the PO distribution
468: -- x_ret_status
469: -- (a) FND_API.G_RET_STS_SUCCESS if successful
470: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
471: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
472: -- x_msg_count
473: -- The number of error messages to be returned (1 in this case)

Line 470: -- (b) FND_API.G_RET_STS_ERROR if known error occurs

466: -- x_dist_amt_cancelled
467: -- The cancelled amount on the PO distribution
468: -- x_ret_status
469: -- (a) FND_API.G_RET_STS_SUCCESS if successful
470: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
471: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
472: -- x_msg_count
473: -- The number of error messages to be returned (1 in this case)
474: -- x_msg_data

Line 471: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

467: -- The cancelled amount on the PO distribution
468: -- x_ret_status
469: -- (a) FND_API.G_RET_STS_SUCCESS if successful
470: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
471: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
472: -- x_msg_count
473: -- The number of error messages to be returned (1 in this case)
474: -- x_msg_data
475: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

Line 496: x_ret_status := FND_API.G_RET_STS_SUCCESS;

492:
493: BEGIN
494:
495: -- Initialize return status and msg data
496: x_ret_status := FND_API.G_RET_STS_SUCCESS;
497: x_msg_count := 0;
498: x_msg_data := NULL;
499:
500: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

Line 500: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

496: x_ret_status := FND_API.G_RET_STS_SUCCESS;
497: x_msg_count := 0;
498: x_msg_data := NULL;
499:
500: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
501: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: END IF;
503:
504: -- SQL What : Gets the amountordered and amount cancelled on the PO distributions

Line 501: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

497: x_msg_count := 0;
498: x_msg_data := NULL;
499:
500: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
501: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: END IF;
503:
504: -- SQL What : Gets the amountordered and amount cancelled on the PO distributions
505: -- corresponding to the distribution id passed

Line 517: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

513: WHERE pod.po_distribution_id = p_po_distribution_id;
514:
515: EXCEPTION
516: WHEN OTHERS THEN
517: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: END;
519:
520: ---------------------------------------------------------------------------------------
521: --Start of Comments

Line 543: -- (a) FND_API.G_RET_STS_SUCCESS if successful

539: --OUT:
540: -- x_dist_amt_billed
541: -- The amount billed to be updated on the PO Shipment
542: -- x_ret_status
543: -- (a) FND_API.G_RET_STS_SUCCESS if successful
544: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
545: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
546: -- x_msg_count
547: -- The number of error messages to be returned (1 in this case)

Line 544: -- (b) FND_API.G_RET_STS_ERROR if known error occurs

540: -- x_dist_amt_billed
541: -- The amount billed to be updated on the PO Shipment
542: -- x_ret_status
543: -- (a) FND_API.G_RET_STS_SUCCESS if successful
544: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
545: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
546: -- x_msg_count
547: -- The number of error messages to be returned (1 in this case)
548: -- x_msg_data

Line 545: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

541: -- The amount billed to be updated on the PO Shipment
542: -- x_ret_status
543: -- (a) FND_API.G_RET_STS_SUCCESS if successful
544: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
545: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
546: -- x_msg_count
547: -- The number of error messages to be returned (1 in this case)
548: -- x_msg_data
549: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

Line 569: x_ret_status := FND_API.G_RET_STS_SUCCESS;

565:
566: BEGIN
567:
568: -- Initialize return status and msg data
569: x_ret_status := FND_API.G_RET_STS_SUCCESS;
570: x_msg_count := 0;
571: x_msg_data := NULL;
572:
573: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

Line 573: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

569: x_ret_status := FND_API.G_RET_STS_SUCCESS;
570: x_msg_count := 0;
571: x_msg_data := NULL;
572:
573: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
574: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: END IF;
576:
577: -- SQL What : Updates the amount billed on the po shipments

Line 574: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

570: x_msg_count := 0;
571: x_msg_data := NULL;
572:
573: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
574: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: END IF;
576:
577: -- SQL What : Updates the amount billed on the po shipments
578: -- SQL Why : This is the amount that was billed against this shipment

Line 587: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

583:
584:
585: EXCEPTION
586: WHEN OTHERS THEN
587: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: END;
589:
590: -----------------------------------------------------------------------------------------------------
591: --Start of Comments

Line 614: -- (a) FND_API.G_RET_STS_SUCCESS if successful

610: --OUT:
611: -- x_dist_amt_billed
612: -- The amount billed to be updated on the PO distribution
613: -- x_ret_status
614: -- (a) FND_API.G_RET_STS_SUCCESS if successful
615: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
616: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
617: -- x_msg_count
618: -- The number of error messages to be returned (1 in this case)

Line 615: -- (b) FND_API.G_RET_STS_ERROR if known error occurs

611: -- x_dist_amt_billed
612: -- The amount billed to be updated on the PO distribution
613: -- x_ret_status
614: -- (a) FND_API.G_RET_STS_SUCCESS if successful
615: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
616: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
617: -- x_msg_count
618: -- The number of error messages to be returned (1 in this case)
619: -- x_msg_data

Line 616: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

612: -- The amount billed to be updated on the PO distribution
613: -- x_ret_status
614: -- (a) FND_API.G_RET_STS_SUCCESS if successful
615: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
616: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
617: -- x_msg_count
618: -- The number of error messages to be returned (1 in this case)
619: -- x_msg_data
620: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

Line 639: x_ret_status := FND_API.G_RET_STS_SUCCESS;

635:
636: BEGIN
637:
638: -- Initialize return status and msg data
639: x_ret_status := FND_API.G_RET_STS_SUCCESS;
640: x_msg_count := 0;
641: x_msg_data := NULL;
642:
643: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

Line 643: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

639: x_ret_status := FND_API.G_RET_STS_SUCCESS;
640: x_msg_count := 0;
641: x_msg_data := NULL;
642:
643: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
644: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
645: END IF;
646:
647: -- SQL What : Updates the amount billed on the po distribution

Line 644: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

640: x_msg_count := 0;
641: x_msg_data := NULL;
642:
643: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
644: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
645: END IF;
646:
647: -- SQL What : Updates the amount billed on the po distribution
648: -- SQL Why : This is the amount that was billed against this distribution

Line 656: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

652: WHERE po_distribution_id = p_po_distribution_id;
653:
654: EXCEPTION
655: WHEN OTHERS THEN
656: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: END;
658:
659: ---------------------------------------------------------------------------------------
660: --Start of Comments

Line 692: -- (a) FND_API.G_RET_STS_SUCCESS if successful

688: -- Allows API callers to ask the API to commit on their behalf after performing its function.
689: --
690: --OUT:
691: -- x_ret_status
692: -- (a) FND_API.G_RET_STS_SUCCESS if successful
693: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
694: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
695: -- x_msg_count
696: -- The number of error messages to be returned (1 in this case)

Line 693: -- (b) FND_API.G_RET_STS_ERROR if known error occurs

689: --
690: --OUT:
691: -- x_ret_status
692: -- (a) FND_API.G_RET_STS_SUCCESS if successful
693: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
694: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
695: -- x_msg_count
696: -- The number of error messages to be returned (1 in this case)
697: -- x_msg_data

Line 694: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

690: --OUT:
691: -- x_ret_status
692: -- (a) FND_API.G_RET_STS_SUCCESS if successful
693: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
694: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
695: -- x_msg_count
696: -- The number of error messages to be returned (1 in this case)
697: -- x_msg_data
698: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

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

704: PROCEDURE set_final_match_flag (p_api_version IN NUMBER ,
705: p_entity_type IN VARCHAR2 ,
706: p_entity_id_tbl IN PO_TBL_NUMBER ,
707: p_final_match_flag IN PO_LINE_LOCATIONS.FINAL_MATCH_FLAG%TYPE ,
708: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
709: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
710: x_ret_status OUT NOCOPY VARCHAR2 ,
711: x_msg_count OUT NOCOPY NUMBER ,
712: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 709: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

705: p_entity_type IN VARCHAR2 ,
706: p_entity_id_tbl IN PO_TBL_NUMBER ,
707: p_final_match_flag IN PO_LINE_LOCATIONS.FINAL_MATCH_FLAG%TYPE ,
708: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
709: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
710: x_ret_status OUT NOCOPY VARCHAR2 ,
711: x_msg_count OUT NOCOPY NUMBER ,
712: x_msg_data OUT NOCOPY VARCHAR2 ) IS
713:

Line 723: IF FND_API.to_Boolean (p_init_msg_list) THEN

719: -- Standard Start of API savepoint
720: SAVEPOINT set_final_match_flag_PVT;
721:
722: -- Initialize message list if p_init_msg_list is set to TRUE.
723: IF FND_API.to_Boolean (p_init_msg_list) THEN
724: FND_MSG_PUB.initialize;
725: END IF;
726:
727: -- Initialize return status and msg data

Line 728: x_ret_status := FND_API.G_RET_STS_SUCCESS;

724: FND_MSG_PUB.initialize;
725: END IF;
726:
727: -- Initialize return status and msg data
728: x_ret_status := FND_API.G_RET_STS_SUCCESS;
729: x_msg_count := 0;
730: x_msg_data := NULL;
731:
732: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN

Line 732: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN

728: x_ret_status := FND_API.G_RET_STS_SUCCESS;
729: x_msg_count := 0;
730: x_msg_data := NULL;
731:
732: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
733:
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735:
736: END IF;

Line 734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

730: x_msg_data := NULL;
731:
732: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
733:
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735:
736: END IF;
737:
738: IF p_entity_type <> 'PO_LINE_LOCATIONS' THEN

Line 740: RAISE FND_API.G_EXC_ERROR;

736: END IF;
737:
738: IF p_entity_type <> 'PO_LINE_LOCATIONS' THEN
739:
740: RAISE FND_API.G_EXC_ERROR;
741:
742: ELSE
743: -- SQL What : Updates the final_match_flag on the po shipments
744: -- SQL Why : This is to indicate the shipment has been finally matched by an invoice.

Line 755: IF FND_API.To_Boolean (p_commit) THEN

751:
752: END IF;
753:
754: -- Standard check of p_commit.
755: IF FND_API.To_Boolean (p_commit) THEN
756: COMMIT;
757: END IF;
758:
759: -- Standard call to get message count and if count is 1, get message info.

Line 766: WHEN FND_API.G_EXC_ERROR THEN

762:
763:
764: EXCEPTION
765:
766: WHEN FND_API.G_EXC_ERROR THEN
767:
768: ROLLBACK TO set_final_match_flag_PVT;
769: x_ret_status := FND_API.G_RET_STS_ERROR ;
770: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 769: x_ret_status := FND_API.G_RET_STS_ERROR ;

765:
766: WHEN FND_API.G_EXC_ERROR THEN
767:
768: ROLLBACK TO set_final_match_flag_PVT;
769: x_ret_status := FND_API.G_RET_STS_ERROR ;
770: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
771: p_data => x_msg_data );
772:
773:

Line 774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

770: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
771: p_data => x_msg_data );
772:
773:
774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
775:
776: ROLLBACK TO set_final_match_flag_PVT;
777: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
778: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 777: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;

773:
774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
775:
776: ROLLBACK TO set_final_match_flag_PVT;
777: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
778: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
779: p_data => x_msg_data );
780:
781: WHEN OTHERS THEN

Line 784: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;

780:
781: WHEN OTHERS THEN
782:
783: ROLLBACK TO set_final_match_flag_PVT;
784: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
786: p_data => x_msg_data );
787:
788: END set_final_match_flag;