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 210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 241: -- FND_API.G_RET_STS_SUCCESS if calculation succeeds

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

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

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

Line 274: x_return_status := FND_API.G_RET_STS_SUCCESS;

270: PO_LOG.proc_begin(d_mod,'p_line_loc_match_amt_tbl',p_line_loc_match_amt_tbl);
271: END IF;
272:
273: -- Initialize out parameters
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: x_msg_data := NULL;
276: x_amount_to_retain_tbl:= po_tbl_number();
277: x_amount_to_retain_tbl.extend;
278:

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

277: x_amount_to_retain_tbl.extend;
278:
279: d_position := 10;
280:
281: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284:
285: d_position := 20;

Line 282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

278:
279: d_position := 10;
280:
281: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284:
285: d_position := 20;
286:

Line 405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

401: WHEN OTHERS THEN
402: IF PO_LOG.d_exc THEN
403: PO_LOG.exc(d_mod,d_position,SQLERRM);
404: END IF;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: FND_MESSAGE.set_name('PO', 'PO_ALL_TRACE_ERROR');
407: FND_MESSAGE.set_token('FILE', 'POXAPINB.pls');
408: FND_MESSAGE.set_token('ERR_NUMBER', SQLERRM(SQLCODE));
409: FND_MESSAGE.set_token('SUBROUTINE', l_api_name);

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

441: -- x_ship_amt_cancelled
442: -- The cancelled amount on the PO shipment corresponding to the rcv transaction
443: -- id passed
444: -- x_ret_status
445: -- (a) FND_API.G_RET_STS_SUCCESS if successful
446: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
447: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
448: -- x_msg_count
449: -- The number of error messages to be returned (1 in this case)

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

442: -- The cancelled amount on the PO shipment corresponding to the rcv transaction
443: -- id passed
444: -- x_ret_status
445: -- (a) FND_API.G_RET_STS_SUCCESS if successful
446: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
447: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
448: -- x_msg_count
449: -- The number of error messages to be returned (1 in this case)
450: -- x_msg_data

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

443: -- id passed
444: -- x_ret_status
445: -- (a) FND_API.G_RET_STS_SUCCESS if successful
446: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
447: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
448: -- x_msg_count
449: -- The number of error messages to be returned (1 in this case)
450: -- x_msg_data
451: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

Line 471: x_ret_status := FND_API.G_RET_STS_SUCCESS;

467:
468: BEGIN
469:
470: -- Initialize return status and msg data
471: x_ret_status := FND_API.G_RET_STS_SUCCESS;
472: x_msg_count := 0;
473: x_msg_data := NULL;
474:
475: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

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

471: x_ret_status := FND_API.G_RET_STS_SUCCESS;
472: x_msg_count := 0;
473: x_msg_data := NULL;
474:
475: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
476: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: END IF;
478:
479: -- SQL What : Gets the amount and amount cancelled on the PO shipments corresponding to the

Line 476: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

472: x_msg_count := 0;
473: x_msg_data := NULL;
474:
475: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
476: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: END IF;
478:
479: -- SQL What : Gets the amount and amount cancelled on the PO shipments corresponding to the
480: -- Receive transaction_id

Line 494: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

490: AND rt.transaction_id = p_receive_transaction_id;
491:
492: EXCEPTION
493: WHEN OTHERS THEN
494: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: END;
496:
497:
498: -----------------------------------------------------------------------------------------------

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

521: -- The amount ordered on the PO distribution
522: -- x_dist_amt_cancelled
523: -- The cancelled amount on the PO distribution
524: -- x_ret_status
525: -- (a) FND_API.G_RET_STS_SUCCESS if successful
526: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
527: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
528: -- x_msg_count
529: -- The number of error messages to be returned (1 in this case)

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

522: -- x_dist_amt_cancelled
523: -- The cancelled amount on the PO distribution
524: -- x_ret_status
525: -- (a) FND_API.G_RET_STS_SUCCESS if successful
526: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
527: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
528: -- x_msg_count
529: -- The number of error messages to be returned (1 in this case)
530: -- x_msg_data

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

523: -- The cancelled amount on the PO distribution
524: -- x_ret_status
525: -- (a) FND_API.G_RET_STS_SUCCESS if successful
526: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
527: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
528: -- x_msg_count
529: -- The number of error messages to be returned (1 in this case)
530: -- x_msg_data
531: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

Line 552: x_ret_status := FND_API.G_RET_STS_SUCCESS;

548:
549: BEGIN
550:
551: -- Initialize return status and msg data
552: x_ret_status := FND_API.G_RET_STS_SUCCESS;
553: x_msg_count := 0;
554: x_msg_data := NULL;
555:
556: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

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

552: x_ret_status := FND_API.G_RET_STS_SUCCESS;
553: x_msg_count := 0;
554: x_msg_data := NULL;
555:
556: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
557: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: END IF;
559:
560: -- SQL What : Gets the amountordered and amount cancelled on the PO distributions

