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.

APPS.INV_ITEM_CATEGORY_PUB dependencies on FND_API

Line 20: * Valid values are FND_API.G_TRUE and FND_API.G_FALSE.

16: *

p_init_msg_list: A one-character flag indicating whether
17: * to initialize the FND_MSG_PUB package's message stack at the
18: * beginning of API processing (and thus remove any messages that
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: *

p_commit: A one-character flag indicating whether to commit
22: * work at the end of API processing. Valid values are
23: * FND_API.G_TRUE and FND_API.G_FALSE.

24: *

x_return_status: A one-character code indicating whether

Line 23: * FND_API.G_TRUE and FND_API.G_FALSE.

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: *

p_commit: A one-character flag indicating whether to commit
22: * work at the end of API processing. Valid values are
23: * FND_API.G_TRUE and FND_API.G_FALSE.

24: *

x_return_status: A one-character code indicating whether
25: * any errors occurred during processing (in which case error
26: * messages will be present on the FND_MSG_PUB package's message
27: * stack). Valid values are FND_API.G_RET_STS_SUCCESS,

Line 27: * stack). Valid values are FND_API.G_RET_STS_SUCCESS,

23: * FND_API.G_TRUE and FND_API.G_FALSE.

24: *

x_return_status: A one-character code indicating whether
25: * any errors occurred during processing (in which case error
26: * messages will be present on the FND_MSG_PUB package's message
27: * stack). Valid values are FND_API.G_RET_STS_SUCCESS,
28: * FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.

29: *

x_msg_count: An integer indicating the number of messages
30: * on the FND_MSG_PUB package's message stack at the end of API
31: * processing. Refer to FND_MSG_PUB documentation for more

Line 28: * FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.

24: *

29: *

x_msg_count: An integer indicating the number of messages
30: * on the FND_MSG_PUB package's message stack at the end of API
31: * processing. Refer to FND_MSG_PUB documentation for more
32: * information about how to retrieve messages from the message

Line 60: g_MISS_CHAR VARCHAR2(1) := fnd_api.g_MISS_CHAR;

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';

Line 61: g_MISS_NUM NUMBER := fnd_api.g_MISS_NUM;

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

Line 62: g_MISS_DATE DATE := fnd_api.g_MISS_DATE;

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: -----------------------------------------------------------------------------

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 186: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 207: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 210: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 227: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 228: -- FND_API.G_RET_STS_ERROR if error

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

Line 229: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 309: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 310: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 330: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 333: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 347: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 348: -- FND_API.G_RET_STS_ERROR if error

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

Line 349: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 385: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 386: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 409: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 412: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 429: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 430: -- FND_API.G_RET_STS_ERROR if error

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

Line 431: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 461: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 462: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 482: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 485: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 499: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 500: -- FND_API.G_RET_STS_ERROR if error

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

Line 501: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 534: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 535: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 558: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 561: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 585: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 586: -- FND_API.G_RET_STS_ERROR if error

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

Line 587: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 620: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 621: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 644: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 647: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 670: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 671: -- FND_API.G_RET_STS_ERROR if error

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

Line 672: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 720: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 721: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 743: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 746: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 766: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 767: -- FND_API.G_RET_STS_ERROR if error

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

Line 768: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 798: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 799: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 823: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 826: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 846: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 847: -- FND_API.G_RET_STS_ERROR if error

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

Line 848: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 877: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 878: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 898: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 901: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 918: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 919: -- FND_API.G_RET_STS_ERROR if error

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

Line 920: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 970: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 971: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 995: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 998: -- DEFAULT = FND_API.G_FALSE,

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: --

Line 1024: -- FND_API.G_RET_STS_SUCCESS if success

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

Line 1025: -- FND_API.G_RET_STS_ERROR if error

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

Line 1026: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

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

Line 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: --

Line 1046: --when x_return_status return FND_API.G_RET_STS_SUCCESS,

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

Line 1049: --when x_return_status return FND_API.G_RET_STS_UNEXP_ERROR Or G_RET_STS_ERROR

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,