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_PVT dependencies on FND_API

Line 7: g_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_MISS_CHAR;

3:
4:
5: ----------------------- Global variables and constants -----------------------
6:
7: g_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_MISS_CHAR;
8: g_MISS_NUM CONSTANT NUMBER := fnd_api.g_MISS_NUM;
9: g_MISS_DATE CONSTANT DATE := fnd_api.g_MISS_DATE;
10: g_YES CONSTANT VARCHAR2(1) := 'Y';
11: g_NO CONSTANT VARCHAR2(1) := 'N';

Line 8: g_MISS_NUM CONSTANT NUMBER := fnd_api.g_MISS_NUM;

4:
5: ----------------------- Global variables and constants -----------------------
6:
7: g_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_MISS_CHAR;
8: g_MISS_NUM CONSTANT NUMBER := fnd_api.g_MISS_NUM;
9: g_MISS_DATE CONSTANT DATE := fnd_api.g_MISS_DATE;
10: g_YES CONSTANT VARCHAR2(1) := 'Y';
11: g_NO CONSTANT VARCHAR2(1) := 'N';
12:

Line 9: g_MISS_DATE CONSTANT DATE := fnd_api.g_MISS_DATE;

5: ----------------------- Global variables and constants -----------------------
6:
7: g_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_MISS_CHAR;
8: g_MISS_NUM CONSTANT NUMBER := fnd_api.g_MISS_NUM;
9: g_MISS_DATE CONSTANT DATE := fnd_api.g_MISS_DATE;
10: g_YES CONSTANT VARCHAR2(1) := 'Y';
11: g_NO CONSTANT VARCHAR2(1) := 'N';
12:
13: -- Validation level

Line 41: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