Line 557: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

553: x_msg_count := 0;
554: x_msg_data := NULL;
555:
556: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
557: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: END IF;
559:
560: -- SQL What : Gets the amountordered and amount cancelled on the PO distributions
561: -- corresponding to the distribution id passed

Line 573: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

569: WHERE pod.po_distribution_id = p_po_distribution_id;
570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: END;
575:
576: ---------------------------------------------------------------------------------------
577: --Start of Comments

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

595: --OUT:
596: -- x_dist_amt_billed
597: -- The amount billed to be updated on the PO Shipment
598: -- x_ret_status
599: -- (a) FND_API.G_RET_STS_SUCCESS if successful
600: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
601: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
602: -- x_msg_count
603: -- The number of error messages to be returned (1 in this case)

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

596: -- x_dist_amt_billed
597: -- The amount billed to be updated on the PO Shipment
598: -- x_ret_status
599: -- (a) FND_API.G_RET_STS_SUCCESS if successful
600: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
601: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
602: -- x_msg_count
603: -- The number of error messages to be returned (1 in this case)
604: -- x_msg_data

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

597: -- The amount billed to be updated on the PO Shipment
598: -- x_ret_status
599: -- (a) FND_API.G_RET_STS_SUCCESS if successful
600: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
601: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
602: -- x_msg_count
603: -- The number of error messages to be returned (1 in this case)
604: -- x_msg_data
605: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

Line 625: x_ret_status := FND_API.G_RET_STS_SUCCESS;

621:
622: BEGIN
623:
624: -- Initialize return status and msg data
625: x_ret_status := FND_API.G_RET_STS_SUCCESS;
626: x_msg_count := 0;
627: x_msg_data := NULL;
628:
629: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

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

625: x_ret_status := FND_API.G_RET_STS_SUCCESS;
626: x_msg_count := 0;
627: x_msg_data := NULL;
628:
629: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
630: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: END IF;
632:
633: -- SQL What : Updates the amount billed on the po shipments

Line 630: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

626: x_msg_count := 0;
627: x_msg_data := NULL;
628:
629: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
630: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: END IF;
632:
633: -- SQL What : Updates the amount billed on the po shipments
634: -- SQL Why : This is the amount that was billed against this shipment

Line 643: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

639:
640:
641: EXCEPTION
642: WHEN OTHERS THEN
643: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: END;
645:
646: -----------------------------------------------------------------------------------------------------
647: --Start of Comments

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

666: --OUT:
667: -- x_dist_amt_billed
668: -- The amount billed to be updated on the PO distribution
669: -- x_ret_status
670: -- (a) FND_API.G_RET_STS_SUCCESS if successful
671: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
672: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
673: -- x_msg_count
674: -- The number of error messages to be returned (1 in this case)

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

667: -- x_dist_amt_billed
668: -- The amount billed to be updated on the PO distribution
669: -- x_ret_status
670: -- (a) FND_API.G_RET_STS_SUCCESS if successful
671: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
672: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
673: -- x_msg_count
674: -- The number of error messages to be returned (1 in this case)
675: -- x_msg_data

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

668: -- The amount billed to be updated on the PO distribution
669: -- x_ret_status
670: -- (a) FND_API.G_RET_STS_SUCCESS if successful
671: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
672: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
673: -- x_msg_count
674: -- The number of error messages to be returned (1 in this case)
675: -- x_msg_data
676: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

Line 695: x_ret_status := FND_API.G_RET_STS_SUCCESS;

691:
692: BEGIN
693:
694: -- Initialize return status and msg data
695: x_ret_status := FND_API.G_RET_STS_SUCCESS;
696: x_msg_count := 0;
697: x_msg_data := NULL;
698:
699: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN

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

695: x_ret_status := FND_API.G_RET_STS_SUCCESS;
696: x_msg_count := 0;
697: x_msg_data := NULL;
698:
699: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
700: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: END IF;
702:
703: -- SQL What : Updates the amount billed on the po distribution

Line 700: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

696: x_msg_count := 0;
697: x_msg_data := NULL;
698:
699: IF ( NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) ) THEN
700: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: END IF;
702:
703: -- SQL What : Updates the amount billed on the po distribution
704: -- SQL Why : This is the amount that was billed against this distribution

Line 712: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

708: WHERE po_distribution_id = p_po_distribution_id;
709:
710: EXCEPTION
711: WHEN OTHERS THEN
712: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: END;
714:
715: ---------------------------------------------------------------------------------------
716: --Start of Comments

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

744: -- Allows API callers to ask the API to commit on their behalf after performing its function.
745: --
746: --OUT:
747: -- x_ret_status
748: -- (a) FND_API.G_RET_STS_SUCCESS if successful
749: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
750: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
751: -- x_msg_count
752: -- The number of error messages to be returned (1 in this case)

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

