16: *
19: * may exist on the stack from prior processing in the same session).
20: * Valid values are FND_API.G_TRUE and FND_API.G_FALSE.
21: *
23: * FND_API.G_TRUE and FND_API.G_FALSE.
24: *
56: */
57:
58: -- Global variables and constants
59: ----------------------------------------------------------------------------
60: g_MISS_CHAR VARCHAR2(1) := fnd_api.g_MISS_CHAR;
61: g_MISS_NUM NUMBER := fnd_api.g_MISS_NUM;
62: g_MISS_DATE DATE := fnd_api.g_MISS_DATE;
63: g_YES VARCHAR2(1) := 'Y';
64: g_NO VARCHAR2(1) := 'N';
57:
58: -- Global variables and constants
59: ----------------------------------------------------------------------------
60: g_MISS_CHAR VARCHAR2(1) := fnd_api.g_MISS_CHAR;
61: g_MISS_NUM NUMBER := fnd_api.g_MISS_NUM;
62: g_MISS_DATE DATE := fnd_api.g_MISS_DATE;
63: g_YES VARCHAR2(1) := 'Y';
64: g_NO VARCHAR2(1) := 'N';
65: g_eni_upgarde_flag VARCHAR2(1) := 'N'; -- This is set by PVT pkg ONLY for ENI 11.5.10
58: -- Global variables and constants
59: ----------------------------------------------------------------------------
60: g_MISS_CHAR VARCHAR2(1) := fnd_api.g_MISS_CHAR;
61: g_MISS_NUM NUMBER := fnd_api.g_MISS_NUM;
62: g_MISS_DATE DATE := fnd_api.g_MISS_DATE;
63: g_YES VARCHAR2(1) := 'Y';
64: g_NO VARCHAR2(1) := 'N';
65: g_eni_upgarde_flag VARCHAR2(1) := 'N'; -- This is set by PVT pkg ONLY for ENI 11.5.10
66: -----------------------------------------------------------------------------
181:
182: PROCEDURE Create_Category
183: (
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_errorcode OUT NOCOPY NUMBER,
189: x_msg_count OUT NOCOPY NUMBER,
182: PROCEDURE Create_Category
183: (
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_errorcode OUT NOCOPY NUMBER,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
203: -- IN : p_api_version IN NUMBER (required)
204: -- API Version of this procedure
205: --
206: -- p_init_msg_level IN VARCHAR2 (optional)
207: -- DEFAULT = FND_API.G_FALSE,
208: --
209: -- p_commit IN VARCHAR2 (optional)
210: -- DEFAULT = FND_API.G_FALSE,
211: --
206: -- p_init_msg_level IN VARCHAR2 (optional)
207: -- DEFAULT = FND_API.G_FALSE,
208: --
209: -- p_commit IN VARCHAR2 (optional)
210: -- DEFAULT = FND_API.G_FALSE,
211: --
212: -- p_category_rec IN MTL_CATEGORIES (required)
213: -- complete interface RECORD
214: --
223: -- returns category id of record processed
224: --
225: -- X_return_status OUT NUMBER
226: -- Result of all the operations
227: -- FND_API.G_RET_STS_SUCCESS if success
228: -- FND_API.G_RET_STS_ERROR if error
229: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
230: --
231: -- X_ErrorCode OUT NUMBER
224: --
225: -- X_return_status OUT NUMBER
226: -- Result of all the operations
227: -- FND_API.G_RET_STS_SUCCESS if success
228: -- FND_API.G_RET_STS_ERROR if error
229: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
230: --
231: -- X_ErrorCode OUT NUMBER
232: -- RETURN value OF the x_errorcode
225: -- X_return_status OUT NUMBER
226: -- Result of all the operations
227: -- FND_API.G_RET_STS_SUCCESS if success
228: -- FND_API.G_RET_STS_ERROR if error
229: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
230: --
231: -- X_ErrorCode OUT NUMBER
232: -- RETURN value OF the x_errorcode
233: -- check only if x_return_status <> fnd_api.g_ret_sts_success
229: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
230: --
231: -- X_ErrorCode OUT NUMBER
232: -- RETURN value OF the x_errorcode
233: -- check only if x_return_status <> fnd_api.g_ret_sts_success
234: -- These errors are unrecoverable and the API failed as a result of this
235: -- XXX - Error reason/message (will be updated after implementation)
236: -- -1 - unexpected error - all operations have been rollbacked
237: --
305:
306: PROCEDURE Update_Category
307: (
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
310: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_errorcode OUT NOCOPY NUMBER,
313: x_msg_count OUT NOCOPY NUMBER,
306: PROCEDURE Update_Category
307: (
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
310: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_errorcode OUT NOCOPY NUMBER,
313: x_msg_count OUT NOCOPY NUMBER,
314: x_msg_data OUT NOCOPY VARCHAR2,
326: -- IN : p_api_version IN NUMBER (required)
327: -- API Version of this procedure
328: --
329: -- p_init_msg_level IN VARCHAR2 (optional)
330: -- DEFAULT = FND_API.G_FALSE,
331: --
332: -- p_commit IN VARCHAR2 (optional)
333: -- DEFAULT = FND_API.G_FALSE,
334: --
329: -- p_init_msg_level IN VARCHAR2 (optional)
330: -- DEFAULT = FND_API.G_FALSE,
331: --
332: -- p_commit IN VARCHAR2 (optional)
333: -- DEFAULT = FND_API.G_FALSE,
334: --
335: -- p_category_rec IN MTL_CATEGORIES (required)
336: -- new category attribute values
337: --
343: -- contains the message itself
344: --
345: -- X_return_status OUT NUMBER
346: -- Result of all the operations
347: -- FND_API.G_RET_STS_SUCCESS if success
348: -- FND_API.G_RET_STS_ERROR if error
349: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
350: --
351: -- X_ErrorCode OUT NUMBER
344: --
345: -- X_return_status OUT NUMBER
346: -- Result of all the operations
347: -- FND_API.G_RET_STS_SUCCESS if success
348: -- FND_API.G_RET_STS_ERROR if error
349: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
350: --
351: -- X_ErrorCode OUT NUMBER
352: -- RETURN value OF the x_errorcode
345: -- X_return_status OUT NUMBER
346: -- Result of all the operations
347: -- FND_API.G_RET_STS_SUCCESS if success
348: -- FND_API.G_RET_STS_ERROR if error
349: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
350: --
351: -- X_ErrorCode OUT NUMBER
352: -- RETURN value OF the x_errorcode
353: -- check only if x_return_status <> fnd_api.g_ret_sts_success
349: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
350: --
351: -- X_ErrorCode OUT NUMBER
352: -- RETURN value OF the x_errorcode
353: -- check only if x_return_status <> fnd_api.g_ret_sts_success
354: -- These errors are unrecoverable and the API failed as a result of this
355: -- XXX - Error reason/message (will be updated after implementation)
356: -- -1 - unexpected error - all operations have been rollbacked
357: --
381:
382: PROCEDURE Update_Category_Description
383: (
384: p_api_version IN NUMBER,
385: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
386: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_errorcode OUT NOCOPY NUMBER,
389: x_msg_count OUT NOCOPY NUMBER,
382: PROCEDURE Update_Category_Description
383: (
384: p_api_version IN NUMBER,
385: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
386: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_errorcode OUT NOCOPY NUMBER,
389: x_msg_count OUT NOCOPY NUMBER,
390: x_msg_data OUT NOCOPY VARCHAR2,
405: -- IN : p_api_version IN NUMBER (required)
406: -- API Version of this procedure
407: --
408: -- p_init_msg_level IN VARCHAR2 (optional)
409: -- DEFAULT = FND_API.G_FALSE,
410: --
411: -- p_commit IN VARCHAR2 (optional)
412: -- DEFAULT = FND_API.G_FALSE,
413: --
408: -- p_init_msg_level IN VARCHAR2 (optional)
409: -- DEFAULT = FND_API.G_FALSE,
410: --
411: -- p_commit IN VARCHAR2 (optional)
412: -- DEFAULT = FND_API.G_FALSE,
413: --
414: -- p_description IN VARCHAR2 (required)
415: -- new category description
416: --
425: -- contains the message itself
426: --
427: -- X_return_status OUT NUMBER
428: -- Result of all the operations
429: -- FND_API.G_RET_STS_SUCCESS if success
430: -- FND_API.G_RET_STS_ERROR if error
431: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
432: --
433: -- X_ErrorCode OUT NUMBER
426: --
427: -- X_return_status OUT NUMBER
428: -- Result of all the operations
429: -- FND_API.G_RET_STS_SUCCESS if success
430: -- FND_API.G_RET_STS_ERROR if error
431: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
432: --
433: -- X_ErrorCode OUT NUMBER
434: -- RETURN value OF the x_errorcode
427: -- X_return_status OUT NUMBER
428: -- Result of all the operations
429: -- FND_API.G_RET_STS_SUCCESS if success
430: -- FND_API.G_RET_STS_ERROR if error
431: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
432: --
433: -- X_ErrorCode OUT NUMBER
434: -- RETURN value OF the x_errorcode
435: -- check only if x_return_status <> fnd_api.g_ret_sts_success
431: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
432: --
433: -- X_ErrorCode OUT NUMBER
434: -- RETURN value OF the x_errorcode
435: -- check only if x_return_status <> fnd_api.g_ret_sts_success
436: -- These errors are unrecoverable and the API failed as a result of this
437: -- XXX - Error reason/message (will be updated after implementation)
438: -- -1 - unexpected error - all operations have been rollbacked
439: --
457:
458: PROCEDURE Delete_Category
459: (
460: p_api_version IN NUMBER,
461: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_errorcode OUT NOCOPY NUMBER,
465: x_msg_count OUT NOCOPY NUMBER,
458: PROCEDURE Delete_Category
459: (
460: p_api_version IN NUMBER,
461: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_errorcode OUT NOCOPY NUMBER,
465: x_msg_count OUT NOCOPY NUMBER,
466: x_msg_data OUT NOCOPY VARCHAR2,
478: -- IN : p_api_version IN NUMBER (required)
479: -- API Version of this procedure
480: --
481: -- p_init_msg_level IN VARCHAR2 (optional)
482: -- DEFAULT = FND_API.G_FALSE,
483: --
484: -- p_commit IN VARCHAR2 (optional)
485: -- DEFAULT = FND_API.G_FALSE,
486: --
481: -- p_init_msg_level IN VARCHAR2 (optional)
482: -- DEFAULT = FND_API.G_FALSE,
483: --
484: -- p_commit IN VARCHAR2 (optional)
485: -- DEFAULT = FND_API.G_FALSE,
486: --
487: -- p_category_id IN NUMBER (required)
488: -- category to delete
489: --
495: -- contains the message itself
496: --
497: -- X_return_status OUT NUMBER
498: -- Result of all the operations
499: -- FND_API.G_RET_STS_SUCCESS if success
500: -- FND_API.G_RET_STS_ERROR if error
501: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
502: --
503: -- X_ErrorCode OUT NUMBER
496: --
497: -- X_return_status OUT NUMBER
498: -- Result of all the operations
499: -- FND_API.G_RET_STS_SUCCESS if success
500: -- FND_API.G_RET_STS_ERROR if error
501: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
502: --
503: -- X_ErrorCode OUT NUMBER
504: -- RETURN value OF the x_errorcode
497: -- X_return_status OUT NUMBER
498: -- Result of all the operations
499: -- FND_API.G_RET_STS_SUCCESS if success
500: -- FND_API.G_RET_STS_ERROR if error
501: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
502: --
503: -- X_ErrorCode OUT NUMBER
504: -- RETURN value OF the x_errorcode
505: -- check only if x_return_status <> fnd_api.g_ret_sts_success
501: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
502: --
503: -- X_ErrorCode OUT NUMBER
504: -- RETURN value OF the x_errorcode
505: -- check only if x_return_status <> fnd_api.g_ret_sts_success
506: -- These errors are unrecoverable and the API failed as a result of this
507: -- XXX - Error reason/message (will be updated after implementation)
508: -- -1 - unexpected error - all operations have been rollbacked
509: --
530: */
531: PROCEDURE Create_Category_Assignment
532: (
533: p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
535: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
536: x_return_status OUT NOCOPY VARCHAR2,
537: x_errorcode OUT NOCOPY NUMBER,
538: x_msg_count OUT NOCOPY NUMBER,
531: PROCEDURE Create_Category_Assignment
532: (
533: p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
535: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
536: x_return_status OUT NOCOPY VARCHAR2,
537: x_errorcode OUT NOCOPY NUMBER,
538: x_msg_count OUT NOCOPY NUMBER,
539: x_msg_data OUT NOCOPY VARCHAR2,
554: -- IN : p_api_version IN NUMBER (required)
555: -- API Version of this procedure
556: --
557: -- p_init_msg_level IN VARCHAR2 (optional)
558: -- DEFAULT = FND_API.G_FALSE,
559: --
560: -- p_commit IN VARCHAR2 (optional)
561: -- DEFAULT = FND_API.G_FALSE,
562: --
557: -- p_init_msg_level IN VARCHAR2 (optional)
558: -- DEFAULT = FND_API.G_FALSE,
559: --
560: -- p_commit IN VARCHAR2 (optional)
561: -- DEFAULT = FND_API.G_FALSE,
562: --
563: -- p_category_id IN NUMBER (required)
564: -- category for assigning item
565: --
581: -- contains the message itself
582: --
583: -- X_return_status OUT NUMBER
584: -- Result of all the operations
585: -- FND_API.G_RET_STS_SUCCESS if success
586: -- FND_API.G_RET_STS_ERROR if error
587: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
588: --
589: -- X_ErrorCode OUT NUMBER
582: --
583: -- X_return_status OUT NUMBER
584: -- Result of all the operations
585: -- FND_API.G_RET_STS_SUCCESS if success
586: -- FND_API.G_RET_STS_ERROR if error
587: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
588: --
589: -- X_ErrorCode OUT NUMBER
590: -- RETURN value OF the x_errorcode
583: -- X_return_status OUT NUMBER
584: -- Result of all the operations
585: -- FND_API.G_RET_STS_SUCCESS if success
586: -- FND_API.G_RET_STS_ERROR if error
587: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
588: --
589: -- X_ErrorCode OUT NUMBER
590: -- RETURN value OF the x_errorcode
591: -- check only if x_return_status <> fnd_api.g_ret_sts_success
587: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
588: --
589: -- X_ErrorCode OUT NUMBER
590: -- RETURN value OF the x_errorcode
591: -- check only if x_return_status <> fnd_api.g_ret_sts_success
592: -- These errors are unrecoverable and the API failed as a result of this
593: -- XXX - Error reason/message (will be updated after implementation)
594: -- -1 - unexpected error - all operations have been rollbacked
595: --
616: */
617: PROCEDURE Delete_Category_Assignment
618: (
619: p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
622: x_return_status OUT NOCOPY VARCHAR2,
623: x_errorcode OUT NOCOPY NUMBER,
624: x_msg_count OUT NOCOPY NUMBER,
617: PROCEDURE Delete_Category_Assignment
618: (
619: p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
622: x_return_status OUT NOCOPY VARCHAR2,
623: x_errorcode OUT NOCOPY NUMBER,
624: x_msg_count OUT NOCOPY NUMBER,
625: x_msg_data OUT NOCOPY VARCHAR2,
640: -- IN : p_api_version IN NUMBER (required)
641: -- API Version of this procedure
642: --
643: -- p_init_msg_level IN VARCHAR2 (optional)
644: -- DEFAULT = FND_API.G_FALSE,
645: --
646: -- p_commit IN VARCHAR2 (optional)
647: -- DEFAULT = FND_API.G_FALSE,
648: --
643: -- p_init_msg_level IN VARCHAR2 (optional)
644: -- DEFAULT = FND_API.G_FALSE,
645: --
646: -- p_commit IN VARCHAR2 (optional)
647: -- DEFAULT = FND_API.G_FALSE,
648: --
649: -- p_category_id IN NUMBER (required)
650: -- category of the assginement
651: --
666: -- contains the message itself
667: --
668: -- X_return_status OUT NUMBER
669: -- Result of all the operations
670: -- FND_API.G_RET_STS_SUCCESS if success
671: -- FND_API.G_RET_STS_ERROR if error
672: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
673: --
674: -- X_ErrorCode OUT NUMBER
667: --
668: -- X_return_status OUT NUMBER
669: -- Result of all the operations
670: -- FND_API.G_RET_STS_SUCCESS if success
671: -- FND_API.G_RET_STS_ERROR if error
672: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
673: --
674: -- X_ErrorCode OUT NUMBER
675: -- RETURN value OF the x_errorcode
668: -- X_return_status OUT NUMBER
669: -- Result of all the operations
670: -- FND_API.G_RET_STS_SUCCESS if success
671: -- FND_API.G_RET_STS_ERROR if error
672: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
673: --
674: -- X_ErrorCode OUT NUMBER
675: -- RETURN value OF the x_errorcode
676: -- check only if x_return_status <> fnd_api.g_ret_sts_success
672: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
673: --
674: -- X_ErrorCode OUT NUMBER
675: -- RETURN value OF the x_errorcode
676: -- check only if x_return_status <> fnd_api.g_ret_sts_success
677: -- These errors are unrecoverable and the API failed as a result of this
678: -- XXX - Error reason/message (will be updated after implementation)
679: -- -1 - unexpected error - all operations have been rollbacked
680: --
716: * @rep:scope public
717: */
718: PROCEDURE Create_Valid_Category(
719: p_api_version IN NUMBER,
720: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
721: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
722: p_category_set_id IN NUMBER,
723: p_category_id IN NUMBER,
724: p_parent_category_id IN NUMBER,
717: */
718: PROCEDURE Create_Valid_Category(
719: p_api_version IN NUMBER,
720: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
721: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
722: p_category_set_id IN NUMBER,
723: p_category_id IN NUMBER,
724: p_parent_category_id IN NUMBER,
725: x_return_status OUT NOCOPY VARCHAR2,
739: -- IN : p_api_version IN NUMBER (required)
740: -- API Version of this procedure
741: --
742: -- p_init_msg_level IN VARCHAR2 (optional)
743: -- DEFAULT = FND_API.G_FALSE,
744: --
745: -- p_commit IN VARCHAR2 (optional)
746: -- DEFAULT = FND_API.G_FALSE,
747: --
742: -- p_init_msg_level IN VARCHAR2 (optional)
743: -- DEFAULT = FND_API.G_FALSE,
744: --
745: -- p_commit IN VARCHAR2 (optional)
746: -- DEFAULT = FND_API.G_FALSE,
747: --
748: -- p_category_set_id IN NUMBER (required)
749: -- category_set_id
750: --
762: -- contains the message itself
763: --
764: -- X_return_status OUT NUMBER
765: -- Result of all the operations
766: -- FND_API.G_RET_STS_SUCCESS if success
767: -- FND_API.G_RET_STS_ERROR if error
768: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
769: --
770: -- X_ErrorCode OUT NUMBER
763: --
764: -- X_return_status OUT NUMBER
765: -- Result of all the operations
766: -- FND_API.G_RET_STS_SUCCESS if success
767: -- FND_API.G_RET_STS_ERROR if error
768: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
769: --
770: -- X_ErrorCode OUT NUMBER
771: -- RETURN value OF the x_errorcode
764: -- X_return_status OUT NUMBER
765: -- Result of all the operations
766: -- FND_API.G_RET_STS_SUCCESS if success
767: -- FND_API.G_RET_STS_ERROR if error
768: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
769: --
770: -- X_ErrorCode OUT NUMBER
771: -- RETURN value OF the x_errorcode
772: -- check only if x_return_status <> fnd_api.g_ret_sts_success
768: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
769: --
770: -- X_ErrorCode OUT NUMBER
771: -- RETURN value OF the x_errorcode
772: -- check only if x_return_status <> fnd_api.g_ret_sts_success
773: -- These errors are unrecoverable and the API failed as a result of this
774: -- XXX - Error reason/message (will be updated after implementation)
775: -- -1 - unexpected error - all operations have been rollbacked
776: --
794: * @rep:scope public
795: */
796: PROCEDURE Update_Valid_Category(
797: p_api_version IN NUMBER,
798: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
799: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
800: p_category_set_id IN NUMBER,
801: p_category_id IN NUMBER,
802: p_parent_category_id IN NUMBER,
795: */
796: PROCEDURE Update_Valid_Category(
797: p_api_version IN NUMBER,
798: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
799: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
800: p_category_set_id IN NUMBER,
801: p_category_id IN NUMBER,
802: p_parent_category_id IN NUMBER,
803: x_return_status OUT NOCOPY VARCHAR2,
819: -- IN : p_api_version IN NUMBER (required)
820: -- API Version of this procedure
821: --
822: -- p_init_msg_level IN VARCHAR2 (optional)
823: -- DEFAULT = FND_API.G_FALSE,
824: --
825: -- p_commit IN VARCHAR2 (optional)
826: -- DEFAULT = FND_API.G_FALSE,
827: --
822: -- p_init_msg_level IN VARCHAR2 (optional)
823: -- DEFAULT = FND_API.G_FALSE,
824: --
825: -- p_commit IN VARCHAR2 (optional)
826: -- DEFAULT = FND_API.G_FALSE,
827: --
828: -- p_category_set_id IN NUMBER (required)
829: -- category_set_id
830: --
842: -- contains the message itself
843: --
844: -- X_return_status OUT NUMBER
845: -- Result of all the operations
846: -- FND_API.G_RET_STS_SUCCESS if success
847: -- FND_API.G_RET_STS_ERROR if error
848: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
849: --
850: -- X_ErrorCode OUT NUMBER
843: --
844: -- X_return_status OUT NUMBER
845: -- Result of all the operations
846: -- FND_API.G_RET_STS_SUCCESS if success
847: -- FND_API.G_RET_STS_ERROR if error
848: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
849: --
850: -- X_ErrorCode OUT NUMBER
851: -- RETURN value OF the x_errorcode
844: -- X_return_status OUT NUMBER
845: -- Result of all the operations
846: -- FND_API.G_RET_STS_SUCCESS if success
847: -- FND_API.G_RET_STS_ERROR if error
848: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
849: --
850: -- X_ErrorCode OUT NUMBER
851: -- RETURN value OF the x_errorcode
852: -- check only if x_return_status <> fnd_api.g_ret_sts_success
848: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
849: --
850: -- X_ErrorCode OUT NUMBER
851: -- RETURN value OF the x_errorcode
852: -- check only if x_return_status <> fnd_api.g_ret_sts_success
853: -- These errors are unrecoverable and the API failed as a result of this
854: -- XXX - Error reason/message (will be updated after implementation)
855: -- -1 - unexpected error - all operations have been rollbacked
856: --
873: * @rep:scope public
874: */
875: PROCEDURE Delete_Valid_Category(
876: p_api_version IN NUMBER,
877: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
878: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
879: p_category_set_id IN NUMBER,
880: p_category_id IN NUMBER,
881: x_return_status OUT NOCOPY VARCHAR2,
874: */
875: PROCEDURE Delete_Valid_Category(
876: p_api_version IN NUMBER,
877: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
878: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
879: p_category_set_id IN NUMBER,
880: p_category_id IN NUMBER,
881: x_return_status OUT NOCOPY VARCHAR2,
882: x_errorcode OUT NOCOPY NUMBER,
894: -- IN : p_api_version IN NUMBER (required)
895: -- API Version of this procedure
896: --
897: -- p_init_msg_level IN VARCHAR2 (optional)
898: -- DEFAULT = FND_API.G_FALSE,
899: --
900: -- p_commit IN VARCHAR2 (optional)
901: -- DEFAULT = FND_API.G_FALSE,
902: --
897: -- p_init_msg_level IN VARCHAR2 (optional)
898: -- DEFAULT = FND_API.G_FALSE,
899: --
900: -- p_commit IN VARCHAR2 (optional)
901: -- DEFAULT = FND_API.G_FALSE,
902: --
903: -- p_category_set_id IN NUMBER (required)
904: -- category_set_id
905: --
914: -- contains the message itself
915: --
916: -- X_return_status OUT NUMBER
917: -- Result of all the operations
918: -- FND_API.G_RET_STS_SUCCESS if success
919: -- FND_API.G_RET_STS_ERROR if error
920: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
921: --
922: -- X_ErrorCode OUT NUMBER
915: --
916: -- X_return_status OUT NUMBER
917: -- Result of all the operations
918: -- FND_API.G_RET_STS_SUCCESS if success
919: -- FND_API.G_RET_STS_ERROR if error
920: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
921: --
922: -- X_ErrorCode OUT NUMBER
923: -- RETURN value OF the x_errorcode
916: -- X_return_status OUT NUMBER
917: -- Result of all the operations
918: -- FND_API.G_RET_STS_SUCCESS if success
919: -- FND_API.G_RET_STS_ERROR if error
920: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
921: --
922: -- X_ErrorCode OUT NUMBER
923: -- RETURN value OF the x_errorcode
924: -- check only if x_return_status <> fnd_api.g_ret_sts_success
920: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
921: --
922: -- X_ErrorCode OUT NUMBER
923: -- RETURN value OF the x_errorcode
924: -- check only if x_return_status <> fnd_api.g_ret_sts_success
925: -- These errors are unrecoverable and the API failed as a result of this
926: -- XXX - Error reason/message (will be updated after implementation)
927: -- -1 - unexpected error - all operations have been rollbacked
928: --
966: */
967: PROCEDURE Update_Category_Assignment
968: (
969: p_api_version IN NUMBER,
970: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
971: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
972: p_category_id IN NUMBER,
973: p_old_category_id IN NUMBER,
974: p_category_set_id IN NUMBER,
967: PROCEDURE Update_Category_Assignment
968: (
969: p_api_version IN NUMBER,
970: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
971: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
972: p_category_id IN NUMBER,
973: p_old_category_id IN NUMBER,
974: p_category_set_id IN NUMBER,
975: p_inventory_item_id IN NUMBER,
991: -- IN : p_api_version IN NUMBER (required)
992: -- API Version of this procedure
993: --
994: -- p_init_msg_level IN VARCHAR2 (optional)
995: -- DEFAULT = FND_API.G_FALSE,
996: --
997: -- p_commit IN VARCHAR2 (optional)
998: -- DEFAULT = FND_API.G_FALSE,
999: --
994: -- p_init_msg_level IN VARCHAR2 (optional)
995: -- DEFAULT = FND_API.G_FALSE,
996: --
997: -- p_commit IN VARCHAR2 (optional)
998: -- DEFAULT = FND_API.G_FALSE,
999: --
1000: -- p_category_id IN NUMBER (required)
1001: -- new category to be updated
1002: --
1020: -- contains the message itself
1021: --
1022: -- X_return_status OUT NUMBER
1023: -- Result of all the operations
1024: -- FND_API.G_RET_STS_SUCCESS if success
1025: -- FND_API.G_RET_STS_ERROR if error
1026: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
1027: --
1028: -- X_ErrorCode OUT NUMBER
1021: --
1022: -- X_return_status OUT NUMBER
1023: -- Result of all the operations
1024: -- FND_API.G_RET_STS_SUCCESS if success
1025: -- FND_API.G_RET_STS_ERROR if error
1026: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
1027: --
1028: -- X_ErrorCode OUT NUMBER
1029: -- RETURN value OF the x_errorcode
1022: -- X_return_status OUT NUMBER
1023: -- Result of all the operations
1024: -- FND_API.G_RET_STS_SUCCESS if success
1025: -- FND_API.G_RET_STS_ERROR if error
1026: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
1027: --
1028: -- X_ErrorCode OUT NUMBER
1029: -- RETURN value OF the x_errorcode
1030: -- check only if x_return_status <> fnd_api.g_ret_sts_success
1026: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
1027: --
1028: -- X_ErrorCode OUT NUMBER
1029: -- RETURN value OF the x_errorcode
1030: -- check only if x_return_status <> fnd_api.g_ret_sts_success
1031: -- These errors are unrecoverable and the API failed as a result of this
1032: -- XXX - Error reason/message (will be updated after implementation)
1033: -- -1 - unexpected error - all operations have been rollbacked
1034: --
1042: --* End of Bug #3991044
1043:
1044: /* Add this procedure by geguo for bug 8547305 */
1045: ----------------------------------------------------------------------------------------------------------
1046: --when x_return_status return FND_API.G_RET_STS_SUCCESS,
1047: -- x_category_id return the category id if the segment combination existed.
1048: -- Or x_category_id return -1 if the combination doesn't exist.
1049: --when x_return_status return FND_API.G_RET_STS_UNEXP_ERROR Or G_RET_STS_ERROR
1050: -- indicating error happened, get the error message from x_msg_data
1045: ----------------------------------------------------------------------------------------------------------
1046: --when x_return_status return FND_API.G_RET_STS_SUCCESS,
1047: -- x_category_id return the category id if the segment combination existed.
1048: -- Or x_category_id return -1 if the combination doesn't exist.
1049: --when x_return_status return FND_API.G_RET_STS_UNEXP_ERROR Or G_RET_STS_ERROR
1050: -- indicating error happened, get the error message from x_msg_data
1051: ----------------------------------------------------------------------------------------------------------
1052: PROCEDURE Get_Category_Id_From_Cat_Rec(
1053: p_category_rec IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE,