DBA Data[Home] [Help]

APPS.GR_DISPATCH_HISTORY_PVT dependencies on FND_API

Line 80: -- FND_API.G_RET_STS_SUCCESS if API succeeds

76: --p_creation_source IN NUMBER,
77:
78: --OUT:
79: --x_return_status
80: -- FND_API.G_RET_STS_SUCCESS if API succeeds
81: -- FND_API.G_RET_STS_ERROR if API fails
82: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
83: --x_msg_count Number of error message in the error message
84: -- list

Line 81: -- FND_API.G_RET_STS_ERROR if API fails

77:
78: --OUT:
79: --x_return_status
80: -- FND_API.G_RET_STS_SUCCESS if API succeeds
81: -- FND_API.G_RET_STS_ERROR if API fails
82: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
83: --x_msg_count Number of error message in the error message
84: -- list
85: --

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

78: --OUT:
79: --x_return_status
80: -- FND_API.G_RET_STS_SUCCESS if API succeeds
81: -- FND_API.G_RET_STS_ERROR if API fails
82: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
83: --x_msg_count Number of error message in the error message
84: -- list
85: --
86: --x_msg_data If the number of error message in the error

Line 517: IF (x_return_status = FND_API.G_RET_STS_ERROR)

513: P_LAST_UPDATE_DATE => SYSDATE,
514: X_RETURN_STATUS => x_return_status,
515: X_MSG_DATA => x_msg_data);
516:
517: IF (x_return_status = FND_API.G_RET_STS_ERROR)
518: THEN
519: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
520: log_msg('EDR Upload failed with expected error.');
521: END IF;

Line 522: RAISE FND_API.G_EXC_ERROR;

518: THEN
519: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
520: log_msg('EDR Upload failed with expected error.');
521: END IF;
522: RAISE FND_API.G_EXC_ERROR;
523: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
524: THEN
525: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
526: log_msg('EDR Upload failed with unexpected error.');

Line 523: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

519: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
520: log_msg('EDR Upload failed with expected error.');
521: END IF;
522: RAISE FND_API.G_EXC_ERROR;
523: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
524: THEN
525: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
526: log_msg('EDR Upload failed with unexpected error.');
527: END IF;

Line 528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

524: THEN
525: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
526: log_msg('EDR Upload failed with unexpected error.');
527: END IF;
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;
530: IF (c_check_document_edr%ISOPEN) THEN
531: CLOSE c_check_document_edr;
532: END IF;

Line 709: x_return_status := FND_API.G_RET_STS_SUCCESS;

705: p_user_id,
706: sysdate,
707: -1);
708:
709: x_return_status := FND_API.G_RET_STS_SUCCESS;
710:
711: EXCEPTION
712:
713: WHEN INVALID_VALUE THEN

Line 714: x_return_status := FND_API.G_RET_STS_ERROR;

710:
711: EXCEPTION
712:
713: WHEN INVALID_VALUE THEN
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: FND_MSG_PUB.Count_And_Get (
716: p_count => x_msg_count,
717: p_data => x_msg_data );
718:

Line 723: x_return_status := FND_API.G_RET_STS_ERROR;

719: WHEN INVALID_USER_ID THEN
720: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_USER_ID');
721: FND_MESSAGE.SET_TOKEN('USER_ID', p_user_id);
722: FND_MSG_PUB.Add;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: FND_MSG_PUB.Count_And_Get (
725: p_count => x_msg_count,
726: p_data => x_msg_data );
727:

Line 732: x_return_status := FND_API.G_RET_STS_ERROR;

728: WHEN INVALID_DOCUMENT_ID THEN
729: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_ID');
730: FND_MESSAGE.SET_TOKEN('DOCUMENT_ID', p_document_id);
731: FND_MSG_PUB.Add;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_And_Get (
734: p_count => x_msg_count,
735: p_data => x_msg_data );
736:

Line 741: x_return_status := FND_API.G_RET_STS_ERROR;

737: WHEN INVALID_DOCUMENT_CATEGORY THEN
738: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_CATEGORY');
739: FND_MESSAGE.SET_TOKEN('DOC_CATEGORY', p_document_category);
740: FND_MSG_PUB.Add;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: FND_MSG_PUB.Count_And_Get (
743: p_count => x_msg_count,
744: p_data => x_msg_data );
745:

Line 750: x_return_status := FND_API.G_RET_STS_ERROR;

746: WHEN INVALID_DISPATCH_METHOD_CODE THEN
747: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISPATCH_METHOD');
748: FND_MESSAGE.SET_TOKEN('DISPATCH_METHOD_CODE', p_dispatch_method_code);
749: FND_MSG_PUB.Add;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get (
752: p_count => x_msg_count,
753: p_data => x_msg_data );
754:

Line 759: x_return_status := FND_API.G_RET_STS_ERROR;

755: WHEN INVALID_DISCLOSURE_CODE THEN
756: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISCLOSURE_CODE');
757: FND_MESSAGE.SET_TOKEN('CODE', p_disclosure_code);
758: FND_MSG_PUB.Add;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_MSG_PUB.Count_And_Get (
761: p_count => x_msg_count,
762: p_data => x_msg_data );
763:

Line 768: x_return_status := FND_API.G_RET_STS_ERROR;

764: WHEN INVALID_DOCUMENT_LANGUAGE THEN
765: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_LANGUAGE');
766: FND_MESSAGE.SET_TOKEN('LANGUAGE', p_language);
767: FND_MSG_PUB.Add;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MSG_PUB.Count_And_Get (
770: p_count => x_msg_count,
771: p_data => x_msg_data );
772:

Line 776: x_return_status := FND_API.G_RET_STS_ERROR;

772:
773: WHEN INVALID_DOCUMENT_VERSION THEN
774: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOC_VERSION');
775: FND_MSG_PUB.Add;
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: FND_MSG_PUB.Count_And_Get (
778: p_count => x_msg_count,
779: p_data => x_msg_data );
780:

Line 785: x_return_status := FND_API.G_RET_STS_ERROR;

781: WHEN INVALID_DATE_SENT THEN
782: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DATE_SENT');
783: FND_MESSAGE.SET_TOKEN('DATE_SENT', p_date_sent);
784: FND_MSG_PUB.Add;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: FND_MSG_PUB.Count_And_Get (
787: p_count => x_msg_count,
788: p_data => x_msg_data );
789:

Line 794: x_return_status := FND_API.G_RET_STS_ERROR;

790: WHEN INVALID_CREATION_SOURCE THEN
791: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_CREATION_SOURCE');
792: FND_MESSAGE.SET_TOKEN('CREATION_SOURCE', p_creation_source);
793: FND_MSG_PUB.Add;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: FND_MSG_PUB.Count_And_Get (
796: p_count => x_msg_count,
797: p_data => x_msg_data );
798:

Line 803: x_return_status := FND_API.G_RET_STS_ERROR;

799: WHEN INVALID_RECIPIENT_ID THEN
800: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_ID');
801: FND_MESSAGE.SET_TOKEN('RECIPIENT_ID', p_recipient_id);
802: FND_MSG_PUB.Add;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get (
805: p_count => x_msg_count,
806: p_data => x_msg_data );
807:

Line 812: x_return_status := FND_API.G_RET_STS_ERROR;

808: WHEN INVALID_RECIPIENT_SITE_ID THEN
809: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_SITE_ID');
810: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', p_recipient_site_id);
811: FND_MSG_PUB.Add;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: FND_MSG_PUB.Count_And_Get (
814: p_count => x_msg_count,
815: p_data => x_msg_data );
816: WHEN FILE_ERROR THEN

Line 820: x_return_status := FND_API.G_RET_STS_ERROR;

816: WHEN FILE_ERROR THEN
817: FND_MESSAGE.SET_NAME('GR', 'GR_FILE_ERROR');
818: FND_MESSAGE.SET_TOKEN('FILE', p_document_location||'/'||p_document_name);
819: FND_MSG_PUB.Add;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (
822: p_count => x_msg_count,
823: p_data => x_msg_data );
824:

Line 825: WHEN FND_API.G_EXC_ERROR THEN

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

Line 826: x_return_status := FND_API.G_RET_STS_ERROR;

822: p_count => x_msg_count,
823: p_data => x_msg_data );
824:
825: WHEN FND_API.G_EXC_ERROR THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,
828: p_data => x_msg_data);
829:
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

826: x_return_status := FND_API.G_RET_STS_ERROR;
827: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,
828: p_data => x_msg_data);
829:
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,
833: p_data => x_msg_data);
834:

Line 831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

827: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,
828: p_data => x_msg_data);
829:
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,
833: p_data => x_msg_data);
834:
835: WHEN OTHERS THEN

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

833: p_data => x_msg_data);
834:
835: WHEN OTHERS THEN
836: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name, SQLERRM);
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
839: p_data => x_msg_data );
840:
841: END CREATE_DISPATCH_HISTORY_REC;