APPS.GMO_DOCUMENT_NUMBERS_PVT dependencies on GMO_DOCUMENT_NUMBERS

Line 1: PACKAGE BODY GMO_DOCUMENT_NUMBERS_PVT

1: PACKAGE BODY GMO_DOCUMENT_NUMBERS_PVT
2: /* $Header: GMOVDNMB.pls 120.5 2006/01/19 09:23 swasubra noship $ */
3:
4: AS
5:

Line 107: FROM GMO_DOCUMENT_NUMBERS

103:
104: --This cursor obtains the document number type for the specified organization ID and transaction type.
105: CURSOR GET_DOC_NUM_TYPE_C IS
106: SELECT DOC_TYPE
107: FROM GMO_DOCUMENT_NUMBERS
108: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
109: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
110:
111: --This cursor obtains the document number type for the specified transaction type which is not bound to any organization.

Line 114: FROM GMO_DOCUMENT_NUMBERS

110:
111: --This cursor obtains the document number type for the specified transaction type which is not bound to any organization.
112: CURSOR GET_DOC_NUM_TYPE_NO_ORG_C IS
113: SELECT DOC_TYPE
114: FROM GMO_DOCUMENT_NUMBERS
115: WHERE ORGANIZATION_ID IS NULL
116: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
117:
118: --This exception will be raised if no document number exists for the specified organization ID and transaction type.

Line 227: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_DOCUMENT_NUMBER_TYPE',

223: P_DATA => X_MSG_DATA);
224:
225: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
227: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_DOCUMENT_NUMBER_TYPE',
228: FALSE);
229: END IF;
230:
231: WHEN OTHERS THEN

Line 265: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_DOCUMENT_NUMBER_TYPE',

261: P_DATA => X_MSG_DATA);
262:
263: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
264: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
265: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_DOCUMENT_NUMBER_TYPE',
266: FALSE);
267: END IF;
268:
269: END GET_DOCUMENT_NUMBER_TYPE;

Line 344: FROM GMO_DOCUMENT_NUMBERS

340: DOC_LENGTH,
341: DOC_PREFIX,
342: DOC_SUFFIX,
343: DOC_SEPARATOR
344: FROM GMO_DOCUMENT_NUMBERS
345: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
346: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
347:
348: --This cursor obtains the details of the document number associated with the

Line 360: FROM GMO_DOCUMENT_NUMBERS

356: DOC_LENGTH,
357: DOC_PREFIX,
358: DOC_SUFFIX,
359: DOC_SEPARATOR
360: FROM GMO_DOCUMENT_NUMBERS
361: WHERE ORGANIZATION_ID IS NULL
362: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
363:
364: PRAGMA AUTONOMOUS_TRANSACTION;

Line 455: IF L_DOC_TYPE = GMO_DOCUMENT_NUMBERS_GRP.G_DOC_TYPE_MANUAL THEN

451:
452: END IF;
453:
454:
455: IF L_DOC_TYPE = GMO_DOCUMENT_NUMBERS_GRP.G_DOC_TYPE_MANUAL THEN
456:
457: --The document type is set to Manual.
458:
459: --Obtain the organization and transaction names.

Line 527: IF L_ZERO_PAD_OPTION = GMO_DOCUMENT_NUMBERS_GRP.G_ZERO_PAD_YES THEN

523:
524: ELSE
525:
526: --If the zero pad is used then set the zero padding appropriately.
527: IF L_ZERO_PAD_OPTION = GMO_DOCUMENT_NUMBERS_GRP.G_ZERO_PAD_YES THEN
528:
529: L_NO_OF_ZEROS := L_LENGTH - L_NO_OF_DIGITS;
530:
531: FOR i IN 1..L_NO_OF_ZEROS LOOP

Line 558: UPDATE GMO_DOCUMENT_NUMBERS

554:
555: --Update the table with the newly computed next val sequence.
556: IF P_ORGANIZATION_ID IS NOT NULL THEN
557:
558: UPDATE GMO_DOCUMENT_NUMBERS
559: SET DOC_CURRENTVAL = L_NEXTVAL,
560: LAST_UPDATE_DATE = SYSDATE,
561: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
562: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 568: UPDATE GMO_DOCUMENT_NUMBERS

564: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
565:
566: ELSE
567:
568: UPDATE GMO_DOCUMENT_NUMBERS
569: SET DOC_CURRENTVAL = L_NEXTVAL,
570: LAST_UPDATE_DATE = SYSDATE,
571: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
572: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 614: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_NEXT_VALUE',

610: P_DATA => X_MSG_DATA);
611:
612: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
613: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
614: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_NEXT_VALUE',
615: FALSE);
616: END IF;
617:
618: WHEN DOC_TYPE_ERROR THEN

Line 647: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_NEXT_VALUE',

643: P_DATA => X_MSG_DATA);
644:
645: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
646: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
647: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_NEXT_VALUE',
648: FALSE);
649: END IF;
650:
651: WHEN MAX_VALUE_ERROR THEN

Line 678: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_NEXT_VALUE',

674: P_DATA => X_MSG_DATA);
675:
676: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
677: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
678: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_NEXT_VALUE',
679: FALSE);
680: END IF;
681:
682: WHEN OTHERS THEN

Line 716: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_NEXT_VALUE',

712: P_DATA => X_MSG_DATA);
713:
714: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
715: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
716: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.GET_NEXT_VALUE',
717: FALSE);
718: END IF;
719:
720: END GET_NEXT_VALUE;

Line 751: FROM GMO_DOCUMENT_NUMBERS

747: --organization ID and transaction type.
748: IF P_ORGANIZATION_ID IS NULL THEN
749:
750: SELECT COUNT(*) INTO L_COUNT
751: FROM GMO_DOCUMENT_NUMBERS
752: WHERE ORGANIZATION_ID IS NULL
753: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
754:
755: ELSE

Line 758: FROM GMO_DOCUMENT_NUMBERS

754:
755: ELSE
756:
757: SELECT COUNT(*) INTO L_COUNT
758: FROM GMO_DOCUMENT_NUMBERS
759: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
760: AND TRANSACTION_TYPE = P_TRANSACTION_TYPE;
761:
762: END IF;

Line 793: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.DOES_DOCUMENT_NUMBER_EXIST',

789: P_DATA => X_MSG_DATA);
790:
791: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
792: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
793: 'gmo.plsql.GMO_DOCUMENT_NUMBERS_PVT.DOES_DOCUMENT_NUMBER_EXIST',
794: FALSE);
795: END IF;
796:
797: END DOES_DOCUMENT_NUMBER_EXIST;

Line 799: END GMO_DOCUMENT_NUMBERS_PVT;

795: END IF;
796:
797: END DOES_DOCUMENT_NUMBER_EXIST;
798:
799: END GMO_DOCUMENT_NUMBERS_PVT;