APPS.GMO_DOCUMENT_NUMBERS_PVT dependencies on FND_API

Line 125: IF FND_API.TO_BOOLEAN( P_INIT_MSG_LIST ) THEN

121: BEGIN
122:
123:
124: --Initialize the message list if specified so.
125: IF FND_API.TO_BOOLEAN( P_INIT_MSG_LIST ) THEN
126:
127: FND_MSG_PUB.INITIALIZE;
128:
129: END IF;

Line 190: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

186: CLOSE GET_DOC_NUM_TYPE_NO_ORG_C;
187:
188: END IF;
189:
190: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
191:
192: --Get the message count.
193: --If count is 1, then get the message data.
194: FND_MSG_PUB.COUNT_AND_GET

Line 204: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;

200:
201: WHEN INVALID_PARAMS_ERROR THEN
202:
203: X_DOCUMENT_NUMBER_TYPE := NULL;
204: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
205:
206: IF L_INVALID_ORG_NAME IS NOT NULL THEN
207:
208: FND_MESSAGE.SET_NAME('GMO','GMO_DOC_NUM_PARAMS_ERR');

Line 250: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

246:
247: END IF;
248:
249: X_DOCUMENT_NUMBER_TYPE := NULL;
250: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
251:
252:
253: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
254: FND_MSG_PUB.ADD_EXC_MSG

Line 369: IF FND_API.TO_BOOLEAN( P_INIT_MSG_LIST ) THEN

365:
366: BEGIN
367:
368: --Initialize the message list if specified so.
369: IF FND_API.TO_BOOLEAN( P_INIT_MSG_LIST ) THEN
370:
371: FND_MSG_PUB.INITIALIZE;
372:
373: END IF;

Line 581: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

577:
578: --Commit the transaction.
579: COMMIT;
580:
581: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
582:
583: END IF;
584:
585:

Line 591: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

587:
588: WHEN INVALID_PARAMS_ERROR THEN
589: ROLLBACK;
590: X_VALUE := NULL;
591: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
592:
593: IF L_INVALID_ORG_NAME IS NOT NULL THEN
594:
595: FND_MESSAGE.SET_NAME('GMO','GMO_DOC_NUM_PARAMS_ERR');

Line 623: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

619:
620: ROLLBACK;
621:
622: X_VALUE := NULL;
623: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
624:
625: IF L_INVALID_ORG_NAME IS NOT NULL THEN
626:
627: FND_MESSAGE.SET_NAME('GMO','GMO_DOC_NUM_DOC_TYPE_ERR');

Line 655: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

651: WHEN MAX_VALUE_ERROR THEN
652:
653: ROLLBACK;
654: X_VALUE := NULL;
655: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
656:
657: IF L_INVALID_ORG_NAME IS NOT NULL THEN
658:
659: FND_MESSAGE.SET_NAME('GMO','GMO_DOC_NUM_MAX_VALUE_ERR');

Line 686: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

682: WHEN OTHERS THEN
683: ROLLBACK;
684:
685: X_VALUE := NULL;
686: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
687:
688: IF GET_DOC_NUM_DETAILS_C%ISOPEN THEN
689:
690: --Close the cursor.

Line 727: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

723: --organization and transaction type.
724: PROCEDURE DOES_DOCUMENT_NUMBER_EXIST
725: (P_ORGANIZATION_ID IN NUMBER,
726: P_TRANSACTION_TYPE IN VARCHAR2,
727: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
728: X_DOCUMENT_NUMBER_EXISTS OUT NOCOPY VARCHAR2,
729: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
730: X_MSG_COUNT OUT NOCOPY NUMBER,
731: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 766: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_TRUE;

762: END IF;
763:
764: --Return the status value based on the count parameter.
765: IF L_COUNT > 0 THEN
766: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_TRUE;
767: ELSE
768: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_FALSE;
769: END IF;
770:

Line 768: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_FALSE;

764: --Return the status value based on the count parameter.
765: IF L_COUNT > 0 THEN
766: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_TRUE;
767: ELSE
768: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_FALSE;
769: END IF;
770:
771: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
772:

Line 771: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

767: ELSE
768: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_FALSE;
769: END IF;
770:
771: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
772:
773: EXCEPTION
774:
775: WHEN OTHERS THEN

Line 777: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_FALSE;

773: EXCEPTION
774:
775: WHEN OTHERS THEN
776:
777: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_FALSE;
778:
779: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
780:
781: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 779: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

775: WHEN OTHERS THEN
776:
777: X_DOCUMENT_NUMBER_EXISTS := FND_API.G_FALSE;
778:
779: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
780:
781: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
782: FND_MSG_PUB.ADD_EXC_MSG
783: (G_PKG_NAME,