37:
38: PROCEDURE Create_Category_Assignment
39: (
40: p_api_version IN NUMBER
41: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
42: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
43: , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATEGORY_PVT.g_VALIDATE_ALL
44: , p_inventory_item_id IN NUMBER
45: , p_organization_id IN NUMBER

Line 42: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

38: PROCEDURE Create_Category_Assignment
39: (
40: p_api_version IN NUMBER
41: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
42: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
43: , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATEGORY_PVT.g_VALIDATE_ALL
44: , p_inventory_item_id IN NUMBER
45: , p_organization_id IN NUMBER
46: , p_category_set_id IN NUMBER

Line 61: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

57:
58: PROCEDURE Delete_Category_Assignment
59: (
60: p_api_version IN NUMBER
61: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
62: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
63: , p_inventory_item_id IN NUMBER
64: , p_organization_id IN NUMBER
65: , p_category_set_id IN NUMBER

Line 62: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

58: PROCEDURE Delete_Category_Assignment
59: (
60: p_api_version IN NUMBER
61: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
62: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
63: , p_inventory_item_id IN NUMBER
64: , p_organization_id IN NUMBER
65: , p_category_set_id IN NUMBER
66: , p_category_id IN NUMBER

Line 78: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

74: -- API to create a valid Category in Category Sets
75: -----------------------------------------------------------------------------
76: PROCEDURE Create_Valid_Category(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
80: p_category_set_id IN NUMBER,
81: p_category_id IN NUMBER,
82: p_parent_category_id IN NUMBER,

Line 79: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

75: -----------------------------------------------------------------------------
76: PROCEDURE Create_Valid_Category(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
80: p_category_set_id IN NUMBER,
81: p_category_id IN NUMBER,
82: p_parent_category_id IN NUMBER,
83: x_return_status OUT NOCOPY VARCHAR2,

Line 102: -- DEFAULT = FND_API.G_FALSE,

98: -- IN : p_api_version IN NUMBER (required)
99: -- API Version of this procedure
100: --
101: -- p_init_msg_level IN VARCHAR2 (optional)
102: -- DEFAULT = FND_API.G_FALSE,
103: --
104: -- p_commit IN VARCHAR2 (optional)
105: -- DEFAULT = FND_API.G_FALSE,
106: --

Line 105: -- DEFAULT = FND_API.G_FALSE,

101: -- p_init_msg_level IN VARCHAR2 (optional)
102: -- DEFAULT = FND_API.G_FALSE,
103: --
104: -- p_commit IN VARCHAR2 (optional)
105: -- DEFAULT = FND_API.G_FALSE,
106: --
107: -- p_category_set_id IN NUMBER (required)
108: -- category_set_id
109: --

Line 125: -- FND_API.G_RET_STS_SUCCESS if success

121: -- contains the message itself
122: --
123: -- X_return_status OUT NUMBER
124: -- Result of all the operations
125: -- FND_API.G_RET_STS_SUCCESS if success
126: -- FND_API.G_RET_STS_ERROR if error
127: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
128: --
129: -- X_ErrorCode OUT NUMBER

Line 126: -- FND_API.G_RET_STS_ERROR if error

122: --
123: -- X_return_status OUT NUMBER
124: -- Result of all the operations
125: -- FND_API.G_RET_STS_SUCCESS if success
126: -- FND_API.G_RET_STS_ERROR if error
127: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
128: --
129: -- X_ErrorCode OUT NUMBER
130: -- RETURN value OF the x_errorcode

Line 127: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

123: -- X_return_status OUT NUMBER
124: -- Result of all the operations
125: -- FND_API.G_RET_STS_SUCCESS if success
126: -- FND_API.G_RET_STS_ERROR if error
127: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
128: --
129: -- X_ErrorCode OUT NUMBER
130: -- RETURN value OF the x_errorcode
131: -- check only if x_return_status <> fnd_api.g_ret_sts_success

Line 131: -- check only if x_return_status <> fnd_api.g_ret_sts_success

127: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
128: --
129: -- X_ErrorCode OUT NUMBER
130: -- RETURN value OF the x_errorcode
131: -- check only if x_return_status <> fnd_api.g_ret_sts_success
132: -- These errors are unrecoverable and the API failed as a result of this
133: -- XXX - Error reason/message (will be updated after implementation)
134: -- -1 - unexpected error - all operations have been rollbacked
135: --

Line 148: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

144: -- API to update a valid Category in Category Sets
145: -----------------------------------------------------------------------------
146: PROCEDURE Update_Valid_Category(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
149: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
150: p_category_set_id IN NUMBER,
151: p_category_id IN NUMBER,
152: p_parent_category_id IN NUMBER,

Line 149: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

145: -----------------------------------------------------------------------------
146: PROCEDURE Update_Valid_Category(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
149: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
150: p_category_set_id IN NUMBER,
151: p_category_id IN NUMBER,
152: p_parent_category_id IN NUMBER,
153: x_return_status OUT NOCOPY VARCHAR2,

Line 172: -- DEFAULT = FND_API.G_FALSE,

168: -- IN : p_api_version IN NUMBER (required)
169: -- API Version of this procedure
170: --
171: -- p_init_msg_level IN VARCHAR2 (optional)
172: -- DEFAULT = FND_API.G_FALSE,
173: --
174: -- p_commit IN VARCHAR2 (optional)
175: -- DEFAULT = FND_API.G_FALSE,
176: --

Line 175: -- DEFAULT = FND_API.G_FALSE,

171: -- p_init_msg_level IN VARCHAR2 (optional)
172: -- DEFAULT = FND_API.G_FALSE,
173: --
174: -- p_commit IN VARCHAR2 (optional)
175: -- DEFAULT = FND_API.G_FALSE,
176: --
177: -- p_category_set_id IN NUMBER (required)
178: -- category_set_id
179: --

Line 194: -- FND_API.G_RET_STS_SUCCESS if success

190: -- contains the message itself
191: --
192: -- X_return_status OUT NUMBER
193: -- Result of all the operations
194: -- FND_API.G_RET_STS_SUCCESS if success
195: -- FND_API.G_RET_STS_ERROR if error
196: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
197: --
198: -- X_ErrorCode OUT NUMBER

Line 195: -- FND_API.G_RET_STS_ERROR if error

191: --
192: -- X_return_status OUT NUMBER
193: -- Result of all the operations
194: -- FND_API.G_RET_STS_SUCCESS if success
195: -- FND_API.G_RET_STS_ERROR if error
196: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
197: --
198: -- X_ErrorCode OUT NUMBER
199: -- RETURN value OF the x_errorcode

Line 196: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

192: -- X_return_status OUT NUMBER
193: -- Result of all the operations
194: -- FND_API.G_RET_STS_SUCCESS if success
195: -- FND_API.G_RET_STS_ERROR if error
196: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
197: --
198: -- X_ErrorCode OUT NUMBER
199: -- RETURN value OF the x_errorcode
200: -- check only if x_return_status <> fnd_api.g_ret_sts_success

Line 200: -- check only if x_return_status <> fnd_api.g_ret_sts_success

196: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
197: --
198: -- X_ErrorCode OUT NUMBER
199: -- RETURN value OF the x_errorcode
200: -- check only if x_return_status <> fnd_api.g_ret_sts_success
201: -- These errors are unrecoverable and the API failed as a result of this
202: -- XXX - Error reason/message (will be updated after implementation)
203: -- -1 - unexpected error - all operations have been rollbacked
204: --

Line 218: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

214:
215: PROCEDURE Update_Category_Assignment
216: (
217: p_api_version IN NUMBER
218: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
219: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
220: , p_inventory_item_id IN NUMBER
221: , p_organization_id IN NUMBER
222: , p_category_set_id IN NUMBER

Line 219: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

215: PROCEDURE Update_Category_Assignment
216: (
217: p_api_version IN NUMBER
218: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
219: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
220: , p_inventory_item_id IN NUMBER
221: , p_organization_id IN NUMBER
222: , p_category_set_id IN NUMBER
223: , p_category_id IN NUMBER