745: --
746: --OUT:
747: -- x_ret_status
748: -- (a) FND_API.G_RET_STS_SUCCESS if successful
749: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
750: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
751: -- x_msg_count
752: -- The number of error messages to be returned (1 in this case)
753: -- x_msg_data

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

746: --OUT:
747: -- x_ret_status
748: -- (a) FND_API.G_RET_STS_SUCCESS if successful
749: -- (b) FND_API.G_RET_STS_ERROR if known error occurs
750: -- (c) FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
751: -- x_msg_count
752: -- The number of error messages to be returned (1 in this case)
753: -- x_msg_data
754: -- The error message if the msg ct > 0 should be retrieved using FND_MSG_PUB.get

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

760: PROCEDURE set_final_match_flag (p_api_version IN NUMBER ,
761: p_entity_type IN VARCHAR2 ,
762: p_entity_id_tbl IN PO_TBL_NUMBER ,
763: p_final_match_flag IN PO_LINE_LOCATIONS.FINAL_MATCH_FLAG%TYPE ,
764: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
765: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
766: x_ret_status OUT NOCOPY VARCHAR2 ,
767: x_msg_count OUT NOCOPY NUMBER ,
768: x_msg_data OUT NOCOPY VARCHAR2 ) IS

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

761: p_entity_type IN VARCHAR2 ,
762: p_entity_id_tbl IN PO_TBL_NUMBER ,
763: p_final_match_flag IN PO_LINE_LOCATIONS.FINAL_MATCH_FLAG%TYPE ,
764: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
765: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
766: x_ret_status OUT NOCOPY VARCHAR2 ,
767: x_msg_count OUT NOCOPY NUMBER ,
768: x_msg_data OUT NOCOPY VARCHAR2 ) IS
769:

Line 779: IF FND_API.to_Boolean (p_init_msg_list) THEN

775: -- Standard Start of API savepoint
776: SAVEPOINT set_final_match_flag_PVT;
777:
778: -- Initialize message list if p_init_msg_list is set to TRUE.
779: IF FND_API.to_Boolean (p_init_msg_list) THEN
780: FND_MSG_PUB.initialize;
781: END IF;
782:
783: -- Initialize return status and msg data

Line 784: x_ret_status := FND_API.G_RET_STS_SUCCESS;

780: FND_MSG_PUB.initialize;
781: END IF;
782:
783: -- Initialize return status and msg data
784: x_ret_status := FND_API.G_RET_STS_SUCCESS;
785: x_msg_count := 0;
786: x_msg_data := NULL;
787:
788: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN

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

784: x_ret_status := FND_API.G_RET_STS_SUCCESS;
785: x_msg_count := 0;
786: x_msg_data := NULL;
787:
788: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
789:
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791:
792: END IF;

Line 790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

786: x_msg_data := NULL;
787:
788: IF (NOT FND_API.compatible_api_call (l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
789:
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791:
792: END IF;
793:
794: IF p_entity_type <> 'PO_LINE_LOCATIONS' THEN

Line 796: RAISE FND_API.G_EXC_ERROR;

792: END IF;
793:
794: IF p_entity_type <> 'PO_LINE_LOCATIONS' THEN
795:
796: RAISE FND_API.G_EXC_ERROR;
797:
798: ELSE
799: -- SQL What : Updates the final_match_flag on the po shipments
800: -- SQL Why : This is to indicate the shipment has been finally matched by an invoice.

Line 811: IF FND_API.To_Boolean (p_commit) THEN

807:
808: END IF;
809:
810: -- Standard check of p_commit.
811: IF FND_API.To_Boolean (p_commit) THEN
812: COMMIT;
813: END IF;
814:
815: -- Standard call to get message count and if count is 1, get message info.

Line 822: WHEN FND_API.G_EXC_ERROR THEN

818:
819:
820: EXCEPTION
821:
822: WHEN FND_API.G_EXC_ERROR THEN
823:
824: ROLLBACK TO set_final_match_flag_PVT;
825: x_ret_status := FND_API.G_RET_STS_ERROR ;
826: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 825: x_ret_status := FND_API.G_RET_STS_ERROR ;

821:
822: WHEN FND_API.G_EXC_ERROR THEN
823:
824: ROLLBACK TO set_final_match_flag_PVT;
825: x_ret_status := FND_API.G_RET_STS_ERROR ;
826: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
827: p_data => x_msg_data );
828:
829:

Line 830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

826: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
827: p_data => x_msg_data );
828:
829:
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831:
832: ROLLBACK TO set_final_match_flag_PVT;
833: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 833: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;

829:
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831:
832: ROLLBACK TO set_final_match_flag_PVT;
833: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
834: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
835: p_data => x_msg_data );
836:
837: WHEN OTHERS THEN

Line 840: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;

836:
837: WHEN OTHERS THEN
838:
839: ROLLBACK TO set_final_match_flag_PVT;
840: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
842: p_data => x_msg_data );
843:
844: END set_final_match_flag;