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.AMV_CATEGORY_PVT dependencies on FND_API

Line 27: p_category_id IN NUMBER := FND_API.G_MISS_NUM,

23: --------------------------------------------------------------------------------
24: PROCEDURE Validate_CategoryStatus
25: (
26: x_return_status OUT NOCOPY VARCHAR2,
27: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: x_exist_flag OUT NOCOPY VARCHAR2,

Line 28: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

24: PROCEDURE Validate_CategoryStatus
25: (
26: x_return_status OUT NOCOPY VARCHAR2,
27: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: x_exist_flag OUT NOCOPY VARCHAR2,
32: x_category_id OUT NOCOPY NUMBER,

Line 29: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

25: (
26: x_return_status OUT NOCOPY VARCHAR2,
27: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: x_exist_flag OUT NOCOPY VARCHAR2,
32: x_category_id OUT NOCOPY NUMBER,
33: x_error_msg OUT NOCOPY VARCHAR2,

Line 30: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

26: x_return_status OUT NOCOPY VARCHAR2,
27: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: x_exist_flag OUT NOCOPY VARCHAR2,
32: x_category_id OUT NOCOPY NUMBER,
33: x_error_msg OUT NOCOPY VARCHAR2,
34: x_error_token OUT NOCOPY VARCHAR2

Line 40: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM

36: --
37: FUNCTION Get_CategoryId
38: (
39: p_category_name IN VARCHAR2,
40: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
41: ) RETURN NUMBER;
42: --
43: FUNCTION Get_CategoryName
44: (

Line 72: -- category id. Default = FND_API.G_MISS_NUM

68: -- Function : check if category (p_category_id/p_category_name) exist
69: -- return the category id if existing.
70: -- Parameters :
71: -- p_category_id IN NUMBER Optional
72: -- category id. Default = FND_API.G_MISS_NUM
73: -- p_category_name IN VARCHAR2 Optional
74: -- category name. Default = FND_API.G_MISS_CHAR
75: -- Either pass the category id (preferred) or category name
76: -- to identify the category.

Line 74: -- category name. Default = FND_API.G_MISS_CHAR

70: -- Parameters :
71: -- p_category_id IN NUMBER Optional
72: -- category id. Default = FND_API.G_MISS_NUM
73: -- p_category_name IN VARCHAR2 Optional
74: -- category name. Default = FND_API.G_MISS_CHAR
75: -- Either pass the category id (preferred) or category name
76: -- to identify the category.
77: -- p_parent_category_id IN NUMBER Optional
78: -- parent category id. Default = FND_API.G_MISS_NUM

Line 78: -- parent category id. Default = FND_API.G_MISS_NUM

74: -- category name. Default = FND_API.G_MISS_CHAR
75: -- Either pass the category id (preferred) or category name
76: -- to identify the category.
77: -- p_parent_category_id IN NUMBER Optional
78: -- parent category id. Default = FND_API.G_MISS_NUM
79: -- p_parent_category_name IN VARCHAR2 Optional
80: -- parent category name. Default = FND_API.G_MISS_CHAR
81: -- Pass parent category id or name along with category name
82: -- to identify sub category

Line 80: -- parent category name. Default = FND_API.G_MISS_CHAR

76: -- to identify the category.
77: -- p_parent_category_id IN NUMBER Optional
78: -- parent category id. Default = FND_API.G_MISS_NUM
79: -- p_parent_category_name IN VARCHAR2 Optional
80: -- parent category name. Default = FND_API.G_MISS_CHAR
81: -- Pass parent category id or name along with category name
82: -- to identify sub category
83: -- OUT : x_return_status OUT VARCHAR2
84: -- x_exist_flag OUT VARCHAR2

Line 101: p_category_id IN NUMBER := FND_API.G_MISS_NUM,

97: --
98: PROCEDURE Validate_CategoryStatus
99: (
100: x_return_status OUT NOCOPY VARCHAR2,
101: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
104: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: x_exist_flag OUT NOCOPY VARCHAR2,

Line 102: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

98: PROCEDURE Validate_CategoryStatus
99: (
100: x_return_status OUT NOCOPY VARCHAR2,
101: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
104: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: x_exist_flag OUT NOCOPY VARCHAR2,
106: x_category_id OUT NOCOPY NUMBER,

Line 103: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

99: (
100: x_return_status OUT NOCOPY VARCHAR2,
101: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
104: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: x_exist_flag OUT NOCOPY VARCHAR2,
106: x_category_id OUT NOCOPY NUMBER,
107: x_error_msg OUT NOCOPY VARCHAR2,

Line 104: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

100: x_return_status OUT NOCOPY VARCHAR2,
101: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
102: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
104: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: x_exist_flag OUT NOCOPY VARCHAR2,
106: x_category_id OUT NOCOPY NUMBER,
107: x_error_msg OUT NOCOPY VARCHAR2,
108: x_error_token OUT NOCOPY VARCHAR2) IS

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: l_category_id number;
111: --
112: BEGIN
113: IF (p_category_id IS NULL OR p_category_name IS NULL) THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: --
117: IF p_category_id <> FND_API.G_MISS_NUM THEN
118: IF p_category_name <> FND_API.G_MISS_CHAR THEN

Line 117: IF p_category_id <> FND_API.G_MISS_NUM THEN

113: IF (p_category_id IS NULL OR p_category_name IS NULL) THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: --
117: IF p_category_id <> FND_API.G_MISS_NUM THEN
118: IF p_category_name <> FND_API.G_MISS_CHAR THEN
119: -- passed both id and name. id taken by default.
120: x_error_msg:='AMV_CAT_ID_AND_NAME_PASSED';
121: END IF;

Line 118: IF p_category_name <> FND_API.G_MISS_CHAR THEN

114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116: --
117: IF p_category_id <> FND_API.G_MISS_NUM THEN
118: IF p_category_name <> FND_API.G_MISS_CHAR THEN
119: -- passed both id and name. id taken by default.
120: x_error_msg:='AMV_CAT_ID_AND_NAME_PASSED';
121: END IF;
122: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 122: x_return_status := FND_API.G_RET_STS_SUCCESS;

118: IF p_category_name <> FND_API.G_MISS_CHAR THEN
119: -- passed both id and name. id taken by default.
120: x_error_msg:='AMV_CAT_ID_AND_NAME_PASSED';
121: END IF;
122: x_return_status := FND_API.G_RET_STS_SUCCESS;
123: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
124: -- Category Id exists
125: x_exist_flag := FND_API.G_TRUE;
126: x_category_id := p_category_id;

Line 125: x_exist_flag := FND_API.G_TRUE;

121: END IF;
122: x_return_status := FND_API.G_RET_STS_SUCCESS;
123: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
124: -- Category Id exists
125: x_exist_flag := FND_API.G_TRUE;
126: x_category_id := p_category_id;
127: x_error_msg:='AMV_CAT_ID_EXISTS';
128: x_error_token := p_category_id;
129: ELSE

Line 131: x_exist_flag := FND_API.G_FALSE;

127: x_error_msg:='AMV_CAT_ID_EXISTS';
128: x_error_token := p_category_id;
129: ELSE
130: -- Invalid category id
131: x_exist_flag := FND_API.G_FALSE;
132: x_category_id := FND_API.G_MISS_NUM;
133: x_error_msg:='AMV_CAT_ID_NOT_EXIST';
134: x_error_token := p_category_id;
135: END IF;

Line 132: x_category_id := FND_API.G_MISS_NUM;

128: x_error_token := p_category_id;
129: ELSE
130: -- Invalid category id
131: x_exist_flag := FND_API.G_FALSE;
132: x_category_id := FND_API.G_MISS_NUM;
133: x_error_msg:='AMV_CAT_ID_NOT_EXIST';
134: x_error_token := p_category_id;
135: END IF;
136: ELSE

Line 137: IF p_category_name <> FND_API.G_MISS_CHAR THEN

133: x_error_msg:='AMV_CAT_ID_NOT_EXIST';
134: x_error_token := p_category_id;
135: END IF;
136: ELSE
137: IF p_category_name <> FND_API.G_MISS_CHAR THEN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_parent_category_id = FND_API.G_MISS_NUM OR
140: p_parent_category_id IS NULL
141: THEN

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: x_error_token := p_category_id;
135: END IF;
136: ELSE
137: IF p_category_name <> FND_API.G_MISS_CHAR THEN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_parent_category_id = FND_API.G_MISS_NUM OR
140: p_parent_category_id IS NULL
141: THEN
142: IF p_parent_category_name = FND_API.G_MISS_CHAR THEN

Line 139: IF p_parent_category_id = FND_API.G_MISS_NUM OR

135: END IF;
136: ELSE
137: IF p_category_name <> FND_API.G_MISS_CHAR THEN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_parent_category_id = FND_API.G_MISS_NUM OR
140: p_parent_category_id IS NULL
141: THEN
142: IF p_parent_category_name = FND_API.G_MISS_CHAR THEN
143: x_category_id :=Get_CategoryId(p_category_name);

Line 142: IF p_parent_category_name = FND_API.G_MISS_CHAR THEN

138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_parent_category_id = FND_API.G_MISS_NUM OR
140: p_parent_category_id IS NULL
141: THEN
142: IF p_parent_category_name = FND_API.G_MISS_CHAR THEN
143: x_category_id :=Get_CategoryId(p_category_name);
144: IF x_category_id <> FND_API.G_MISS_NUM THEN
145: x_exist_flag := FND_API.G_TRUE;
146: x_error_msg:='AMV_CAT_NAME_EXISTS';

Line 144: IF x_category_id <> FND_API.G_MISS_NUM THEN

140: p_parent_category_id IS NULL
141: THEN
142: IF p_parent_category_name = FND_API.G_MISS_CHAR THEN
143: x_category_id :=Get_CategoryId(p_category_name);
144: IF x_category_id <> FND_API.G_MISS_NUM THEN
145: x_exist_flag := FND_API.G_TRUE;
146: x_error_msg:='AMV_CAT_NAME_EXISTS';
147: x_error_token := p_category_name;
148: ELSE

Line 145: x_exist_flag := FND_API.G_TRUE;

141: THEN
142: IF p_parent_category_name = FND_API.G_MISS_CHAR THEN
143: x_category_id :=Get_CategoryId(p_category_name);
144: IF x_category_id <> FND_API.G_MISS_NUM THEN
145: x_exist_flag := FND_API.G_TRUE;
146: x_error_msg:='AMV_CAT_NAME_EXISTS';
147: x_error_token := p_category_name;
148: ELSE
149: -- Invalid category name

Line 150: x_exist_flag := FND_API.G_FALSE;

146: x_error_msg:='AMV_CAT_NAME_EXISTS';
147: x_error_token := p_category_name;
148: ELSE
149: -- Invalid category name
150: x_exist_flag := FND_API.G_FALSE;
151: x_error_msg:='AMV_CAT_NAME_NOT_EXIST';
152: x_error_token := p_category_name;
153: END IF;
154: ELSE

Line 157: IF l_category_id <> FND_API.G_MISS_NUM THEN

153: END IF;
154: ELSE
155: -- validation for sub category
156: l_category_id := Get_CategoryId(p_parent_category_name);
157: IF l_category_id <> FND_API.G_MISS_NUM THEN
158: x_category_id :=Get_CategoryId(p_category_name,
159: l_category_id);
160: IF x_category_id <> FND_API.G_MISS_NUM THEN
161: x_exist_flag := FND_API.G_TRUE;

Line 160: IF x_category_id <> FND_API.G_MISS_NUM THEN

156: l_category_id := Get_CategoryId(p_parent_category_name);
157: IF l_category_id <> FND_API.G_MISS_NUM THEN
158: x_category_id :=Get_CategoryId(p_category_name,
159: l_category_id);
160: IF x_category_id <> FND_API.G_MISS_NUM THEN
161: x_exist_flag := FND_API.G_TRUE;
162: x_error_msg :='AMV_CAT_NAME_EXISTS';
163: x_error_token := p_category_name;
164: ELSE

Line 161: x_exist_flag := FND_API.G_TRUE;

157: IF l_category_id <> FND_API.G_MISS_NUM THEN
158: x_category_id :=Get_CategoryId(p_category_name,
159: l_category_id);
160: IF x_category_id <> FND_API.G_MISS_NUM THEN
161: x_exist_flag := FND_API.G_TRUE;
162: x_error_msg :='AMV_CAT_NAME_EXISTS';
163: x_error_token := p_category_name;
164: ELSE
165: -- Invalid subcategory name

Line 166: x_exist_flag := FND_API.G_FALSE;

162: x_error_msg :='AMV_CAT_NAME_EXISTS';
163: x_error_token := p_category_name;
164: ELSE
165: -- Invalid subcategory name
166: x_exist_flag := FND_API.G_FALSE;
167: x_error_msg:='AMV_CAT_NAME_NOT_EXIST';
168: x_error_token := p_category_name;
169: END IF;
170: ELSE

Line 172: x_exist_flag := FND_API.G_FALSE;

168: x_error_token := p_category_name;
169: END IF;
170: ELSE
171: -- Invalid parent name for subcategory
172: x_exist_flag := FND_API.G_FALSE;
173: x_error_msg := 'AMV_CAT_NAME_NOT_EXIST';
174: x_error_token := p_parent_category_name;
175: END IF;
176: END IF;

Line 179: IF p_parent_category_name <> FND_API.G_MISS_CHAR THEN

175: END IF;
176: END IF;
177: ELSE
178: -- validation for sub category
179: IF p_parent_category_name <> FND_API.G_MISS_CHAR THEN
180: -- passed both id and name. id taken by default.
181: x_error_msg := 'AMV_CAT_ID_AND_NAME_PASSED';
182: END IF;
183: -- check if parent category id is valid

Line 187: IF x_category_id <> FND_API.G_MISS_NUM THEN

183: -- check if parent category id is valid
184: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_parent_category_id) THEN
185: x_category_id :=Get_CategoryId( p_category_name,
186: p_parent_category_id);
187: IF x_category_id <> FND_API.G_MISS_NUM THEN
188: x_exist_flag := FND_API.G_TRUE;
189: x_error_msg := 'AMV_CAT_NAME_EXISTS';
190: x_error_token := p_category_name;
191: ELSE

Line 188: x_exist_flag := FND_API.G_TRUE;

184: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_parent_category_id) THEN
185: x_category_id :=Get_CategoryId( p_category_name,
186: p_parent_category_id);
187: IF x_category_id <> FND_API.G_MISS_NUM THEN
188: x_exist_flag := FND_API.G_TRUE;
189: x_error_msg := 'AMV_CAT_NAME_EXISTS';
190: x_error_token := p_category_name;
191: ELSE
192: -- Invalid subcategory name

Line 193: x_exist_flag := FND_API.G_FALSE;

189: x_error_msg := 'AMV_CAT_NAME_EXISTS';
190: x_error_token := p_category_name;
191: ELSE
192: -- Invalid subcategory name
193: x_exist_flag := FND_API.G_FALSE;
194: x_error_msg := 'AMV_CAT_NAME_NOT_EXIST';
195: x_error_token := p_category_name;
196: END IF;
197: ELSE

Line 199: x_exist_flag := FND_API.G_FALSE;

195: x_error_token := p_category_name;
196: END IF;
197: ELSE
198: -- Invalid parent category id
199: x_exist_flag := FND_API.G_FALSE;
200: x_error_msg := 'AMV_CAT_ID_NOT_EXIST';
201: x_error_token := p_parent_category_id;
202: END IF;
203: END IF;

Line 206: RAISE FND_API.G_EXC_ERROR;

202: END IF;
203: END IF;
204: ELSE
205: -- 'Must pass either category id or category name to identify'
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208: END IF;
209: --
210: EXCEPTION

Line 211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

207: END IF;
208: END IF;
209: --
210: EXCEPTION
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: x_exist_flag := FND_API.G_FALSE;
214: x_category_id := FND_API.G_MISS_NUM;
215: x_error_msg := 'AMV_CAT_ID_OR_NAME_NULL';

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

208: END IF;
209: --
210: EXCEPTION
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: x_exist_flag := FND_API.G_FALSE;
214: x_category_id := FND_API.G_MISS_NUM;
215: x_error_msg := 'AMV_CAT_ID_OR_NAME_NULL';
216: x_error_token := null;

Line 213: x_exist_flag := FND_API.G_FALSE;

209: --
210: EXCEPTION
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: x_exist_flag := FND_API.G_FALSE;
214: x_category_id := FND_API.G_MISS_NUM;
215: x_error_msg := 'AMV_CAT_ID_OR_NAME_NULL';
216: x_error_token := null;
217: WHEN FND_API.G_EXC_ERROR THEN

Line 214: x_category_id := FND_API.G_MISS_NUM;

210: EXCEPTION
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: x_exist_flag := FND_API.G_FALSE;
214: x_category_id := FND_API.G_MISS_NUM;
215: x_error_msg := 'AMV_CAT_ID_OR_NAME_NULL';
216: x_error_token := null;
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;

Line 217: WHEN FND_API.G_EXC_ERROR THEN

213: x_exist_flag := FND_API.G_FALSE;
214: x_category_id := FND_API.G_MISS_NUM;
215: x_error_msg := 'AMV_CAT_ID_OR_NAME_NULL';
216: x_error_token := null;
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: x_exist_flag := FND_API.G_FALSE;
220: x_category_id := FND_API.G_MISS_NUM;
221: x_error_msg := 'AMV_CAT_ID_AND_NAME_MISS';

Line 218: x_return_status := FND_API.G_RET_STS_ERROR;

214: x_category_id := FND_API.G_MISS_NUM;
215: x_error_msg := 'AMV_CAT_ID_OR_NAME_NULL';
216: x_error_token := null;
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: x_exist_flag := FND_API.G_FALSE;
220: x_category_id := FND_API.G_MISS_NUM;
221: x_error_msg := 'AMV_CAT_ID_AND_NAME_MISS';
222: x_error_token := null;

Line 219: x_exist_flag := FND_API.G_FALSE;

215: x_error_msg := 'AMV_CAT_ID_OR_NAME_NULL';
216: x_error_token := null;
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: x_exist_flag := FND_API.G_FALSE;
220: x_category_id := FND_API.G_MISS_NUM;
221: x_error_msg := 'AMV_CAT_ID_AND_NAME_MISS';
222: x_error_token := null;
223: WHEN OTHERS THEN

Line 220: x_category_id := FND_API.G_MISS_NUM;

216: x_error_token := null;
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: x_exist_flag := FND_API.G_FALSE;
220: x_category_id := FND_API.G_MISS_NUM;
221: x_error_msg := 'AMV_CAT_ID_AND_NAME_MISS';
222: x_error_token := null;
223: WHEN OTHERS THEN
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

220: x_category_id := FND_API.G_MISS_NUM;
221: x_error_msg := 'AMV_CAT_ID_AND_NAME_MISS';
222: x_error_token := null;
223: WHEN OTHERS THEN
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: x_exist_flag := FND_API.G_FALSE;
226: x_category_id := FND_API.G_MISS_NUM;
227: x_error_msg := 'AMV_CAT_VALIDATION_FAILED';
228: x_error_token := substrb(sqlerrm, 1, 80);

Line 225: x_exist_flag := FND_API.G_FALSE;

221: x_error_msg := 'AMV_CAT_ID_AND_NAME_MISS';
222: x_error_token := null;
223: WHEN OTHERS THEN
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: x_exist_flag := FND_API.G_FALSE;
226: x_category_id := FND_API.G_MISS_NUM;
227: x_error_msg := 'AMV_CAT_VALIDATION_FAILED';
228: x_error_token := substrb(sqlerrm, 1, 80);
229: END Validate_CategoryStatus;

Line 226: x_category_id := FND_API.G_MISS_NUM;

222: x_error_token := null;
223: WHEN OTHERS THEN
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: x_exist_flag := FND_API.G_FALSE;
226: x_category_id := FND_API.G_MISS_NUM;
227: x_error_msg := 'AMV_CAT_VALIDATION_FAILED';
228: x_error_token := substrb(sqlerrm, 1, 80);
229: END Validate_CategoryStatus;
230: --

Line 242: -- Default = FND_API.G_MISS_NUM

238: -- Parameters :
239: -- IN : p_category_name IN VARCHAR2 Required
240: -- (sub)category id
241: -- p_parent_category_id IN NUMBER Optional
242: -- Default = FND_API.G_MISS_NUM
243: -- parent category id
244: -- OUT : None
245: -- Version : Current version 1.0
246: -- Previous version 1.0

Line 254: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM

250: --
251: FUNCTION Get_CategoryId
252: (
253: p_category_name IN VARCHAR2,
254: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
255: ) RETURN NUMBER
256: IS
257: l_category_id number;
258: --

Line 276: IF p_category_name = FND_API.G_MISS_CHAR OR

272: and tl.channel_category_id = b.channel_category_id
273: and b.parent_channel_category_id = p_parent_category_id;
274: --
275: BEGIN
276: IF p_category_name = FND_API.G_MISS_CHAR OR
277: p_category_name IS NULL
278: THEN
279: l_category_id := FND_API.G_MISS_NUM;
280: RETURN l_category_id;

Line 279: l_category_id := FND_API.G_MISS_NUM;

275: BEGIN
276: IF p_category_name = FND_API.G_MISS_CHAR OR
277: p_category_name IS NULL
278: THEN
279: l_category_id := FND_API.G_MISS_NUM;
280: RETURN l_category_id;
281: END IF;
282: --
283: IF p_parent_category_id = FND_API.G_MISS_NUM OR

Line 283: IF p_parent_category_id = FND_API.G_MISS_NUM OR

279: l_category_id := FND_API.G_MISS_NUM;
280: RETURN l_category_id;
281: END IF;
282: --
283: IF p_parent_category_id = FND_API.G_MISS_NUM OR
284: p_parent_category_id IS NULL THEN
285: -- get category id
286: OPEN Get_CategoryId;
287: FETCH Get_CategoryId INTO l_category_id;

Line 289: l_category_id := FND_API.G_MISS_NUM;

285: -- get category id
286: OPEN Get_CategoryId;
287: FETCH Get_CategoryId INTO l_category_id;
288: IF Get_CategoryId%NOTFOUND THEN
289: l_category_id := FND_API.G_MISS_NUM;
290: END IF;
291: CLOSE Get_CategoryId;
292: ELSE
293: -- get sub category id by catgeory id

Line 297: l_category_id := FND_API.G_MISS_NUM;

293: -- get sub category id by catgeory id
294: OPEN Get_SubCategoryId;
295: FETCH Get_SubCategoryId INTO l_category_id;
296: IF Get_SubCategoryId%NOTFOUND THEN
297: l_category_id := FND_API.G_MISS_NUM;
298: END IF;
299: CLOSE Get_SubCategoryId;
300: END IF;
301: --

Line 337: IF p_category_id = FND_API.G_MISS_NUM OR

333: from amv_c_categories_tl
334: where channel_category_id = p_category_id
335: and language = userenv('lang');
336: BEGIN
337: IF p_category_id = FND_API.G_MISS_NUM OR
338: p_category_id IS NULL THEN
339: l_category_name := FND_API.G_MISS_CHAR;
340: RETURN l_category_name;
341: END IF;

Line 339: l_category_name := FND_API.G_MISS_CHAR;

335: and language = userenv('lang');
336: BEGIN
337: IF p_category_id = FND_API.G_MISS_NUM OR
338: p_category_id IS NULL THEN
339: l_category_name := FND_API.G_MISS_CHAR;
340: RETURN l_category_name;
341: END IF;
342: --
343: OPEN Get_CategoryName;

Line 346: l_category_name := FND_API.G_MISS_CHAR;

342: --
343: OPEN Get_CategoryName;
344: FETCH Get_CategoryName INTO l_category_name;
345: IF Get_CategoryName%NOTFOUND THEN
346: l_category_name := FND_API.G_MISS_CHAR;
347: END IF;
348: CLOSE Get_CategoryName;
349: --
350: RETURN l_category_name;

Line 501: -- Default = FND_API.G_FALSE

497: -- Function : Create channel (sub)category.
498: -- Parameters :
499: -- IN : p_api_version IN NUMBER Required
500: -- p_init_msg_list IN VARCHAR2 Optional
501: -- Default = FND_API.G_FALSE
502: -- p_commit IN VARCHAR2 Optional
503: -- Default = FND_API.G_FALSE
504: -- p_validation_level IN NUMBER Optional
505: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 503: -- Default = FND_API.G_FALSE

499: -- IN : p_api_version IN NUMBER Required
500: -- p_init_msg_list IN VARCHAR2 Optional
501: -- Default = FND_API.G_FALSE
502: -- p_commit IN VARCHAR2 Optional
503: -- Default = FND_API.G_FALSE
504: -- p_validation_level IN NUMBER Optional
505: -- Default = FND_API.G_VALID_LEVEL_FULL
506: -- p_application_id IN NUMBER Optional
507: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)

Line 505: -- Default = FND_API.G_VALID_LEVEL_FULL

501: -- Default = FND_API.G_FALSE
502: -- p_commit IN VARCHAR2 Optional
503: -- Default = FND_API.G_FALSE
504: -- p_validation_level IN NUMBER Optional
505: -- Default = FND_API.G_VALID_LEVEL_FULL
506: -- p_application_id IN NUMBER Optional
507: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)
508: -- p_category_name IN VARCHAR2 Required
509: -- the channel (sub)category name. Have to be unique.

Line 513: -- Default = FND_API.G_MISS_NUM

509: -- the channel (sub)category name. Have to be unique.
510: -- p_description IN VARCHAR2 Optional
511: -- the channel (sub)category description.
512: -- p_parent_category_id IN NUMBER Optional
513: -- Default = FND_API.G_MISS_NUM
514: -- p_parent_category_name IN VARCHAR2 Optional
515: -- Default = FND_API.G_MISS_CHAR
516: -- parent id or name required for creating sub categories.
517: -- p_order IN NUMBER Optional

Line 515: -- Default = FND_API.G_MISS_CHAR

511: -- the channel (sub)category description.
512: -- p_parent_category_id IN NUMBER Optional
513: -- Default = FND_API.G_MISS_NUM
514: -- p_parent_category_name IN VARCHAR2 Optional
515: -- Default = FND_API.G_MISS_CHAR
516: -- parent id or name required for creating sub categories.
517: -- p_order IN NUMBER Optional
518: -- Default = FND_API.G_MISS_NUM
519: -- the order of this (sub)category among all the categories

Line 518: -- Default = FND_API.G_MISS_NUM

514: -- p_parent_category_name IN VARCHAR2 Optional
515: -- Default = FND_API.G_MISS_CHAR
516: -- parent id or name required for creating sub categories.
517: -- p_order IN NUMBER Optional
518: -- Default = FND_API.G_MISS_NUM
519: -- the order of this (sub)category among all the categories
520: -- OUT : x_return_status OUT VARCHAR2
521: -- x_msg_count OUT NUMBER
522: -- x_msg_data OUT VARCHAR2

Line 534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

530: --
531: PROCEDURE Add_Category
532: (
533: p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
537: x_return_status OUT NOCOPY VARCHAR2,
538: x_msg_count OUT NOCOPY NUMBER,

Line 535: p_commit IN VARCHAR2 := FND_API.G_FALSE,

531: PROCEDURE Add_Category
532: (
533: p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
537: x_return_status OUT NOCOPY VARCHAR2,
538: x_msg_count OUT NOCOPY NUMBER,
539: x_msg_data OUT NOCOPY VARCHAR2,

Line 536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

532: (
533: p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
537: x_return_status OUT NOCOPY VARCHAR2,
538: x_msg_count OUT NOCOPY NUMBER,
539: x_msg_data OUT NOCOPY VARCHAR2,
540: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 540: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
537: x_return_status OUT NOCOPY VARCHAR2,
538: x_msg_count OUT NOCOPY NUMBER,
539: x_msg_data OUT NOCOPY VARCHAR2,
540: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
541: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
542: p_category_name IN VARCHAR2,
543: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
544: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

Line 543: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

539: x_msg_data OUT NOCOPY VARCHAR2,
540: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
541: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
542: p_category_name IN VARCHAR2,
543: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
544: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
545: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_order IN NUMBER := FND_API.G_MISS_NUM,
547: x_category_id OUT NOCOPY NUMBER

Line 544: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

540: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
541: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
542: p_category_name IN VARCHAR2,
543: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
544: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
545: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_order IN NUMBER := FND_API.G_MISS_NUM,
547: x_category_id OUT NOCOPY NUMBER
548: )

Line 545: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

541: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
542: p_category_name IN VARCHAR2,
543: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
544: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
545: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_order IN NUMBER := FND_API.G_MISS_NUM,
547: x_category_id OUT NOCOPY NUMBER
548: )
549: IS

Line 546: p_order IN NUMBER := FND_API.G_MISS_NUM,

542: p_category_name IN VARCHAR2,
543: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
544: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
545: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
546: p_order IN NUMBER := FND_API.G_MISS_NUM,
547: x_category_id OUT NOCOPY NUMBER
548: )
549: IS
550: l_api_name CONSTANT VARCHAR2(30) := 'Add_Category';

Line 589: IF NOT FND_API.Compatible_API_Call (

585: BEGIN
586: -- Standard begin of API savepoint
587: SAVEPOINT Add_Category_PVT;
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call (
590: l_api_version,
591: p_api_version,
592: l_api_name,
593: G_PKG_NAME)

Line 595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

591: p_api_version,
592: l_api_name,
593: G_PKG_NAME)
594: THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597: -- Debug Message
598: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
599: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 604: IF FND_API.To_Boolean (p_init_msg_list) THEN

600: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
601: FND_MSG_PUB.Add;
602: END IF;
603: --Initialize message list if p_init_msg_list is TRUE.
604: IF FND_API.To_Boolean (p_init_msg_list) THEN
605: FND_MSG_PUB.initialize;
606: END IF;
607: -- Get the current (login) user id.
608: AMV_UTILITY_PVT.Get_UserInfo(

Line 615: IF (p_check_login_user = FND_API.G_TRUE) THEN

611: x_login_id => l_login_user_id,
612: x_user_status => l_login_user_status
613: );
614: -- check login user
615: IF (p_check_login_user = FND_API.G_TRUE) THEN
616: -- Check if user is login and has the required privilege.
617: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
618: -- User is not login.
619: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 617: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

613: );
614: -- check login user
615: IF (p_check_login_user = FND_API.G_TRUE) THEN
616: -- Check if user is login and has the required privilege.
617: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
618: -- User is not login.
619: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
620: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
621: FND_MSG_PUB.Add;

Line 623: RAISE FND_API.G_EXC_ERROR;

619: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
620: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
621: FND_MSG_PUB.Add;
622: END IF;
623: RAISE FND_API.G_EXC_ERROR;
624: END IF;
625: END IF;
626: -- This fix is for executing api in sqlplus mode
627: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 627: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

623: RAISE FND_API.G_EXC_ERROR;
624: END IF;
625: END IF;
626: -- This fix is for executing api in sqlplus mode
627: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
628: l_login_user_id := g_login_user_id;
629: l_user_id := g_user_id;
630: l_resource_id := g_resource_id;
631: END IF;

Line 633: x_return_status := FND_API.G_RET_STS_SUCCESS;

629: l_user_id := g_user_id;
630: l_resource_id := g_resource_id;
631: END IF;
632: -- Initialize API return status to sucess
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: -- check if the parent category id and name are valid
636: Validate_CategoryStatus(
637: x_return_status => x_return_status,

Line 645: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

641: x_category_id => l_parent_category_id,
642: x_error_msg => l_Error_Msg,
643: x_error_token => l_Error_Token
644: );
645: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
646: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
647: -- parent id or name is not valid
648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN

Line 646: IF (l_category_exist_flag = FND_API.G_FALSE) THEN

642: x_error_msg => l_Error_Msg,
643: x_error_token => l_Error_Token
644: );
645: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
646: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
647: -- parent id or name is not valid
648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN
650: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);

Line 654: RAISE FND_API.G_EXC_ERROR;

650: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
651: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
652: FND_MSG_PUB.Add;
653: END IF;
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656: ELSE
657: -- parent id or name is valid
658: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 658: x_return_status := FND_API.G_RET_STS_SUCCESS;

654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656: ELSE
657: -- parent id or name is valid
658: x_return_status := FND_API.G_RET_STS_SUCCESS;
659: END IF;
660:
661: -- check users privilege to create category
662: AMV_USER_PVT.Can_SetupCategory(

Line 664: p_init_msg_list => FND_API.G_FALSE,

660:
661: -- check users privilege to create category
662: AMV_USER_PVT.Can_SetupCategory(
663: p_api_version => l_api_version,
664: p_init_msg_list => FND_API.G_FALSE,
665: p_validation_level => p_validation_level,
666: x_return_status => x_return_status,
667: x_msg_count => x_msg_count,
668: x_msg_data => x_msg_data,

Line 669: p_check_login_user => FND_API.G_FALSE,

665: p_validation_level => p_validation_level,
666: x_return_status => x_return_status,
667: x_msg_count => x_msg_count,
668: x_msg_data => x_msg_data,
669: p_check_login_user => FND_API.G_FALSE,
670: p_resource_id => l_resource_id,
671: p_include_group_flag => FND_API.G_TRUE,
672: x_result_flag => l_setup_result
673: );

Line 671: p_include_group_flag => FND_API.G_TRUE,

667: x_msg_count => x_msg_count,
668: x_msg_data => x_msg_data,
669: p_check_login_user => FND_API.G_FALSE,
670: p_resource_id => l_resource_id,
671: p_include_group_flag => FND_API.G_TRUE,
672: x_result_flag => l_setup_result
673: );
674:
675: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 675: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

671: p_include_group_flag => FND_API.G_TRUE,
672: x_result_flag => l_setup_result
673: );
674:
675: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
676: IF l_setup_result = FND_API.G_TRUE THEN
677: -- check if the (sub)category name exists
678: Validate_CategoryStatus (
679: x_return_status => x_return_status,

Line 676: IF l_setup_result = FND_API.G_TRUE THEN

672: x_result_flag => l_setup_result
673: );
674:
675: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
676: IF l_setup_result = FND_API.G_TRUE THEN
677: -- check if the (sub)category name exists
678: Validate_CategoryStatus (
679: x_return_status => x_return_status,
680: p_category_name => p_category_name,

Line 688: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

684: x_error_msg => l_Error_Msg,
685: x_error_token => l_Error_Token
686: );
687: -- Add category if it does not exist
688: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
689: IF (l_category_exist_flag = FND_API.G_TRUE) THEN
690: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
691: THEN
692: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);

Line 689: IF (l_category_exist_flag = FND_API.G_TRUE) THEN

685: x_error_token => l_Error_Token
686: );
687: -- Add category if it does not exist
688: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
689: IF (l_category_exist_flag = FND_API.G_TRUE) THEN
690: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
691: THEN
692: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
693: FND_MESSAGE.Set_Token('TKN',l_Error_Token);

Line 696: RAISE FND_API.G_EXC_ERROR;

692: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
693: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
694: FND_MSG_PUB.Add;
695: END IF;
696: RAISE FND_API.G_EXC_ERROR;
697: ELSE
698: -- set the category order
699: IF p_order = FND_API.G_MISS_NUM THEN
700: IF l_parent_category_id = FND_API.G_MISS_NUM THEN

Line 699: IF p_order = FND_API.G_MISS_NUM THEN

695: END IF;
696: RAISE FND_API.G_EXC_ERROR;
697: ELSE
698: -- set the category order
699: IF p_order = FND_API.G_MISS_NUM THEN
700: IF l_parent_category_id = FND_API.G_MISS_NUM THEN
701: OPEN Max_CategoryOrder;
702: FETCH Max_CategoryOrder INTO l_order;
703: CLOSE Max_CategoryOrder;

Line 700: IF l_parent_category_id = FND_API.G_MISS_NUM THEN

696: RAISE FND_API.G_EXC_ERROR;
697: ELSE
698: -- set the category order
699: IF p_order = FND_API.G_MISS_NUM THEN
700: IF l_parent_category_id = FND_API.G_MISS_NUM THEN
701: OPEN Max_CategoryOrder;
702: FETCH Max_CategoryOrder INTO l_order;
703: CLOSE Max_CategoryOrder;
704: ELSE

Line 713: IF l_parent_category_id = FND_API.G_MISS_NUM THEN

709: ELSE
710: l_order := p_order;
711: END IF;
712: -- Set parent id to null if none
713: IF l_parent_category_id = FND_API.G_MISS_NUM THEN
714: l_parent_category_id := null;
715: END IF;
716: -- Select the channel category sequence
717: OPEN CategoryId_Seq;

Line 749: RAISE FND_API.G_EXC_ERROR;

745: FND_MESSAGE.Set_Token('ACTION', 'Adding');
746: FND_MESSAGE.Set_Token('TABLE', 'Categories');
747: FND_MSG_PUB.Add;
748: END IF;
749: RAISE FND_API.G_EXC_ERROR;
750: END;
751: --
752: -- Pass the channel category id created
753: x_category_id := l_category_id;

Line 762: RAISE FND_API.G_EXC_ERROR;

758: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
759: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
760: FND_MSG_PUB.Add;
761: END IF;
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764: ELSE
765: -- user does not have privelege to create category
766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 772: RAISE FND_API.G_EXC_ERROR;

768: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
769: FND_MESSAGE.Set_Token('LEVEL','Category');
770: FND_MSG_PUB.Add;
771: END IF;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: ELSE
775: -- error while checking for user privilege
776: -- error in Can_SetupCategory

Line 783: RAISE FND_API.G_EXC_ERROR;

779: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
780: FND_MESSAGE.Set_Token('LEVEL','Category');
781: FND_MSG_PUB.Add;
782: END IF;
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785: --
786:
787: -- Success message

Line 795: IF FND_API.To_Boolean ( p_commit ) THEN

791: FND_MESSAGE.Set_Token('ROW', l_full_name);
792: FND_MSG_PUB.Add;
793: END IF;
794: --Standard check of commit
795: IF FND_API.To_Boolean ( p_commit ) THEN
796: COMMIT WORK;
797: END IF;
798: -- Debug Message
799: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 806: p_encoded => FND_API.G_FALSE,

802: FND_MSG_PUB.Add;
803: END IF;
804: --Standard call to get message count and if count=1, get the message
805: FND_MSG_PUB.Count_And_Get (
806: p_encoded => FND_API.G_FALSE,
807: p_count => x_msg_count,
808: p_data => x_msg_data
809: );
810: EXCEPTION

Line 811: WHEN FND_API.G_EXC_ERROR THEN

807: p_count => x_msg_count,
808: p_data => x_msg_data
809: );
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: ROLLBACK TO Add_Category_PVT;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (

Line 813: x_return_status := FND_API.G_RET_STS_ERROR;

809: );
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: ROLLBACK TO Add_Category_PVT;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,

Line 816: p_encoded => FND_API.G_FALSE,

812: ROLLBACK TO Add_Category_PVT;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data
819: );
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data
819: );
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821: ROLLBACK TO Add_Category_PVT;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (

Line 822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

818: p_data => x_msg_data
819: );
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821: ROLLBACK TO Add_Category_PVT;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (
825: p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,

Line 825: p_encoded => FND_API.G_FALSE,

821: ROLLBACK TO Add_Category_PVT;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (
825: p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data
828: );
829: WHEN OTHERS THEN

Line 831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

827: p_data => x_msg_data
828: );
829: WHEN OTHERS THEN
830: ROLLBACK TO Add_Category_PVT;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
835: END IF;

Line 838: p_encoded => FND_API.G_FALSE,

834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
835: END IF;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,
840: p_data => x_msg_data
841: );
842: --

Line 854: -- Default = FND_API.G_FALSE

850: -- p_category_id(preferred) or p_category_name.
851: -- Parameters :
852: -- IN p_api_version IN NUMBER Required
853: -- p_init_msg_list IN VARCHAR2 Optional
854: -- Default = FND_API.G_FALSE
855: -- p_commit IN VARCHAR2 Optional
856: -- Default = FND_API.G_FALSE
857: -- p_validation_level IN NUMBER Optional
858: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 856: -- Default = FND_API.G_FALSE

852: -- IN p_api_version IN NUMBER Required
853: -- p_init_msg_list IN VARCHAR2 Optional
854: -- Default = FND_API.G_FALSE
855: -- p_commit IN VARCHAR2 Optional
856: -- Default = FND_API.G_FALSE
857: -- p_validation_level IN NUMBER Optional
858: -- Default = FND_API.G_VALID_LEVEL_FULL
859: -- p_category_id IN NUMBER Optional
860: -- Default = FND_API.G_MISS_NUM

Line 858: -- Default = FND_API.G_VALID_LEVEL_FULL

854: -- Default = FND_API.G_FALSE
855: -- p_commit IN VARCHAR2 Optional
856: -- Default = FND_API.G_FALSE
857: -- p_validation_level IN NUMBER Optional
858: -- Default = FND_API.G_VALID_LEVEL_FULL
859: -- p_category_id IN NUMBER Optional
860: -- Default = FND_API.G_MISS_NUM
861: -- channel (sub)category id.
862: -- p_category_name IN VARCHAR2 Optional

Line 860: -- Default = FND_API.G_MISS_NUM

856: -- Default = FND_API.G_FALSE
857: -- p_validation_level IN NUMBER Optional
858: -- Default = FND_API.G_VALID_LEVEL_FULL
859: -- p_category_id IN NUMBER Optional
860: -- Default = FND_API.G_MISS_NUM
861: -- channel (sub)category id.
862: -- p_category_name IN VARCHAR2 Optional
863: -- Default = FND_API.G_MISS_CHAR
864: -- channel (sub)category name.

Line 863: -- Default = FND_API.G_MISS_CHAR

859: -- p_category_id IN NUMBER Optional
860: -- Default = FND_API.G_MISS_NUM
861: -- channel (sub)category id.
862: -- p_category_name IN VARCHAR2 Optional
863: -- Default = FND_API.G_MISS_CHAR
864: -- channel (sub)category name.
865: -- p_parent_category_id IN NUMBER Optional
866: -- Default = FND_API.G_MISS_NUM
867: -- p_parent_category_name IN VARCHAR2 Optional

Line 866: -- Default = FND_API.G_MISS_NUM

862: -- p_category_name IN VARCHAR2 Optional
863: -- Default = FND_API.G_MISS_CHAR
864: -- channel (sub)category name.
865: -- p_parent_category_id IN NUMBER Optional
866: -- Default = FND_API.G_MISS_NUM
867: -- p_parent_category_name IN VARCHAR2 Optional
868: -- Default = FND_API.G_MISS_CHAR
869: -- Either pass the channel (sub)category id (preferred)
870: -- or channel (sub)category name

Line 868: -- Default = FND_API.G_MISS_CHAR

864: -- channel (sub)category name.
865: -- p_parent_category_id IN NUMBER Optional
866: -- Default = FND_API.G_MISS_NUM
867: -- p_parent_category_name IN VARCHAR2 Optional
868: -- Default = FND_API.G_MISS_CHAR
869: -- Either pass the channel (sub)category id (preferred)
870: -- or channel (sub)category name
871: -- to identify the channel (sub)category.
872: -- OUT : x_return_status OUT VARCHAR2

Line 884: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

880: -- End of comments
881: --
882: PROCEDURE Delete_Category
883: ( p_api_version IN NUMBER,
884: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
885: p_commit IN VARCHAR2 := FND_API.G_FALSE,
886: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
887: x_return_status OUT NOCOPY VARCHAR2,
888: x_msg_count OUT NOCOPY NUMBER,

Line 885: p_commit IN VARCHAR2 := FND_API.G_FALSE,

881: --
882: PROCEDURE Delete_Category
883: ( p_api_version IN NUMBER,
884: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
885: p_commit IN VARCHAR2 := FND_API.G_FALSE,
886: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
887: x_return_status OUT NOCOPY VARCHAR2,
888: x_msg_count OUT NOCOPY NUMBER,
889: x_msg_data OUT NOCOPY VARCHAR2,

Line 886: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

882: PROCEDURE Delete_Category
883: ( p_api_version IN NUMBER,
884: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
885: p_commit IN VARCHAR2 := FND_API.G_FALSE,
886: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
887: x_return_status OUT NOCOPY VARCHAR2,
888: x_msg_count OUT NOCOPY NUMBER,
889: x_msg_data OUT NOCOPY VARCHAR2,
890: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 890: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

886: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
887: x_return_status OUT NOCOPY VARCHAR2,
888: x_msg_count OUT NOCOPY NUMBER,
889: x_msg_data OUT NOCOPY VARCHAR2,
890: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
891: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
892: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
893: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

Line 892: p_category_id IN NUMBER := FND_API.G_MISS_NUM,

888: x_msg_count OUT NOCOPY NUMBER,
889: x_msg_data OUT NOCOPY VARCHAR2,
890: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
891: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
892: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
893: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
895: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
896: )

Line 893: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

889: x_msg_data OUT NOCOPY VARCHAR2,
890: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
891: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
892: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
893: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
895: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
896: )
897: IS

Line 894: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

890: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
891: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
892: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
893: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
895: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
896: )
897: IS
898: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Category';

Line 895: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR

891: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
892: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
893: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
895: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
896: )
897: IS
898: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Category';
899: l_api_version CONSTANT NUMBER := 1.0;

Line 930: IF NOT FND_API.Compatible_API_Call (

926: BEGIN
927: -- Standard begin of API savepoint
928: SAVEPOINT Delete_Category_PVT;
929: -- Standard call to check for call compatibility.
930: IF NOT FND_API.Compatible_API_Call (
931: l_api_version,
932: p_api_version,
933: l_api_name,
934: G_PKG_NAME)

Line 936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

932: p_api_version,
933: l_api_name,
934: G_PKG_NAME)
935: THEN
936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
937: END IF;
938: -- Debug Message
939: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
940: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 945: IF FND_API.To_Boolean (p_init_msg_list) THEN

941: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
942: FND_MSG_PUB.Add;
943: END IF;
944: --Initialize message list if p_init_msg_list is TRUE.
945: IF FND_API.To_Boolean (p_init_msg_list) THEN
946: FND_MSG_PUB.initialize;
947: END IF;
948: -- Get the current (login) user id.
949: AMV_UTILITY_PVT.Get_UserInfo(

Line 956: IF (p_check_login_user = FND_API.G_TRUE) THEN

952: x_login_id => l_login_user_id,
953: x_user_status => l_login_user_status
954: );
955: -- check login user
956: IF (p_check_login_user = FND_API.G_TRUE) THEN
957: -- Check if user is login and has the required privilege.
958: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
959: -- User is not login.
960: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 958: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

954: );
955: -- check login user
956: IF (p_check_login_user = FND_API.G_TRUE) THEN
957: -- Check if user is login and has the required privilege.
958: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
959: -- User is not login.
960: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
961: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
962: FND_MSG_PUB.Add;

Line 964: RAISE FND_API.G_EXC_ERROR;

960: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
961: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
962: FND_MSG_PUB.Add;
963: END IF;
964: RAISE FND_API.G_EXC_ERROR;
965: END IF;
966: END IF;
967: -- This fix is for executing api in sqlplus mode
968: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 968: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

964: RAISE FND_API.G_EXC_ERROR;
965: END IF;
966: END IF;
967: -- This fix is for executing api in sqlplus mode
968: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
969: l_login_user_id := g_login_user_id;
970: l_user_id := g_user_id;
971: l_resource_id := g_resource_id;
972: END IF;

Line 974: x_return_status := FND_API.G_RET_STS_SUCCESS;

970: l_user_id := g_user_id;
971: l_resource_id := g_resource_id;
972: END IF;
973: -- Initialize API return status to sucess
974: x_return_status := FND_API.G_RET_STS_SUCCESS;
975:
976: --
977: -- Check channel id and status for a given channel id or channel name
978: Validate_CategoryStatus (

Line 990: IF (l_category_exist_flag = FND_API.G_FALSE) THEN

986: x_error_msg => l_Error_Msg,
987: x_error_token => l_Error_Token
988: );
989: -- check if channel exists
990: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
992: THEN
993: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
994: FND_MESSAGE.Set_Token('TKN',l_Error_Token);

Line 997: RAISE FND_API.G_EXC_ERROR;

993: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
994: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
995: FND_MSG_PUB.Add;
996: END IF;
997: RAISE FND_API.G_EXC_ERROR;
998: ELSE
999: -- check if the user has privilege to delete category
1000: --
1001: AMV_USER_PVT.Can_SetupCategory (

Line 1003: p_init_msg_list => FND_API.G_FALSE,

999: -- check if the user has privilege to delete category
1000: --
1001: AMV_USER_PVT.Can_SetupCategory (
1002: p_api_version => l_api_version,
1003: p_init_msg_list => FND_API.G_FALSE,
1004: p_validation_level => p_validation_level,
1005: x_return_status => x_return_status,
1006: x_msg_count => x_msg_count,
1007: x_msg_data => x_msg_data,

Line 1008: p_check_login_user => FND_API.G_FALSE,

1004: p_validation_level => p_validation_level,
1005: x_return_status => x_return_status,
1006: x_msg_count => x_msg_count,
1007: x_msg_data => x_msg_data,
1008: p_check_login_user => FND_API.G_FALSE,
1009: p_resource_id => l_resource_id,
1010: p_include_group_flag => FND_API.G_TRUE,
1011: x_result_flag => l_setup_result
1012: );

Line 1010: p_include_group_flag => FND_API.G_TRUE,

1006: x_msg_count => x_msg_count,
1007: x_msg_data => x_msg_data,
1008: p_check_login_user => FND_API.G_FALSE,
1009: p_resource_id => l_resource_id,
1010: p_include_group_flag => FND_API.G_TRUE,
1011: x_result_flag => l_setup_result
1012: );
1013:
1014: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1014: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1010: p_include_group_flag => FND_API.G_TRUE,
1011: x_result_flag => l_setup_result
1012: );
1013:
1014: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1015: IF (l_setup_result = FND_API.G_TRUE) THEN
1016: l_delete_category_flag := FND_API.G_TRUE;
1017: ELSE
1018: IF (AMV_UTILITY_PVT.Get_DeleteCategoryStatus(

Line 1015: IF (l_setup_result = FND_API.G_TRUE) THEN

1011: x_result_flag => l_setup_result
1012: );
1013:
1014: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1015: IF (l_setup_result = FND_API.G_TRUE) THEN
1016: l_delete_category_flag := FND_API.G_TRUE;
1017: ELSE
1018: IF (AMV_UTILITY_PVT.Get_DeleteCategoryStatus(
1019: l_category_id,

Line 1016: l_delete_category_flag := FND_API.G_TRUE;

1012: );
1013:
1014: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1015: IF (l_setup_result = FND_API.G_TRUE) THEN
1016: l_delete_category_flag := FND_API.G_TRUE;
1017: ELSE
1018: IF (AMV_UTILITY_PVT.Get_DeleteCategoryStatus(
1019: l_category_id,
1020: l_resource_id,

Line 1023: l_delete_category_flag := FND_API.G_TRUE;

1019: l_category_id,
1020: l_resource_id,
1021: AMV_UTILITY_PVT.G_USER) )
1022: THEN
1023: l_delete_category_flag := FND_API.G_TRUE;
1024: ELSE
1025: -- user does not have privilege to create category
1026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1027: THEN

Line 1032: RAISE FND_API.G_EXC_ERROR;

1028: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1029: FND_MESSAGE.Set_Token('LEVEL','Category');
1030: FND_MSG_PUB.Add;
1031: END IF;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034: END IF;
1035: ELSE
1036: -- error while user privilege check in Can_SetupCategory

Line 1043: RAISE FND_API.G_EXC_ERROR;

1039: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1040: FND_MESSAGE.Set_Token('LEVEL','Category');
1041: FND_MSG_PUB.Add;
1042: END IF;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045: END IF;
1046: --
1047:

Line 1049: IF l_delete_category_flag = FND_API.G_TRUE THEN

1045: END IF;
1046: --
1047:
1048: --
1049: IF l_delete_category_flag = FND_API.G_TRUE THEN
1050: l_category_hr := amv_cat_hierarchy_varray_type();
1051:
1052: Get_CategoryHierarchy(l_category_id,l_category_level,l_category_hr);
1053:

Line 1114: IF FND_API.To_Boolean ( p_commit ) THEN

1110: FND_MESSAGE.Set_Token('ROW', l_full_name);
1111: FND_MSG_PUB.Add;
1112: END IF;
1113: --Standard check of commit
1114: IF FND_API.To_Boolean ( p_commit ) THEN
1115: COMMIT WORK;
1116: END IF;
1117: -- Debug Message
1118: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1125: p_encoded => FND_API.G_FALSE,

1121: FND_MSG_PUB.Add;
1122: END IF;
1123: --Standard call to get message count and if count=1, get the message
1124: FND_MSG_PUB.Count_And_Get (
1125: p_encoded => FND_API.G_FALSE,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data
1128: );
1129: EXCEPTION

Line 1130: WHEN FND_API.G_EXC_ERROR THEN

1126: p_count => x_msg_count,
1127: p_data => x_msg_data
1128: );
1129: EXCEPTION
1130: WHEN FND_API.G_EXC_ERROR THEN
1131: ROLLBACK TO Delete_Category_PVT;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: -- Standard call to get message count and if count=1, get the message
1134: FND_MSG_PUB.Count_And_Get (

Line 1132: x_return_status := FND_API.G_RET_STS_ERROR;

1128: );
1129: EXCEPTION
1130: WHEN FND_API.G_EXC_ERROR THEN
1131: ROLLBACK TO Delete_Category_PVT;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: -- Standard call to get message count and if count=1, get the message
1134: FND_MSG_PUB.Count_And_Get (
1135: p_encoded => FND_API.G_FALSE,
1136: p_count => x_msg_count,

Line 1135: p_encoded => FND_API.G_FALSE,

1131: ROLLBACK TO Delete_Category_PVT;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: -- Standard call to get message count and if count=1, get the message
1134: FND_MSG_PUB.Count_And_Get (
1135: p_encoded => FND_API.G_FALSE,
1136: p_count => x_msg_count,
1137: p_data => x_msg_data
1138: );
1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1135: p_encoded => FND_API.G_FALSE,
1136: p_count => x_msg_count,
1137: p_data => x_msg_data
1138: );
1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1140: ROLLBACK TO Delete_Category_PVT;
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142: -- Standard call to get message count and if count=1, get the message
1143: FND_MSG_PUB.Count_And_Get (

Line 1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1137: p_data => x_msg_data
1138: );
1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1140: ROLLBACK TO Delete_Category_PVT;
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142: -- Standard call to get message count and if count=1, get the message
1143: FND_MSG_PUB.Count_And_Get (
1144: p_encoded => FND_API.G_FALSE,
1145: p_count => x_msg_count,

Line 1144: p_encoded => FND_API.G_FALSE,

1140: ROLLBACK TO Delete_Category_PVT;
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142: -- Standard call to get message count and if count=1, get the message
1143: FND_MSG_PUB.Count_And_Get (
1144: p_encoded => FND_API.G_FALSE,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data
1147: );
1148: WHEN OTHERS THEN

Line 1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1146: p_data => x_msg_data
1147: );
1148: WHEN OTHERS THEN
1149: ROLLBACK TO Delete_Category_PVT;
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1154: END IF;

Line 1157: p_encoded => FND_API.G_FALSE,

1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1154: END IF;
1155: -- Standard call to get message count and if count=1, get the message
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data
1160: );
1161: --

Line 1172: -- Default = FND_API.G_FALSE

1168: -- Function : sort (sub)category list in ascending or descending order
1169: -- Parameters :
1170: -- IN p_api_version IN NUMBER Required
1171: -- p_init_msg_list IN VARCHAR2 Optional
1172: -- Default = FND_API.G_FALSE
1173: -- p_commit IN VARCHAR2 Optional
1174: -- Default = FND_API.G_FALSE
1175: -- p_validation_level IN NUMBER Optional
1176: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1174: -- Default = FND_API.G_FALSE

1170: -- IN p_api_version IN NUMBER Required
1171: -- p_init_msg_list IN VARCHAR2 Optional
1172: -- Default = FND_API.G_FALSE
1173: -- p_commit IN VARCHAR2 Optional
1174: -- Default = FND_API.G_FALSE
1175: -- p_validation_level IN NUMBER Optional
1176: -- Default = FND_API.G_VALID_LEVEL_FULL
1177: -- p_sort_order IN VARCHAR2 Optional
1178: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER

Line 1176: -- Default = FND_API.G_VALID_LEVEL_FULL

1172: -- Default = FND_API.G_FALSE
1173: -- p_commit IN VARCHAR2 Optional
1174: -- Default = FND_API.G_FALSE
1175: -- p_validation_level IN NUMBER Optional
1176: -- Default = FND_API.G_VALID_LEVEL_FULL
1177: -- p_sort_order IN VARCHAR2 Optional
1178: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER
1179: -- Ascending(ASC) or Descending(DESC) Order.
1180: -- p_parent_category_id IN NUMBER Optional

Line 1181: -- Default = FND_API.G_MISS_NUM

1177: -- p_sort_order IN VARCHAR2 Optional
1178: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER
1179: -- Ascending(ASC) or Descending(DESC) Order.
1180: -- p_parent_category_id IN NUMBER Optional
1181: -- Default = FND_API.G_MISS_NUM
1182: -- parent id for sub categories
1183: -- p_parent_category_name IN VARCHAR2 Optional
1184: -- Default = FND_API.G_MISS_CHAR
1185: -- category name for sub categories

Line 1184: -- Default = FND_API.G_MISS_CHAR

1180: -- p_parent_category_id IN NUMBER Optional
1181: -- Default = FND_API.G_MISS_NUM
1182: -- parent id for sub categories
1183: -- p_parent_category_name IN VARCHAR2 Optional
1184: -- Default = FND_API.G_MISS_CHAR
1185: -- category name for sub categories
1186: -- category name or parent category id should be
1187: -- supplied for sorting sub categories
1188: -- OUT : x_return_status OUT VARCHAR2

Line 1200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1196: -- End of comments
1197: --
1198: PROCEDURE Sort_Category
1199: ( p_api_version IN NUMBER,
1200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1203: x_return_status OUT NOCOPY VARCHAR2,
1204: x_msg_count OUT NOCOPY NUMBER,

Line 1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1197: --
1198: PROCEDURE Sort_Category
1199: ( p_api_version IN NUMBER,
1200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1203: x_return_status OUT NOCOPY VARCHAR2,
1204: x_msg_count OUT NOCOPY NUMBER,
1205: x_msg_data OUT NOCOPY VARCHAR2,

Line 1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1198: PROCEDURE Sort_Category
1199: ( p_api_version IN NUMBER,
1200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1203: x_return_status OUT NOCOPY VARCHAR2,
1204: x_msg_count OUT NOCOPY NUMBER,
1205: x_msg_data OUT NOCOPY VARCHAR2,
1206: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1206: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1203: x_return_status OUT NOCOPY VARCHAR2,
1204: x_msg_count OUT NOCOPY NUMBER,
1205: x_msg_data OUT NOCOPY VARCHAR2,
1206: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1207: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1208: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
1209: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1210: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 1209: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

1205: x_msg_data OUT NOCOPY VARCHAR2,
1206: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1207: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1208: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
1209: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1210: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
1211: )
1212: IS
1213: l_api_name CONSTANT VARCHAR2(30) := 'Sort_Category';

Line 1210: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR

1206: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1207: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1208: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
1209: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1210: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
1211: )
1212: IS
1213: l_api_name CONSTANT VARCHAR2(30) := 'Sort_Category';
1214: l_api_version CONSTANT NUMBER := 1.0;

Line 1257: IF NOT FND_API.Compatible_API_Call (

1253: BEGIN
1254: -- Standard begin of API savepoint
1255: SAVEPOINT Sort_Category_PVT;
1256: -- Standard call to check for call compatibility.
1257: IF NOT FND_API.Compatible_API_Call (
1258: l_api_version,
1259: p_api_version,
1260: l_api_name,
1261: G_PKG_NAME)

Line 1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1259: p_api_version,
1260: l_api_name,
1261: G_PKG_NAME)
1262: THEN
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: END IF;
1265: -- Debug Message
1266: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1267: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 1272: IF FND_API.To_Boolean (p_init_msg_list) THEN

1268: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1269: FND_MSG_PUB.Add;
1270: END IF;
1271: --Initialize message list if p_init_msg_list is TRUE.
1272: IF FND_API.To_Boolean (p_init_msg_list) THEN
1273: FND_MSG_PUB.initialize;
1274: END IF;
1275: -- Get the current (login) user id.
1276: AMV_UTILITY_PVT.Get_UserInfo(

Line 1283: IF (p_check_login_user = FND_API.G_TRUE) THEN

1279: x_login_id => l_login_user_id,
1280: x_user_status => l_login_user_status
1281: );
1282: -- check login user
1283: IF (p_check_login_user = FND_API.G_TRUE) THEN
1284: -- Check if user is login and has the required privilege.
1285: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1286: -- User is not login.
1287: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1285: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

1281: );
1282: -- check login user
1283: IF (p_check_login_user = FND_API.G_TRUE) THEN
1284: -- Check if user is login and has the required privilege.
1285: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1286: -- User is not login.
1287: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1288: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1289: FND_MSG_PUB.Add;

Line 1291: RAISE FND_API.G_EXC_ERROR;

1287: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1288: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1289: FND_MSG_PUB.Add;
1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;
1292: END IF;
1293: END IF;
1294: -- This fix is for executing api in sqlplus mode
1295: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 1295: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

1291: RAISE FND_API.G_EXC_ERROR;
1292: END IF;
1293: END IF;
1294: -- This fix is for executing api in sqlplus mode
1295: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1296: l_login_user_id := g_login_user_id;
1297: l_user_id := g_user_id;
1298: l_resource_id := g_resource_id;
1299: END IF;

Line 1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

1297: l_user_id := g_user_id;
1298: l_resource_id := g_resource_id;
1299: END IF;
1300: -- Initialize API return status to sucess
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;
1302:
1303: --
1304: Validate_CategoryStatus (
1305: x_return_status => x_return_status,

Line 1313: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1309: x_category_id => l_parent_category_id,
1310: x_error_msg => l_Error_Msg,
1311: x_error_token => l_Error_Token
1312: );
1313: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1314: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
1315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1316: THEN
1317: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);

Line 1314: IF (l_category_exist_flag = FND_API.G_FALSE) THEN

1310: x_error_msg => l_Error_Msg,
1311: x_error_token => l_Error_Token
1312: );
1313: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1314: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
1315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1316: THEN
1317: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1318: FND_MESSAGE.Set_Token('TKN',l_Error_Token);

Line 1321: RAISE FND_API.G_EXC_ERROR;

1317: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1318: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
1319: FND_MSG_PUB.Add;
1320: END IF;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323: ELSE
1324: x_return_status := FND_API.G_RET_STS_SUCCESS;
1325: END IF;

Line 1324: x_return_status := FND_API.G_RET_STS_SUCCESS;

1320: END IF;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323: ELSE
1324: x_return_status := FND_API.G_RET_STS_SUCCESS;
1325: END IF;
1326:
1327: IF l_parent_category_id = FND_API.G_MISS_NUM THEN
1328: OPEN Get_CategoryOrder;

Line 1327: IF l_parent_category_id = FND_API.G_MISS_NUM THEN

1323: ELSE
1324: x_return_status := FND_API.G_RET_STS_SUCCESS;
1325: END IF;
1326:
1327: IF l_parent_category_id = FND_API.G_MISS_NUM THEN
1328: OPEN Get_CategoryOrder;
1329: l_category_array := AMV_NUMBER_VARRAY_TYPE();
1330: LOOP
1331: FETCH Get_CategoryOrder INTO l_category_id;

Line 1388: RAISE FND_API.G_EXC_ERROR;

1384: FND_MESSAGE.Set_Token('ACTION', 'Sorting');
1385: FND_MESSAGE.Set_Token('TABLE', 'Categories');
1386: FND_MSG_PUB.Add;
1387: END IF;
1388: RAISE FND_API.G_EXC_ERROR;
1389: END;
1390: END LOOP;
1391: --
1392:

Line 1401: IF FND_API.To_Boolean ( p_commit ) THEN

1397: FND_MESSAGE.Set_Token('ROW', l_full_name);
1398: FND_MSG_PUB.Add;
1399: END IF;
1400: --Standard check of commit
1401: IF FND_API.To_Boolean ( p_commit ) THEN
1402: COMMIT WORK;
1403: END IF;
1404: -- Debug Message
1405: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1412: p_encoded => FND_API.G_FALSE,

1408: FND_MSG_PUB.Add;
1409: END IF;
1410: --Standard call to get message count and if count=1, get the message
1411: FND_MSG_PUB.Count_And_Get (
1412: p_encoded => FND_API.G_FALSE,
1413: p_count => x_msg_count,
1414: p_data => x_msg_data
1415: );
1416: EXCEPTION

Line 1417: WHEN FND_API.G_EXC_ERROR THEN

1413: p_count => x_msg_count,
1414: p_data => x_msg_data
1415: );
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: ROLLBACK TO Sort_Category_PVT;
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: -- Standard call to get message count and if count=1, get the message
1421: FND_MSG_PUB.Count_And_Get (

Line 1419: x_return_status := FND_API.G_RET_STS_ERROR;

1415: );
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: ROLLBACK TO Sort_Category_PVT;
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: -- Standard call to get message count and if count=1, get the message
1421: FND_MSG_PUB.Count_And_Get (
1422: p_encoded => FND_API.G_FALSE,
1423: p_count => x_msg_count,

Line 1422: p_encoded => FND_API.G_FALSE,

1418: ROLLBACK TO Sort_Category_PVT;
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: -- Standard call to get message count and if count=1, get the message
1421: FND_MSG_PUB.Count_And_Get (
1422: p_encoded => FND_API.G_FALSE,
1423: p_count => x_msg_count,
1424: p_data => x_msg_data
1425: );
1426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1422: p_encoded => FND_API.G_FALSE,
1423: p_count => x_msg_count,
1424: p_data => x_msg_data
1425: );
1426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1427: ROLLBACK TO Sort_Category_PVT;
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: -- Standard call to get message count and if count=1, get the message
1430: FND_MSG_PUB.Count_And_Get (

Line 1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1424: p_data => x_msg_data
1425: );
1426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1427: ROLLBACK TO Sort_Category_PVT;
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: -- Standard call to get message count and if count=1, get the message
1430: FND_MSG_PUB.Count_And_Get (
1431: p_encoded => FND_API.G_FALSE,
1432: p_count => x_msg_count,

Line 1431: p_encoded => FND_API.G_FALSE,

1427: ROLLBACK TO Sort_Category_PVT;
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: -- Standard call to get message count and if count=1, get the message
1430: FND_MSG_PUB.Count_And_Get (
1431: p_encoded => FND_API.G_FALSE,
1432: p_count => x_msg_count,
1433: p_data => x_msg_data
1434: );
1435: WHEN OTHERS THEN

Line 1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1433: p_data => x_msg_data
1434: );
1435: WHEN OTHERS THEN
1436: ROLLBACK TO Sort_Category_PVT;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1439: THEN
1440: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1441: END IF;

Line 1444: p_encoded => FND_API.G_FALSE,

1440: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1441: END IF;
1442: -- Standard call to get message count and if count=1, get the message
1443: FND_MSG_PUB.Count_And_Get (
1444: p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,
1446: p_data => x_msg_data
1447: );
1448: END Sort_Category;

Line 1459: -- Default = FND_API.G_FALSE

1455: -- Function : Reorder channel (sub)category list
1456: -- Parameters :
1457: -- IN p_api_version IN NUMBER Required
1458: -- p_init_msg_list IN VARCHAR2 Optional
1459: -- Default = FND_API.G_FALSE
1460: -- p_commit IN VARCHAR2 Optional
1461: -- Default = FND_API.G_FALSE
1462: -- p_validation_level NUMBER Optional
1463: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1461: -- Default = FND_API.G_FALSE

1457: -- IN p_api_version IN NUMBER Required
1458: -- p_init_msg_list IN VARCHAR2 Optional
1459: -- Default = FND_API.G_FALSE
1460: -- p_commit IN VARCHAR2 Optional
1461: -- Default = FND_API.G_FALSE
1462: -- p_validation_level NUMBER Optional
1463: -- Default = FND_API.G_VALID_LEVEL_FULL
1464: -- p_category_id_array IN AMV_NUMBER_VARRAY_TYPE
1465: -- Required

Line 1463: -- Default = FND_API.G_VALID_LEVEL_FULL

1459: -- Default = FND_API.G_FALSE
1460: -- p_commit IN VARCHAR2 Optional
1461: -- Default = FND_API.G_FALSE
1462: -- p_validation_level NUMBER Optional
1463: -- Default = FND_API.G_VALID_LEVEL_FULL
1464: -- p_category_id_array IN AMV_NUMBER_VARRAY_TYPE
1465: -- Required
1466: -- p_category_new_order IN AMV_NUMBER_VARRAY_TYPE
1467: -- Required

Line 1480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1476: -- End of comments
1477: --
1478: PROCEDURE Reorder_Category
1479: ( p_api_version IN NUMBER,
1480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1481: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1483: x_return_status OUT NOCOPY VARCHAR2,
1484: x_msg_count OUT NOCOPY NUMBER,

Line 1481: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1477: --
1478: PROCEDURE Reorder_Category
1479: ( p_api_version IN NUMBER,
1480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1481: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1483: x_return_status OUT NOCOPY VARCHAR2,
1484: x_msg_count OUT NOCOPY NUMBER,
1485: x_msg_data OUT NOCOPY VARCHAR2,

Line 1482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1478: PROCEDURE Reorder_Category
1479: ( p_api_version IN NUMBER,
1480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1481: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1483: x_return_status OUT NOCOPY VARCHAR2,
1484: x_msg_count OUT NOCOPY NUMBER,
1485: x_msg_data OUT NOCOPY VARCHAR2,
1486: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1486: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1483: x_return_status OUT NOCOPY VARCHAR2,
1484: x_msg_count OUT NOCOPY NUMBER,
1485: x_msg_data OUT NOCOPY VARCHAR2,
1486: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1487: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1488: p_category_id_array IN AMV_NUMBER_VARRAY_TYPE,
1489: p_category_new_order IN AMV_NUMBER_VARRAY_TYPE
1490: )

Line 1519: IF NOT FND_API.Compatible_API_Call (

1515: BEGIN
1516: -- Standard begin of API savepoint
1517: SAVEPOINT Reorder_Category_PVT;
1518: -- Standard call to check for call compatibility.
1519: IF NOT FND_API.Compatible_API_Call (
1520: l_api_version,
1521: p_api_version,
1522: l_api_name,
1523: G_PKG_NAME)

Line 1525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1521: p_api_version,
1522: l_api_name,
1523: G_PKG_NAME)
1524: THEN
1525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1526: END IF;
1527: -- Debug Message
1528: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1529: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 1534: IF FND_API.To_Boolean (p_init_msg_list) THEN

1530: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1531: FND_MSG_PUB.Add;
1532: END IF;
1533: --Initialize message list if p_init_msg_list is TRUE.
1534: IF FND_API.To_Boolean (p_init_msg_list) THEN
1535: FND_MSG_PUB.initialize;
1536: END IF;
1537: -- Get the current (login) user id.
1538: AMV_UTILITY_PVT.Get_UserInfo(

Line 1545: IF (p_check_login_user = FND_API.G_TRUE) THEN

1541: x_login_id => l_login_user_id,
1542: x_user_status => l_login_user_status
1543: );
1544: -- check login user
1545: IF (p_check_login_user = FND_API.G_TRUE) THEN
1546: -- Check if user is login and has the required privilege.
1547: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1548: -- User is not login.
1549: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1547: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

1543: );
1544: -- check login user
1545: IF (p_check_login_user = FND_API.G_TRUE) THEN
1546: -- Check if user is login and has the required privilege.
1547: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1548: -- User is not login.
1549: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1550: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1551: FND_MSG_PUB.Add;

Line 1553: RAISE FND_API.G_EXC_ERROR;

1549: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1550: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1551: FND_MSG_PUB.Add;
1552: END IF;
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555: END IF;
1556: -- This fix is for executing api in sqlplus mode
1557: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 1557: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555: END IF;
1556: -- This fix is for executing api in sqlplus mode
1557: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1558: l_login_user_id := g_login_user_id;
1559: l_user_id := g_user_id;
1560: l_resource_id := g_resource_id;
1561: END IF;

Line 1563: x_return_status := FND_API.G_RET_STS_SUCCESS;

1559: l_user_id := g_user_id;
1560: l_resource_id := g_resource_id;
1561: END IF;
1562: -- Initialize API return status to sucess
1563: x_return_status := FND_API.G_RET_STS_SUCCESS;
1564:
1565: --
1566: -- Check if the number of categories and new order count are same
1567: IF p_category_id_array.count = p_category_new_order.count THEN

Line 1599: RAISE FND_API.G_EXC_ERROR;

1595: FND_MESSAGE.Set_Token('ACTION', 'Reordering');
1596: FND_MESSAGE.Set_Token('TABLE', 'Categories');
1597: FND_MSG_PUB.Add;
1598: END IF;
1599: RAISE FND_API.G_EXC_ERROR;
1600: END;
1601: END LOOP;
1602: ELSE
1603: --Category count and new order count must be equal

Line 1609: RAISE FND_API.G_EXC_ERROR;

1605: THEN
1606: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_REORDER_ERROR');
1607: FND_MSG_PUB.Add;
1608: END IF;
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611: --
1612:
1613: -- Success message

Line 1621: IF FND_API.To_Boolean ( p_commit ) THEN

1617: FND_MESSAGE.Set_Token('ROW', l_full_name);
1618: FND_MSG_PUB.Add;
1619: END IF;
1620: --Standard check of commit
1621: IF FND_API.To_Boolean ( p_commit ) THEN
1622: COMMIT WORK;
1623: END IF;
1624: -- Debug Message
1625: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1632: p_encoded => FND_API.G_FALSE,

1628: FND_MSG_PUB.Add;
1629: END IF;
1630: --Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,
1633: p_count => x_msg_count,
1634: p_data => x_msg_data
1635: );
1636: EXCEPTION

Line 1637: WHEN FND_API.G_EXC_ERROR THEN

1633: p_count => x_msg_count,
1634: p_data => x_msg_data
1635: );
1636: EXCEPTION
1637: WHEN FND_API.G_EXC_ERROR THEN
1638: ROLLBACK TO Reorder_Category_PVT;
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: -- Standard call to get message count and if count=1, get the message
1641: FND_MSG_PUB.Count_And_Get (

Line 1639: x_return_status := FND_API.G_RET_STS_ERROR;

1635: );
1636: EXCEPTION
1637: WHEN FND_API.G_EXC_ERROR THEN
1638: ROLLBACK TO Reorder_Category_PVT;
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: -- Standard call to get message count and if count=1, get the message
1641: FND_MSG_PUB.Count_And_Get (
1642: p_encoded => FND_API.G_FALSE,
1643: p_count => x_msg_count,

Line 1642: p_encoded => FND_API.G_FALSE,

1638: ROLLBACK TO Reorder_Category_PVT;
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: -- Standard call to get message count and if count=1, get the message
1641: FND_MSG_PUB.Count_And_Get (
1642: p_encoded => FND_API.G_FALSE,
1643: p_count => x_msg_count,
1644: p_data => x_msg_data
1645: );
1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1642: p_encoded => FND_API.G_FALSE,
1643: p_count => x_msg_count,
1644: p_data => x_msg_data
1645: );
1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1647: ROLLBACK TO Reorder_Category_PVT;
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: -- Standard call to get message count and if count=1, get the message
1650: FND_MSG_PUB.Count_And_Get (

Line 1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1644: p_data => x_msg_data
1645: );
1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1647: ROLLBACK TO Reorder_Category_PVT;
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: -- Standard call to get message count and if count=1, get the message
1650: FND_MSG_PUB.Count_And_Get (
1651: p_encoded => FND_API.G_FALSE,
1652: p_count => x_msg_count,

Line 1651: p_encoded => FND_API.G_FALSE,

1647: ROLLBACK TO Reorder_Category_PVT;
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: -- Standard call to get message count and if count=1, get the message
1650: FND_MSG_PUB.Count_And_Get (
1651: p_encoded => FND_API.G_FALSE,
1652: p_count => x_msg_count,
1653: p_data => x_msg_data
1654: );
1655: WHEN OTHERS THEN

Line 1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1653: p_data => x_msg_data
1654: );
1655: WHEN OTHERS THEN
1656: ROLLBACK TO Reorder_Category_PVT;
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1659: THEN
1660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1661: END IF;

Line 1664: p_encoded => FND_API.G_FALSE,

1660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1661: END IF;
1662: -- Standard call to get message count and if count=1, get the message
1663: FND_MSG_PUB.Count_And_Get (
1664: p_encoded => FND_API.G_FALSE,
1665: p_count => x_msg_count,
1666: p_data => x_msg_data
1667: );
1668: --

Line 1679: -- Default = FND_API.G_FALSE

1675: -- Function : Update channel (sub)category given (sub)category id or name
1676: -- Parameters :
1677: -- IN p_api_version IN NUMBER Required
1678: -- p_init_msg_list IN VARCHAR2 Optional
1679: -- Default = FND_API.G_FALSE
1680: -- p_commit IN VARCHAR2 Optional
1681: -- Default = FND_API.G_FALSE
1682: -- p_validation_level IN NUMBER Optional
1683: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1681: -- Default = FND_API.G_FALSE

1677: -- IN p_api_version IN NUMBER Required
1678: -- p_init_msg_list IN VARCHAR2 Optional
1679: -- Default = FND_API.G_FALSE
1680: -- p_commit IN VARCHAR2 Optional
1681: -- Default = FND_API.G_FALSE
1682: -- p_validation_level IN NUMBER Optional
1683: -- Default = FND_API.G_VALID_LEVEL_FULL
1684: -- p_object_version_number IN NUMBER Required
1685: -- object version number

Line 1683: -- Default = FND_API.G_VALID_LEVEL_FULL

1679: -- Default = FND_API.G_FALSE
1680: -- p_commit IN VARCHAR2 Optional
1681: -- Default = FND_API.G_FALSE
1682: -- p_validation_level IN NUMBER Optional
1683: -- Default = FND_API.G_VALID_LEVEL_FULL
1684: -- p_object_version_number IN NUMBER Required
1685: -- object version number
1686: -- p_category_id IN NUMBER Optional
1687: -- channel category id.

Line 1692: -- Default = FND_API.G_MISS_NUM

1688: -- p_category_name IN VARCHAR2 Optional
1689: -- channel category name.
1690: -- (sub)category id or name is required
1691: -- p_parent_category_id IN NUMBER Optional
1692: -- Default = FND_API.G_MISS_NUM
1693: -- channel category id.
1694: -- p_parent_category_name IN VARCHAR2 Optional
1695: -- Default = FND_API.G_MISS_CHAR
1696: -- channel category name.

Line 1695: -- Default = FND_API.G_MISS_CHAR

1691: -- p_parent_category_id IN NUMBER Optional
1692: -- Default = FND_API.G_MISS_NUM
1693: -- channel category id.
1694: -- p_parent_category_name IN VARCHAR2 Optional
1695: -- Default = FND_API.G_MISS_CHAR
1696: -- channel category name.
1697: -- takes either parent id or name. id taken if both passed
1698: -- p_category_order IN NUMBER Optional
1699: -- new channel category order

Line 1703: -- Default = FND_API.G_MISS_CHAR

1699: -- new channel category order
1700: -- p_category_new_name IN VARCHAR2 Optional
1701: -- new channel category name. New name has to be unique
1702: -- p_description IN VARCHAR2 Optional
1703: -- Default = FND_API.G_MISS_CHAR
1704: -- channel category description.
1705: -- OUT : x_return_status OUT VARCHAR2
1706: -- x_msg_count OUT NUMBER
1707: -- x_msg_data OUT VARCHAR2

Line 1717: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1713: -- End of comments
1714: --
1715: PROCEDURE Update_Category
1716: ( p_api_version IN NUMBER,
1717: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1718: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1719: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1720: x_return_status OUT NOCOPY VARCHAR2,
1721: x_msg_count OUT NOCOPY NUMBER,

Line 1718: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1714: --
1715: PROCEDURE Update_Category
1716: ( p_api_version IN NUMBER,
1717: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1718: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1719: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1720: x_return_status OUT NOCOPY VARCHAR2,
1721: x_msg_count OUT NOCOPY NUMBER,
1722: x_msg_data OUT NOCOPY VARCHAR2,

Line 1719: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1715: PROCEDURE Update_Category
1716: ( p_api_version IN NUMBER,
1717: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1718: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1719: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1720: x_return_status OUT NOCOPY VARCHAR2,
1721: x_msg_count OUT NOCOPY NUMBER,
1722: x_msg_data OUT NOCOPY VARCHAR2,
1723: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 1723: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1719: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1720: x_return_status OUT NOCOPY VARCHAR2,
1721: x_msg_count OUT NOCOPY NUMBER,
1722: x_msg_data OUT NOCOPY VARCHAR2,
1723: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1724: p_object_version_number IN NUMBER,
1725: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1726: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1727: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1726: p_category_id IN NUMBER := FND_API.G_MISS_NUM,

1722: x_msg_data OUT NOCOPY VARCHAR2,
1723: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1724: p_object_version_number IN NUMBER,
1725: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1726: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1727: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1728: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1729: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1730: p_category_order IN NUMBER := FND_API.G_MISS_NUM,

Line 1727: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1723: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1724: p_object_version_number IN NUMBER,
1725: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1726: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1727: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1728: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1729: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1730: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
1731: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1728: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

1724: p_object_version_number IN NUMBER,
1725: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1726: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1727: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1728: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1729: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1730: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
1731: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1732: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 1729: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1725: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1726: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1727: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1728: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1729: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1730: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
1731: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1732: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
1733: )

Line 1730: p_category_order IN NUMBER := FND_API.G_MISS_NUM,

1726: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
1727: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1728: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1729: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1730: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
1731: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1732: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
1733: )
1734: IS

Line 1731: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1727: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1728: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1729: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1730: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
1731: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1732: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
1733: )
1734: IS
1735: l_api_name CONSTANT VARCHAR2(30) := 'Update_Category';

Line 1732: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

1728: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
1729: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1730: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
1731: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1732: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
1733: )
1734: IS
1735: l_api_name CONSTANT VARCHAR2(30) := 'Update_Category';
1736: l_api_version CONSTANT NUMBER := 1.0;

Line 1780: IF NOT FND_API.Compatible_API_Call (

1776: BEGIN
1777: -- Standard begin of API savepoint
1778: SAVEPOINT Update_Category_PVT;
1779: -- Standard call to check for call compatibility.
1780: IF NOT FND_API.Compatible_API_Call (
1781: l_api_version,
1782: p_api_version,
1783: l_api_name,
1784: G_PKG_NAME)

Line 1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1782: p_api_version,
1783: l_api_name,
1784: G_PKG_NAME)
1785: THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;
1788: -- Debug Message
1789: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1790: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 1795: IF FND_API.To_Boolean (p_init_msg_list) THEN

1791: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1792: FND_MSG_PUB.Add;
1793: END IF;
1794: --Initialize message list if p_init_msg_list is TRUE.
1795: IF FND_API.To_Boolean (p_init_msg_list) THEN
1796: FND_MSG_PUB.initialize;
1797: END IF;
1798: -- Get the current (login) user id.
1799: AMV_UTILITY_PVT.Get_UserInfo(

Line 1806: IF (p_check_login_user = FND_API.G_TRUE) THEN

1802: x_login_id => l_login_user_id,
1803: x_user_status => l_login_user_status
1804: );
1805: -- check login user
1806: IF (p_check_login_user = FND_API.G_TRUE) THEN
1807: -- Check if user is login and has the required privilege.
1808: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1809: -- User is not login.
1810: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1808: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

1804: );
1805: -- check login user
1806: IF (p_check_login_user = FND_API.G_TRUE) THEN
1807: -- Check if user is login and has the required privilege.
1808: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1809: -- User is not login.
1810: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1811: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1812: FND_MSG_PUB.Add;

Line 1814: RAISE FND_API.G_EXC_ERROR;

1810: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1811: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1812: FND_MSG_PUB.Add;
1813: END IF;
1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF;
1816: END IF;
1817: -- This fix is for executing api in sqlplus mode
1818: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 1818: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF;
1816: END IF;
1817: -- This fix is for executing api in sqlplus mode
1818: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1819: l_login_user_id := g_login_user_id;
1820: l_user_id := g_user_id;
1821: l_resource_id := g_resource_id;
1822: END IF;

Line 1824: x_return_status := FND_API.G_RET_STS_SUCCESS;

1820: l_user_id := g_user_id;
1821: l_resource_id := g_resource_id;
1822: END IF;
1823: -- Initialize API return status to sucess
1824: x_return_status := FND_API.G_RET_STS_SUCCESS;
1825:
1826: -- check if the (sub)category id/name are valid and get (sub)category id
1827: Validate_CategoryStatus(
1828: x_return_status => x_return_status,

Line 1838: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1834: x_category_id => l_category_id,
1835: x_error_msg => l_Error_Msg,
1836: x_error_token => l_Error_Token
1837: );
1838: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1839: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
1840: -- (sub)catgeory id or name is not valid
1841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1842: THEN

Line 1839: IF (l_category_exist_flag = FND_API.G_FALSE) THEN

1835: x_error_msg => l_Error_Msg,
1836: x_error_token => l_Error_Token
1837: );
1838: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1839: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
1840: -- (sub)catgeory id or name is not valid
1841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1842: THEN
1843: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);

Line 1847: RAISE FND_API.G_EXC_ERROR;

1843: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1844: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
1845: FND_MSG_PUB.Add;
1846: END IF;
1847: RAISE FND_API.G_EXC_ERROR;
1848: END IF;
1849: ELSE
1850: -- setting the flag to success for checking again
1851: -- NOTE check this flag setting again

Line 1852: x_return_status := FND_API.G_RET_STS_SUCCESS;

1848: END IF;
1849: ELSE
1850: -- setting the flag to success for checking again
1851: -- NOTE check this flag setting again
1852: x_return_status := FND_API.G_RET_STS_SUCCESS;
1853: END IF;
1854:
1855: -- get the current (sub)category name
1856: l_category_current_name := Get_CategoryName(l_category_id);

Line 1858: IF p_category_new_name <> FND_API.G_MISS_CHAR THEN

1854:
1855: -- get the current (sub)category name
1856: l_category_current_name := Get_CategoryName(l_category_id);
1857:
1858: IF p_category_new_name <> FND_API.G_MISS_CHAR THEN
1859: -- check new name if current and new (sub)category are not same
1860: IF UPPER(p_category_new_name) <> UPPER(l_category_current_name) THEN
1861: -- get parent category id if parent name is passed
1862: IF p_parent_category_id <> FND_API.G_MISS_NUM THEN

Line 1862: IF p_parent_category_id <> FND_API.G_MISS_NUM THEN

1858: IF p_category_new_name <> FND_API.G_MISS_CHAR THEN
1859: -- check new name if current and new (sub)category are not same
1860: IF UPPER(p_category_new_name) <> UPPER(l_category_current_name) THEN
1861: -- get parent category id if parent name is passed
1862: IF p_parent_category_id <> FND_API.G_MISS_NUM THEN
1863: l_parent_category_id := p_parent_category_id;
1864: ELSE
1865: l_parent_category_id := Get_CategoryId(p_parent_category_name);
1866: END IF;

Line 1880: l_category_exist_flag := FND_API.G_FALSE;

1876: );
1877:
1878: l_category_current_name := p_category_new_name;
1879: ELSE
1880: l_category_exist_flag := FND_API.G_FALSE;
1881: END IF;
1882: ELSE
1883: l_category_exist_flag := FND_API.G_FALSE;
1884: END IF;

Line 1883: l_category_exist_flag := FND_API.G_FALSE;

1879: ELSE
1880: l_category_exist_flag := FND_API.G_FALSE;
1881: END IF;
1882: ELSE
1883: l_category_exist_flag := FND_API.G_FALSE;
1884: END IF;
1885: --
1886:
1887: -- update category if it does not exist

Line 1888: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1884: END IF;
1885: --
1886:
1887: -- update category if it does not exist
1888: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1889: IF (l_category_exist_flag = FND_API.G_TRUE) THEN
1890: -- (sub)category with the new name already exists
1891: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1892: THEN

Line 1889: IF (l_category_exist_flag = FND_API.G_TRUE) THEN

1885: --
1886:
1887: -- update category if it does not exist
1888: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1889: IF (l_category_exist_flag = FND_API.G_TRUE) THEN
1890: -- (sub)category with the new name already exists
1891: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1892: THEN
1893: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);

Line 1897: RAISE FND_API.G_EXC_ERROR;

1893: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1894: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
1895: FND_MSG_PUB.Add;
1896: END IF;
1897: RAISE FND_API.G_EXC_ERROR;
1898: ELSE
1899: --
1900: -- check if the user has privilege to update category
1901: AMV_USER_PVT.Can_SetupCategory (

Line 1903: p_init_msg_list => FND_API.G_FALSE,

1899: --
1900: -- check if the user has privilege to update category
1901: AMV_USER_PVT.Can_SetupCategory (
1902: p_api_version => l_api_version,
1903: p_init_msg_list => FND_API.G_FALSE,
1904: p_validation_level => p_validation_level,
1905: x_return_status => x_return_status,
1906: x_msg_count => x_msg_count,
1907: x_msg_data => x_msg_data,

Line 1908: p_check_login_user => FND_API.G_FALSE,

1904: p_validation_level => p_validation_level,
1905: x_return_status => x_return_status,
1906: x_msg_count => x_msg_count,
1907: x_msg_data => x_msg_data,
1908: p_check_login_user => FND_API.G_FALSE,
1909: p_resource_id => l_resource_id,
1910: p_include_group_flag => FND_API.G_TRUE,
1911: x_result_flag => l_setup_result
1912: );

Line 1910: p_include_group_flag => FND_API.G_TRUE,

1906: x_msg_count => x_msg_count,
1907: x_msg_data => x_msg_data,
1908: p_check_login_user => FND_API.G_FALSE,
1909: p_resource_id => l_resource_id,
1910: p_include_group_flag => FND_API.G_TRUE,
1911: x_result_flag => l_setup_result
1912: );
1913:
1914: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1914: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1910: p_include_group_flag => FND_API.G_TRUE,
1911: x_result_flag => l_setup_result
1912: );
1913:
1914: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1915: IF (l_setup_result = FND_API.G_TRUE) THEN
1916: l_update_category_flag := FND_API.G_TRUE;
1917: ELSE
1918: IF (AMV_UTILITY_PVT.Get_UpdateCategoryStatus(

Line 1915: IF (l_setup_result = FND_API.G_TRUE) THEN

1911: x_result_flag => l_setup_result
1912: );
1913:
1914: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1915: IF (l_setup_result = FND_API.G_TRUE) THEN
1916: l_update_category_flag := FND_API.G_TRUE;
1917: ELSE
1918: IF (AMV_UTILITY_PVT.Get_UpdateCategoryStatus(
1919: l_category_id,

Line 1916: l_update_category_flag := FND_API.G_TRUE;

1912: );
1913:
1914: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1915: IF (l_setup_result = FND_API.G_TRUE) THEN
1916: l_update_category_flag := FND_API.G_TRUE;
1917: ELSE
1918: IF (AMV_UTILITY_PVT.Get_UpdateCategoryStatus(
1919: l_category_id,
1920: l_resource_id,

Line 1923: l_update_category_flag := FND_API.G_TRUE;

1919: l_category_id,
1920: l_resource_id,
1921: AMV_UTILITY_PVT.G_USER) )
1922: THEN
1923: l_update_category_flag := FND_API.G_TRUE;
1924: ELSE
1925: -- user does not have privilege to create category
1926: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1927: THEN

Line 1932: RAISE FND_API.G_EXC_ERROR;

1928: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1929: FND_MESSAGE.Set_Token('LEVEL','Category');
1930: FND_MSG_PUB.Add;
1931: END IF;
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: END IF;
1935: ELSE
1936: -- error while user privilege check in Can_SetupCategory

Line 1943: RAISE FND_API.G_EXC_ERROR;

1939: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1940: FND_MESSAGE.Set_Token('LEVEL','Category');
1941: FND_MSG_PUB.Add;
1942: END IF;
1943: RAISE FND_API.G_EXC_ERROR;
1944: END IF;
1945: --
1946:
1947: --

Line 1948: IF l_update_category_flag = FND_API.G_TRUE THEN

1944: END IF;
1945: --
1946:
1947: --
1948: IF l_update_category_flag = FND_API.G_TRUE THEN
1949: -- get the category record in database
1950: OPEN Get_CatRec_csr;
1951: FETCH Get_CatRec_csr INTO l_object_version_number,
1952: l_application_id,

Line 1963: IF p_category_order <> FND_API.G_MISS_NUM THEN

1959: FETCH Get_CatDesc_csr INTO l_description;
1960: CLOSE Get_CatDesc_csr;
1961:
1962: -- check category order
1963: IF p_category_order <> FND_API.G_MISS_NUM THEN
1964: l_category_order := p_category_order;
1965: END IF;
1966:
1967: -- check category description

Line 1968: IF p_description <> FND_API.G_MISS_CHAR THEN

1964: l_category_order := p_category_order;
1965: END IF;
1966:
1967: -- check category description
1968: IF p_description <> FND_API.G_MISS_CHAR THEN
1969: l_description := p_description;
1970: END IF;
1971:
1972: -- update if the version is greater equal to one in db

Line 1998: RAISE FND_API.G_EXC_ERROR;

1994: FND_MESSAGE.Set_Token('ACTION', 'Updating');
1995: FND_MESSAGE.Set_Token('TABLE', 'Categories');
1996: FND_MSG_PUB.Add;
1997: END IF;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END;
2000: ELSE
2001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2002: THEN

Line 2006: RAISE FND_API.G_EXC_ERROR;

2002: THEN
2003: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');
2004: FND_MSG_PUB.Add;
2005: END IF;
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008: END IF;
2009: END IF;
2010: --

Line 2018: RAISE FND_API.G_EXC_ERROR;

2014: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2015: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2016: FND_MSG_PUB.Add;
2017: END IF;
2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;
2020: --
2021:
2022: -- Success message

Line 2030: IF FND_API.To_Boolean ( p_commit ) THEN

2026: FND_MESSAGE.Set_Token('ROW', l_full_name);
2027: FND_MSG_PUB.Add;
2028: END IF;
2029: --Standard check of commit
2030: IF FND_API.To_Boolean ( p_commit ) THEN
2031: COMMIT WORK;
2032: END IF;
2033: -- Debug Message
2034: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 2041: p_encoded => FND_API.G_FALSE,

2037: FND_MSG_PUB.Add;
2038: END IF;
2039: --Standard call to get message count and if count=1, get the message
2040: FND_MSG_PUB.Count_And_Get (
2041: p_encoded => FND_API.G_FALSE,
2042: p_count => x_msg_count,
2043: p_data => x_msg_data
2044: );
2045: EXCEPTION

Line 2046: WHEN FND_API.G_EXC_ERROR THEN

2042: p_count => x_msg_count,
2043: p_data => x_msg_data
2044: );
2045: EXCEPTION
2046: WHEN FND_API.G_EXC_ERROR THEN
2047: ROLLBACK TO Update_Category_PVT;
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: -- Standard call to get message count and if count=1, get the message
2050: FND_MSG_PUB.Count_And_Get (

Line 2048: x_return_status := FND_API.G_RET_STS_ERROR;

2044: );
2045: EXCEPTION
2046: WHEN FND_API.G_EXC_ERROR THEN
2047: ROLLBACK TO Update_Category_PVT;
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: -- Standard call to get message count and if count=1, get the message
2050: FND_MSG_PUB.Count_And_Get (
2051: p_encoded => FND_API.G_FALSE,
2052: p_count => x_msg_count,

Line 2051: p_encoded => FND_API.G_FALSE,

2047: ROLLBACK TO Update_Category_PVT;
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: -- Standard call to get message count and if count=1, get the message
2050: FND_MSG_PUB.Count_And_Get (
2051: p_encoded => FND_API.G_FALSE,
2052: p_count => x_msg_count,
2053: p_data => x_msg_data
2054: );
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2051: p_encoded => FND_API.G_FALSE,
2052: p_count => x_msg_count,
2053: p_data => x_msg_data
2054: );
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2056: ROLLBACK TO Update_Category_PVT;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: -- Standard call to get message count and if count=1, get the message
2059: FND_MSG_PUB.Count_And_Get (

Line 2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2053: p_data => x_msg_data
2054: );
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2056: ROLLBACK TO Update_Category_PVT;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: -- Standard call to get message count and if count=1, get the message
2059: FND_MSG_PUB.Count_And_Get (
2060: p_encoded => FND_API.G_FALSE,
2061: p_count => x_msg_count,

Line 2060: p_encoded => FND_API.G_FALSE,

2056: ROLLBACK TO Update_Category_PVT;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: -- Standard call to get message count and if count=1, get the message
2059: FND_MSG_PUB.Count_And_Get (
2060: p_encoded => FND_API.G_FALSE,
2061: p_count => x_msg_count,
2062: p_data => x_msg_data
2063: );
2064: WHEN OTHERS THEN

Line 2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2062: p_data => x_msg_data
2063: );
2064: WHEN OTHERS THEN
2065: ROLLBACK TO Update_Category_PVT;
2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2067: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2068: THEN
2069: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2070: END IF;

Line 2073: p_encoded => FND_API.G_FALSE,

2069: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2070: END IF;
2071: -- Standard call to get message count and if count=1, get the message
2072: FND_MSG_PUB.Count_And_Get (
2073: p_encoded => FND_API.G_FALSE,
2074: p_count => x_msg_count,
2075: p_data => x_msg_data
2076: );
2077: --

Line 2088: -- Default = FND_API.G_FALSE

2084: -- Function : Search and return channel (sub)categories
2085: -- Parameters
2086: -- IN p_api_version IN NUMBER Required
2087: -- p_init_msg_list IN VARCHAR2 Optional
2088: -- Default = FND_API.G_FALSE
2089: -- p_validation_level IN NUMBER Optional
2090: -- Default = FND_API.G_VALID_LEVEL_FULL
2091: -- p_application_id IN NUMBER Optional
2092: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)

Line 2090: -- Default = FND_API.G_VALID_LEVEL_FULL

2086: -- IN p_api_version IN NUMBER Required
2087: -- p_init_msg_list IN VARCHAR2 Optional
2088: -- Default = FND_API.G_FALSE
2089: -- p_validation_level IN NUMBER Optional
2090: -- Default = FND_API.G_VALID_LEVEL_FULL
2091: -- p_application_id IN NUMBER Optional
2092: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)
2093: -- application creating the channel
2094: -- p_category_name IN VARCHAR2 Optional

Line 2097: -- Default = FND_API.G_MISS_NUM

2093: -- application creating the channel
2094: -- p_category_name IN VARCHAR2 Optional
2095: -- Search criteria by name. Default = '%' (everything)
2096: -- p_parent_category_id IN NUMBER Optional
2097: -- Default = FND_API.G_MISS_NUM
2098: -- parent id for sub categories
2099: -- p_parent_category_name IN VARCHAR2 Optional
2100: -- Default = FND_API.G_MISS_CHAR
2101: -- parent name for sub categories

Line 2100: -- Default = FND_API.G_MISS_CHAR

2096: -- p_parent_category_id IN NUMBER Optional
2097: -- Default = FND_API.G_MISS_NUM
2098: -- parent id for sub categories
2099: -- p_parent_category_name IN VARCHAR2 Optional
2100: -- Default = FND_API.G_MISS_CHAR
2101: -- parent name for sub categories
2102: -- takes either parent id or name. id taken if both passed
2103: -- OUT : x_return_status OUT VARCHAR2
2104: -- x_msg_count OUT NUMBER

Line 2116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2112: -- End of comments
2113: --
2114: PROCEDURE Find_Categories
2115: ( p_api_version IN NUMBER,
2116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2118: x_return_status OUT NOCOPY VARCHAR2,
2119: x_msg_count OUT NOCOPY NUMBER,
2120: x_msg_data OUT NOCOPY VARCHAR2,

Line 2117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2113: --
2114: PROCEDURE Find_Categories
2115: ( p_api_version IN NUMBER,
2116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2118: x_return_status OUT NOCOPY VARCHAR2,
2119: x_msg_count OUT NOCOPY NUMBER,
2120: x_msg_data OUT NOCOPY VARCHAR2,
2121: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2121: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2118: x_return_status OUT NOCOPY VARCHAR2,
2119: x_msg_count OUT NOCOPY NUMBER,
2120: x_msg_data OUT NOCOPY VARCHAR2,
2121: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2122: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
2123: p_category_name IN VARCHAR2 := '%',
2124: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
2125: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 2124: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

2120: x_msg_data OUT NOCOPY VARCHAR2,
2121: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2122: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
2123: p_category_name IN VARCHAR2 := '%',
2124: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
2125: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
2126: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
2127: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
2128: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 2125: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

2121: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2122: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
2123: p_category_name IN VARCHAR2 := '%',
2124: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
2125: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
2126: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
2127: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
2128: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
2129: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_VARRAY_TYPE

Line 2126: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,

2122: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
2123: p_category_name IN VARCHAR2 := '%',
2124: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
2125: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
2126: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
2127: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
2128: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
2129: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_VARRAY_TYPE
2130: )

Line 2233: IF NOT FND_API.Compatible_API_Call (

2229: BEGIN
2230: -- Standard begin of API savepoint
2231: SAVEPOINT Find_Categories_PVT;
2232: -- Standard call to check for call compatibility.
2233: IF NOT FND_API.Compatible_API_Call (
2234: l_api_version,
2235: p_api_version,
2236: l_api_name,
2237: G_PKG_NAME)

Line 2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2235: p_api_version,
2236: l_api_name,
2237: G_PKG_NAME)
2238: THEN
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240: END IF;
2241: -- Debug Message
2242: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2243: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 2248: IF FND_API.To_Boolean (p_init_msg_list) THEN

2244: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2245: FND_MSG_PUB.Add;
2246: END IF;
2247: --Initialize message list if p_init_msg_list is TRUE.
2248: IF FND_API.To_Boolean (p_init_msg_list) THEN
2249: FND_MSG_PUB.initialize;
2250: END IF;
2251: -- Get the current (login) user id.
2252: AMV_UTILITY_PVT.Get_UserInfo(

Line 2259: IF (p_check_login_user = FND_API.G_TRUE) THEN

2255: x_login_id => l_login_user_id,
2256: x_user_status => l_login_user_status
2257: );
2258: -- check login user
2259: IF (p_check_login_user = FND_API.G_TRUE) THEN
2260: -- Check if user is login and has the required privilege.
2261: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2262: -- User is not login.
2263: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2261: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

2257: );
2258: -- check login user
2259: IF (p_check_login_user = FND_API.G_TRUE) THEN
2260: -- Check if user is login and has the required privilege.
2261: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2262: -- User is not login.
2263: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2264: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2265: FND_MSG_PUB.Add;

Line 2267: RAISE FND_API.G_EXC_ERROR;

2263: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2264: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2265: FND_MSG_PUB.Add;
2266: END IF;
2267: RAISE FND_API.G_EXC_ERROR;
2268: END IF;
2269: END IF;
2270: -- This fix is for executing api in sqlplus mode
2271: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 2271: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

2267: RAISE FND_API.G_EXC_ERROR;
2268: END IF;
2269: END IF;
2270: -- This fix is for executing api in sqlplus mode
2271: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2272: l_login_user_id := g_login_user_id;
2273: l_user_id := g_user_id;
2274: l_resource_id := g_resource_id;
2275: END IF;

Line 2277: x_return_status := FND_API.G_RET_STS_SUCCESS;

2273: l_user_id := g_user_id;
2274: l_resource_id := g_resource_id;
2275: END IF;
2276: -- Initialize API return status to sucess
2277: x_return_status := FND_API.G_RET_STS_SUCCESS;
2278:
2279: --
2280: -- check parent category name or id and get parent category id
2281: Validate_CategoryStatus (

Line 2290: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2286: x_category_id => l_parent_category_id,
2287: x_error_msg => l_Error_Msg,
2288: x_error_token => l_Error_Token
2289: );
2290: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2291: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
2292: -- parent id or name is not valid
2293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2294: THEN

Line 2291: IF (l_category_exist_flag = FND_API.G_FALSE) THEN

2287: x_error_msg => l_Error_Msg,
2288: x_error_token => l_Error_Token
2289: );
2290: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2291: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
2292: -- parent id or name is not valid
2293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2294: THEN
2295: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);

Line 2299: RAISE FND_API.G_EXC_ERROR;

2295: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2296: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2297: FND_MSG_PUB.Add;
2298: END IF;
2299: RAISE FND_API.G_EXC_ERROR;
2300: END IF;
2301: ELSE
2302: -- parent id or name is valid
2303: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2303: x_return_status := FND_API.G_RET_STS_SUCCESS;

2299: RAISE FND_API.G_EXC_ERROR;
2300: END IF;
2301: ELSE
2302: -- parent id or name is valid
2303: x_return_status := FND_API.G_RET_STS_SUCCESS;
2304: END IF;
2305:
2306: IF p_ignore_hierarchy = FND_API.G_TRUE THEN
2307: -- fetch all categories

Line 2306: IF p_ignore_hierarchy = FND_API.G_TRUE THEN

2302: -- parent id or name is valid
2303: x_return_status := FND_API.G_RET_STS_SUCCESS;
2304: END IF;
2305:
2306: IF p_ignore_hierarchy = FND_API.G_TRUE THEN
2307: -- fetch all categories
2308: OPEN Get_AllCategories;
2309: x_chan_category_rec_array := AMV_CATEGORY_VARRAY_TYPE();
2310: LOOP

Line 2365: IF l_parent_category_id = FND_API.G_MISS_NUM OR

2361: END IF;
2362: END LOOP;
2363: CLOSE Get_AllCategories;
2364: ELSE
2365: IF l_parent_category_id = FND_API.G_MISS_NUM OR
2366: l_parent_category_id IS NULL
2367: THEN
2368: -- fetch all root level categories
2369: OPEN Get_Categories;

Line 2504: p_encoded => FND_API.G_FALSE,

2500: FND_MSG_PUB.Add;
2501: END IF;
2502: --Standard call to get message count and if count=1, get the message
2503: FND_MSG_PUB.Count_And_Get (
2504: p_encoded => FND_API.G_FALSE,
2505: p_count => x_msg_count,
2506: p_data => x_msg_data
2507: );
2508: EXCEPTION

Line 2509: WHEN FND_API.G_EXC_ERROR THEN

2505: p_count => x_msg_count,
2506: p_data => x_msg_data
2507: );
2508: EXCEPTION
2509: WHEN FND_API.G_EXC_ERROR THEN
2510: ROLLBACK TO Find_Categories_PVT;
2511: x_return_status := FND_API.G_RET_STS_ERROR;
2512: -- Standard call to get message count and if count=1, get the message
2513: FND_MSG_PUB.Count_And_Get (

Line 2511: x_return_status := FND_API.G_RET_STS_ERROR;

2507: );
2508: EXCEPTION
2509: WHEN FND_API.G_EXC_ERROR THEN
2510: ROLLBACK TO Find_Categories_PVT;
2511: x_return_status := FND_API.G_RET_STS_ERROR;
2512: -- Standard call to get message count and if count=1, get the message
2513: FND_MSG_PUB.Count_And_Get (
2514: p_encoded => FND_API.G_FALSE,
2515: p_count => x_msg_count,

Line 2514: p_encoded => FND_API.G_FALSE,

2510: ROLLBACK TO Find_Categories_PVT;
2511: x_return_status := FND_API.G_RET_STS_ERROR;
2512: -- Standard call to get message count and if count=1, get the message
2513: FND_MSG_PUB.Count_And_Get (
2514: p_encoded => FND_API.G_FALSE,
2515: p_count => x_msg_count,
2516: p_data => x_msg_data
2517: );
2518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2514: p_encoded => FND_API.G_FALSE,
2515: p_count => x_msg_count,
2516: p_data => x_msg_data
2517: );
2518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2519: ROLLBACK TO Find_Categories_PVT;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: -- Standard call to get message count and if count=1, get the message
2522: FND_MSG_PUB.Count_And_Get (

Line 2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2516: p_data => x_msg_data
2517: );
2518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2519: ROLLBACK TO Find_Categories_PVT;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: -- Standard call to get message count and if count=1, get the message
2522: FND_MSG_PUB.Count_And_Get (
2523: p_encoded => FND_API.G_FALSE,
2524: p_count => x_msg_count,

Line 2523: p_encoded => FND_API.G_FALSE,

2519: ROLLBACK TO Find_Categories_PVT;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: -- Standard call to get message count and if count=1, get the message
2522: FND_MSG_PUB.Count_And_Get (
2523: p_encoded => FND_API.G_FALSE,
2524: p_count => x_msg_count,
2525: p_data => x_msg_data
2526: );
2527: WHEN OTHERS THEN

Line 2529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2525: p_data => x_msg_data
2526: );
2527: WHEN OTHERS THEN
2528: ROLLBACK TO Find_Categories_PVT;
2529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2531: THEN
2532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2533: END IF;

Line 2536: p_encoded => FND_API.G_FALSE,

2532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2533: END IF;
2534: -- Standard call to get message count and if count=1, get the message
2535: FND_MSG_PUB.Count_And_Get (
2536: p_encoded => FND_API.G_FALSE,
2537: p_count => x_msg_count,
2538: p_data => x_msg_data
2539: );
2540: --

Line 2552: -- Default = FND_API.G_FALSE

2548: -- a content channel (sub)category
2549: -- Parameters :
2550: -- IN p_api_version IN NUMBER Required
2551: -- p_init_msg_list IN VARCHAR2 Optional
2552: -- Default = FND_API.G_FALSE
2553: -- p_validation_level IN NUMBER Optional
2554: -- Default = FND_API.G_VALID_LEVEL_FULL
2555: -- p_category_id IN NUMBER Required
2556: -- p_include_subcats IN VARCHAR2 Optional

Line 2554: -- Default = FND_API.G_VALID_LEVEL_FULL

2550: -- IN p_api_version IN NUMBER Required
2551: -- p_init_msg_list IN VARCHAR2 Optional
2552: -- Default = FND_API.G_FALSE
2553: -- p_validation_level IN NUMBER Optional
2554: -- Default = FND_API.G_VALID_LEVEL_FULL
2555: -- p_category_id IN NUMBER Required
2556: -- p_include_subcats IN VARCHAR2 Optional
2557: -- Default = FND_API.G_FALSE
2558: -- OUT : x_return_status OUT VARCHAR2

Line 2557: -- Default = FND_API.G_FALSE

2553: -- p_validation_level IN NUMBER Optional
2554: -- Default = FND_API.G_VALID_LEVEL_FULL
2555: -- p_category_id IN NUMBER Required
2556: -- p_include_subcats IN VARCHAR2 Optional
2557: -- Default = FND_API.G_FALSE
2558: -- OUT : x_return_status OUT VARCHAR2
2559: -- x_msg_count OUT NUMBER
2560: -- x_msg_data OUT VARCHAR2
2561: -- x_content_chan_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

Line 2571: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2567: -- End of comments
2568: --
2569: PROCEDURE Get_ChannelsPerCategory
2570: ( p_api_version IN NUMBER,
2571: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2573: x_return_status OUT NOCOPY VARCHAR2,
2574: x_msg_count OUT NOCOPY NUMBER,
2575: x_msg_data OUT NOCOPY VARCHAR2,

Line 2572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2568: --
2569: PROCEDURE Get_ChannelsPerCategory
2570: ( p_api_version IN NUMBER,
2571: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2573: x_return_status OUT NOCOPY VARCHAR2,
2574: x_msg_count OUT NOCOPY NUMBER,
2575: x_msg_data OUT NOCOPY VARCHAR2,
2576: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2576: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2572: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2573: x_return_status OUT NOCOPY VARCHAR2,
2574: x_msg_count OUT NOCOPY NUMBER,
2575: x_msg_data OUT NOCOPY VARCHAR2,
2576: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2577: p_category_id IN NUMBER,
2578: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
2579: x_content_chan_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
2580: )

Line 2578: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

2574: x_msg_count OUT NOCOPY NUMBER,
2575: x_msg_data OUT NOCOPY VARCHAR2,
2576: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2577: p_category_id IN NUMBER,
2578: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
2579: x_content_chan_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
2580: )
2581: IS
2582: l_api_name CONSTANT VARCHAR2(30) := 'Get_ChannelsPerCategory';

Line 2616: IF NOT FND_API.Compatible_API_Call (

2612: BEGIN
2613: -- Standard begin of API savepoint
2614: SAVEPOINT Get_ChansPerCategory_PVT;
2615: -- Standard call to check for call compatibility.
2616: IF NOT FND_API.Compatible_API_Call (
2617: l_api_version,
2618: p_api_version,
2619: l_api_name,
2620: G_PKG_NAME)

Line 2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2618: p_api_version,
2619: l_api_name,
2620: G_PKG_NAME)
2621: THEN
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: END IF;
2624: -- Debug Message
2625: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2626: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 2631: IF FND_API.To_Boolean (p_init_msg_list) THEN

2627: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2628: FND_MSG_PUB.Add;
2629: END IF;
2630: --Initialize message list if p_init_msg_list is TRUE.
2631: IF FND_API.To_Boolean (p_init_msg_list) THEN
2632: FND_MSG_PUB.initialize;
2633: END IF;
2634: -- Get the current (login) user id.
2635: AMV_UTILITY_PVT.Get_UserInfo(

Line 2642: IF (p_check_login_user = FND_API.G_TRUE) THEN

2638: x_login_id => l_login_user_id,
2639: x_user_status => l_login_user_status
2640: );
2641: -- check login user
2642: IF (p_check_login_user = FND_API.G_TRUE) THEN
2643: -- Check if user is login and has the required privilege.
2644: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2645: -- User is not login.
2646: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2644: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

2640: );
2641: -- check login user
2642: IF (p_check_login_user = FND_API.G_TRUE) THEN
2643: -- Check if user is login and has the required privilege.
2644: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2645: -- User is not login.
2646: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2647: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2648: FND_MSG_PUB.Add;

Line 2650: RAISE FND_API.G_EXC_ERROR;

2646: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2647: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2648: FND_MSG_PUB.Add;
2649: END IF;
2650: RAISE FND_API.G_EXC_ERROR;
2651: END IF;
2652: END IF;
2653: -- This fix is for executing api in sqlplus mode
2654: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 2654: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

2650: RAISE FND_API.G_EXC_ERROR;
2651: END IF;
2652: END IF;
2653: -- This fix is for executing api in sqlplus mode
2654: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2655: l_login_user_id := g_login_user_id;
2656: l_user_id := g_user_id;
2657: l_resource_id := g_resource_id;
2658: END IF;

Line 2660: x_return_status := FND_API.G_RET_STS_SUCCESS;

2656: l_user_id := g_user_id;
2657: l_resource_id := g_resource_id;
2658: END IF;
2659: -- Initialize API return status to sucess
2660: x_return_status := FND_API.G_RET_STS_SUCCESS;
2661:
2662: --
2663: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
2664: x_content_chan_array := AMV_CAT_HIERARCHY_VARRAY_TYPE();

Line 2665: IF p_include_subcats = FND_API.G_FALSE THEN

2661:
2662: --
2663: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
2664: x_content_chan_array := AMV_CAT_HIERARCHY_VARRAY_TYPE();
2665: IF p_include_subcats = FND_API.G_FALSE THEN
2666: l_category_id := p_category_id;
2667: OPEN Get_CategoryChannels;
2668: LOOP
2669: FETCH Get_CategoryChannels INTO l_channel_id, l_channel_name;

Line 2718: RAISE FND_API.G_EXC_ERROR;

2714: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
2715: FND_MESSAGE.Set_Token('TKN',p_category_id);
2716: FND_MSG_PUB.Add;
2717: END IF;
2718: RAISE FND_API.G_EXC_ERROR;
2719: END IF;
2720: --
2721:
2722: -- Debug Message

Line 2730: p_encoded => FND_API.G_FALSE,

2726: FND_MSG_PUB.Add;
2727: END IF;
2728: --Standard call to get message count and if count=1, get the message
2729: FND_MSG_PUB.Count_And_Get (
2730: p_encoded => FND_API.G_FALSE,
2731: p_count => x_msg_count,
2732: p_data => x_msg_data
2733: );
2734: EXCEPTION

Line 2735: WHEN FND_API.G_EXC_ERROR THEN

2731: p_count => x_msg_count,
2732: p_data => x_msg_data
2733: );
2734: EXCEPTION
2735: WHEN FND_API.G_EXC_ERROR THEN
2736: ROLLBACK TO Get_ChansPerCategory_PVT;
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: -- Standard call to get message count and if count=1, get the message
2739: FND_MSG_PUB.Count_And_Get (

Line 2737: x_return_status := FND_API.G_RET_STS_ERROR;

2733: );
2734: EXCEPTION
2735: WHEN FND_API.G_EXC_ERROR THEN
2736: ROLLBACK TO Get_ChansPerCategory_PVT;
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: -- Standard call to get message count and if count=1, get the message
2739: FND_MSG_PUB.Count_And_Get (
2740: p_encoded => FND_API.G_FALSE,
2741: p_count => x_msg_count,

Line 2740: p_encoded => FND_API.G_FALSE,

2736: ROLLBACK TO Get_ChansPerCategory_PVT;
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: -- Standard call to get message count and if count=1, get the message
2739: FND_MSG_PUB.Count_And_Get (
2740: p_encoded => FND_API.G_FALSE,
2741: p_count => x_msg_count,
2742: p_data => x_msg_data
2743: );
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2740: p_encoded => FND_API.G_FALSE,
2741: p_count => x_msg_count,
2742: p_data => x_msg_data
2743: );
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2745: ROLLBACK TO Get_ChansPerCategory_PVT;
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: -- Standard call to get message count and if count=1, get the message
2748: FND_MSG_PUB.Count_And_Get (

Line 2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2742: p_data => x_msg_data
2743: );
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2745: ROLLBACK TO Get_ChansPerCategory_PVT;
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: -- Standard call to get message count and if count=1, get the message
2748: FND_MSG_PUB.Count_And_Get (
2749: p_encoded => FND_API.G_FALSE,
2750: p_count => x_msg_count,

Line 2749: p_encoded => FND_API.G_FALSE,

2745: ROLLBACK TO Get_ChansPerCategory_PVT;
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: -- Standard call to get message count and if count=1, get the message
2748: FND_MSG_PUB.Count_And_Get (
2749: p_encoded => FND_API.G_FALSE,
2750: p_count => x_msg_count,
2751: p_data => x_msg_data
2752: );
2753: WHEN OTHERS THEN

Line 2755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2751: p_data => x_msg_data
2752: );
2753: WHEN OTHERS THEN
2754: ROLLBACK TO Get_ChansPerCategory_PVT;
2755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2756: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2757: THEN
2758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2759: END IF;

Line 2762: p_encoded => FND_API.G_FALSE,

2758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2759: END IF;
2760: -- Standard call to get message count and if count=1, get the message
2761: FND_MSG_PUB.Count_And_Get (
2762: p_encoded => FND_API.G_FALSE,
2763: p_count => x_msg_count,
2764: p_data => x_msg_data
2765: );
2766: --

Line 2779: -- Default = FND_API.G_FALSE

2775: -- a content channel (sub)category
2776: -- Parameters :
2777: -- IN p_api_version IN NUMBER Required
2778: -- p_init_msg_list IN VARCHAR2 Optional
2779: -- Default = FND_API.G_FALSE
2780: -- p_validation_level IN NUMBER Optional
2781: -- Default = FND_API.G_VALID_LEVEL_FULL
2782: -- p_category_id IN NUMBER Required
2783: -- p_include_subcats IN VARCHAR2 Optional

Line 2781: -- Default = FND_API.G_VALID_LEVEL_FULL

2777: -- IN p_api_version IN NUMBER Required
2778: -- p_init_msg_list IN VARCHAR2 Optional
2779: -- Default = FND_API.G_FALSE
2780: -- p_validation_level IN NUMBER Optional
2781: -- Default = FND_API.G_VALID_LEVEL_FULL
2782: -- p_category_id IN NUMBER Required
2783: -- p_include_subcats IN VARCHAR2 Optional
2784: -- Default = FND_API.G_FALSE
2785: -- OUT : x_return_status OUT VARCHAR2

Line 2784: -- Default = FND_API.G_FALSE

2780: -- p_validation_level IN NUMBER Optional
2781: -- Default = FND_API.G_VALID_LEVEL_FULL
2782: -- p_category_id IN NUMBER Required
2783: -- p_include_subcats IN VARCHAR2 Optional
2784: -- Default = FND_API.G_FALSE
2785: -- OUT : x_return_status OUT VARCHAR2
2786: -- x_msg_count OUT NUMBER
2787: -- x_msg_data OUT VARCHAR2
2788: -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

Line 2798: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2794: -- End of comments
2795: --
2796: PROCEDURE Get_ItemsPerCategory
2797: ( p_api_version IN NUMBER,
2798: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2799: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2800: x_return_status OUT NOCOPY VARCHAR2,
2801: x_msg_count OUT NOCOPY NUMBER,
2802: x_msg_data OUT NOCOPY VARCHAR2,

Line 2799: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2795: --
2796: PROCEDURE Get_ItemsPerCategory
2797: ( p_api_version IN NUMBER,
2798: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2799: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2800: x_return_status OUT NOCOPY VARCHAR2,
2801: x_msg_count OUT NOCOPY NUMBER,
2802: x_msg_data OUT NOCOPY VARCHAR2,
2803: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 2803: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

2799: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2800: x_return_status OUT NOCOPY VARCHAR2,
2801: x_msg_count OUT NOCOPY NUMBER,
2802: x_msg_data OUT NOCOPY VARCHAR2,
2803: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2804: p_category_id IN NUMBER,
2805: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
2806: x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
2807: )

Line 2805: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

2801: x_msg_count OUT NOCOPY NUMBER,
2802: x_msg_data OUT NOCOPY VARCHAR2,
2803: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2804: p_category_id IN NUMBER,
2805: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
2806: x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
2807: )
2808: IS
2809: l_api_name CONSTANT VARCHAR2(30) := 'Get_ItemsPerCategory';

Line 2848: IF NOT FND_API.Compatible_API_Call (

2844: BEGIN
2845: -- Standard begin of API savepoint
2846: SAVEPOINT Get_ItemsPerCategory_PVT;
2847: -- Standard call to check for call compatibility.
2848: IF NOT FND_API.Compatible_API_Call (
2849: l_api_version,
2850: p_api_version,
2851: l_api_name,
2852: G_PKG_NAME)

Line 2854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2850: p_api_version,
2851: l_api_name,
2852: G_PKG_NAME)
2853: THEN
2854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2855: END IF;
2856: -- Debug Message
2857: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2858: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 2863: IF FND_API.To_Boolean (p_init_msg_list) THEN

2859: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2860: FND_MSG_PUB.Add;
2861: END IF;
2862: --Initialize message list if p_init_msg_list is TRUE.
2863: IF FND_API.To_Boolean (p_init_msg_list) THEN
2864: FND_MSG_PUB.initialize;
2865: END IF;
2866: -- Get the current (login) user id.
2867: AMV_UTILITY_PVT.Get_UserInfo(

Line 2874: IF (p_check_login_user = FND_API.G_TRUE) THEN

2870: x_login_id => l_login_user_id,
2871: x_user_status => l_login_user_status
2872: );
2873: -- check login user
2874: IF (p_check_login_user = FND_API.G_TRUE) THEN
2875: -- Check if user is login and has the required privilege.
2876: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2877: -- User is not login.
2878: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2876: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

2872: );
2873: -- check login user
2874: IF (p_check_login_user = FND_API.G_TRUE) THEN
2875: -- Check if user is login and has the required privilege.
2876: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2877: -- User is not login.
2878: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2879: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2880: FND_MSG_PUB.Add;

Line 2882: RAISE FND_API.G_EXC_ERROR;

2878: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2879: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2880: FND_MSG_PUB.Add;
2881: END IF;
2882: RAISE FND_API.G_EXC_ERROR;
2883: END IF;
2884: END IF;
2885: -- This fix is for executing api in sqlplus mode
2886: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 2886: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

2882: RAISE FND_API.G_EXC_ERROR;
2883: END IF;
2884: END IF;
2885: -- This fix is for executing api in sqlplus mode
2886: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2887: l_login_user_id := g_login_user_id;
2888: l_user_id := g_user_id;
2889: l_resource_id := g_resource_id;
2890: END IF;

Line 2892: x_return_status := FND_API.G_RET_STS_SUCCESS;

2888: l_user_id := g_user_id;
2889: l_resource_id := g_resource_id;
2890: END IF;
2891: -- Initialize API return status to sucess
2892: x_return_status := FND_API.G_RET_STS_SUCCESS;
2893:
2894: --
2895: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
2896: x_items_array := AMV_CAT_HIERARCHY_VARRAY_TYPE();

Line 2897: IF p_include_subcats = FND_API.G_FALSE THEN

2893:
2894: --
2895: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
2896: x_items_array := AMV_CAT_HIERARCHY_VARRAY_TYPE();
2897: IF p_include_subcats = FND_API.G_FALSE THEN
2898: l_category_id := p_category_id;
2899: OPEN Get_CategoryItems_csr;
2900: LOOP
2901: FETCH Get_CategoryItems_csr INTO l_item_id, l_item_name;

Line 2948: RAISE FND_API.G_EXC_ERROR;

2944: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
2945: FND_MESSAGE.Set_Token('TKN',p_category_id);
2946: FND_MSG_PUB.Add;
2947: END IF;
2948: RAISE FND_API.G_EXC_ERROR;
2949: END IF;
2950: --
2951:
2952: -- Debug Message

Line 2960: p_encoded => FND_API.G_FALSE,

2956: FND_MSG_PUB.Add;
2957: END IF;
2958: --Standard call to get message count and if count=1, get the message
2959: FND_MSG_PUB.Count_And_Get (
2960: p_encoded => FND_API.G_FALSE,
2961: p_count => x_msg_count,
2962: p_data => x_msg_data
2963: );
2964: EXCEPTION

Line 2965: WHEN FND_API.G_EXC_ERROR THEN

2961: p_count => x_msg_count,
2962: p_data => x_msg_data
2963: );
2964: EXCEPTION
2965: WHEN FND_API.G_EXC_ERROR THEN
2966: ROLLBACK TO Get_ItemsPerCategory_PVT;
2967: x_return_status := FND_API.G_RET_STS_ERROR;
2968: -- Standard call to get message count and if count=1, get the message
2969: FND_MSG_PUB.Count_And_Get (

Line 2967: x_return_status := FND_API.G_RET_STS_ERROR;

2963: );
2964: EXCEPTION
2965: WHEN FND_API.G_EXC_ERROR THEN
2966: ROLLBACK TO Get_ItemsPerCategory_PVT;
2967: x_return_status := FND_API.G_RET_STS_ERROR;
2968: -- Standard call to get message count and if count=1, get the message
2969: FND_MSG_PUB.Count_And_Get (
2970: p_encoded => FND_API.G_FALSE,
2971: p_count => x_msg_count,

Line 2970: p_encoded => FND_API.G_FALSE,

2966: ROLLBACK TO Get_ItemsPerCategory_PVT;
2967: x_return_status := FND_API.G_RET_STS_ERROR;
2968: -- Standard call to get message count and if count=1, get the message
2969: FND_MSG_PUB.Count_And_Get (
2970: p_encoded => FND_API.G_FALSE,
2971: p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2970: p_encoded => FND_API.G_FALSE,
2971: p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2975: ROLLBACK TO Get_ItemsPerCategory_PVT;
2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2977: -- Standard call to get message count and if count=1, get the message
2978: FND_MSG_PUB.Count_And_Get (

Line 2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2972: p_data => x_msg_data
2973: );
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2975: ROLLBACK TO Get_ItemsPerCategory_PVT;
2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2977: -- Standard call to get message count and if count=1, get the message
2978: FND_MSG_PUB.Count_And_Get (
2979: p_encoded => FND_API.G_FALSE,
2980: p_count => x_msg_count,

Line 2979: p_encoded => FND_API.G_FALSE,

2975: ROLLBACK TO Get_ItemsPerCategory_PVT;
2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2977: -- Standard call to get message count and if count=1, get the message
2978: FND_MSG_PUB.Count_And_Get (
2979: p_encoded => FND_API.G_FALSE,
2980: p_count => x_msg_count,
2981: p_data => x_msg_data
2982: );
2983: WHEN OTHERS THEN

Line 2985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2981: p_data => x_msg_data
2982: );
2983: WHEN OTHERS THEN
2984: ROLLBACK TO Get_ItemsPerCategory_PVT;
2985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2986: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2987: THEN
2988: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2989: END IF;

Line 2992: p_encoded => FND_API.G_FALSE,

2988: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2989: END IF;
2990: -- Standard call to get message count and if count=1, get the message
2991: FND_MSG_PUB.Count_And_Get (
2992: p_encoded => FND_API.G_FALSE,
2993: p_count => x_msg_count,
2994: p_data => x_msg_data
2995: );
2996: --

Line 3009: -- Default = FND_API.G_FALSE

3005: -- a content channel (sub)category
3006: -- Parameters :
3007: -- IN p_api_version IN NUMBER Required
3008: -- p_init_msg_list IN VARCHAR2 Optional
3009: -- Default = FND_API.G_FALSE
3010: -- p_validation_level IN NUMBER Optional
3011: -- Default = FND_API.G_VALID_LEVEL_FULL
3012: -- p_category_id IN NUMBER Required
3013: -- p_include_subcats IN VARCHAR2 Optional

Line 3011: -- Default = FND_API.G_VALID_LEVEL_FULL

3007: -- IN p_api_version IN NUMBER Required
3008: -- p_init_msg_list IN VARCHAR2 Optional
3009: -- Default = FND_API.G_FALSE
3010: -- p_validation_level IN NUMBER Optional
3011: -- Default = FND_API.G_VALID_LEVEL_FULL
3012: -- p_category_id IN NUMBER Required
3013: -- p_include_subcats IN VARCHAR2 Optional
3014: -- Default = FND_API.G_FALSE
3015: -- OUT : x_return_status OUT VARCHAR2

Line 3014: -- Default = FND_API.G_FALSE

3010: -- p_validation_level IN NUMBER Optional
3011: -- Default = FND_API.G_VALID_LEVEL_FULL
3012: -- p_category_id IN NUMBER Required
3013: -- p_include_subcats IN VARCHAR2 Optional
3014: -- Default = FND_API.G_FALSE
3015: -- OUT : x_return_status OUT VARCHAR2
3016: -- x_msg_count OUT NUMBER
3017: -- x_msg_data OUT VARCHAR2
3018: -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

Line 3028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3024: -- End of comments
3025: --
3026: PROCEDURE Get_ItemsPerCategory
3027: ( p_api_version IN NUMBER,
3028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3029: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3030: x_return_status OUT NOCOPY VARCHAR2,
3031: x_msg_count OUT NOCOPY NUMBER,
3032: x_msg_data OUT NOCOPY VARCHAR2,

Line 3029: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3025: --
3026: PROCEDURE Get_ItemsPerCategory
3027: ( p_api_version IN NUMBER,
3028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3029: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3030: x_return_status OUT NOCOPY VARCHAR2,
3031: x_msg_count OUT NOCOPY NUMBER,
3032: x_msg_data OUT NOCOPY VARCHAR2,
3033: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 3033: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

3029: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3030: x_return_status OUT NOCOPY VARCHAR2,
3031: x_msg_count OUT NOCOPY NUMBER,
3032: x_msg_data OUT NOCOPY VARCHAR2,
3033: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
3034: p_category_id IN NUMBER,
3035: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
3036: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
3037: p_category_sort IN AMV_SORT_OBJ_TYPE,

Line 3035: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

3031: x_msg_count OUT NOCOPY NUMBER,
3032: x_msg_data OUT NOCOPY VARCHAR2,
3033: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
3034: p_category_id IN NUMBER,
3035: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
3036: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
3037: p_category_sort IN AMV_SORT_OBJ_TYPE,
3038: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
3039: x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE

Line 3099: IF NOT FND_API.Compatible_API_Call (

3095: BEGIN
3096: -- Standard begin of API savepoint
3097: SAVEPOINT Get_ItemsPerCategory_PVT;
3098: -- Standard call to check for call compatibility.
3099: IF NOT FND_API.Compatible_API_Call (
3100: l_api_version,
3101: p_api_version,
3102: l_api_name,
3103: G_PKG_NAME)

Line 3105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3101: p_api_version,
3102: l_api_name,
3103: G_PKG_NAME)
3104: THEN
3105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3106: END IF;
3107: -- Debug Message
3108: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3109: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 3114: IF FND_API.To_Boolean (p_init_msg_list) THEN

3110: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3111: FND_MSG_PUB.Add;
3112: END IF;
3113: --Initialize message list if p_init_msg_list is TRUE.
3114: IF FND_API.To_Boolean (p_init_msg_list) THEN
3115: FND_MSG_PUB.initialize;
3116: END IF;
3117: -- Get the current (login) user id.
3118: AMV_UTILITY_PVT.Get_UserInfo(

Line 3125: IF (p_check_login_user = FND_API.G_TRUE) THEN

3121: x_login_id => l_login_user_id,
3122: x_user_status => l_login_user_status
3123: );
3124: -- check login user
3125: IF (p_check_login_user = FND_API.G_TRUE) THEN
3126: -- Check if user is login and has the required privilege.
3127: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3128: -- User is not login.
3129: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3127: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3123: );
3124: -- check login user
3125: IF (p_check_login_user = FND_API.G_TRUE) THEN
3126: -- Check if user is login and has the required privilege.
3127: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3128: -- User is not login.
3129: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3130: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3131: FND_MSG_PUB.Add;

Line 3133: RAISE FND_API.G_EXC_ERROR;

3129: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3130: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3131: FND_MSG_PUB.Add;
3132: END IF;
3133: RAISE FND_API.G_EXC_ERROR;
3134: END IF;
3135: END IF;
3136: -- This fix is for executing api in sqlplus mode
3137: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 3137: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3133: RAISE FND_API.G_EXC_ERROR;
3134: END IF;
3135: END IF;
3136: -- This fix is for executing api in sqlplus mode
3137: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3138: l_login_user_id := g_login_user_id;
3139: l_user_id := g_user_id;
3140: l_resource_id := g_resource_id;
3141: END IF;

Line 3143: x_return_status := FND_API.G_RET_STS_SUCCESS;

3139: l_user_id := g_user_id;
3140: l_resource_id := g_resource_id;
3141: END IF;
3142: -- Initialize API return status to sucess
3143: x_return_status := FND_API.G_RET_STS_SUCCESS;
3144:
3145: --
3146: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
3147: x_items_array := AMV_CAT_HIERARCHY_VARRAY_TYPE();

Line 3148: IF p_include_subcats = FND_API.G_FALSE THEN

3144:
3145: --
3146: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
3147: x_items_array := AMV_CAT_HIERARCHY_VARRAY_TYPE();
3148: IF p_include_subcats = FND_API.G_FALSE THEN
3149: l_category_id := p_category_id;
3150: IF ( p_category_sort.sort_col = null ) THEN
3151: l_sort_col := 'ib.'||p_category_sort.sort_col;
3152: ELSE

Line 3243: RAISE FND_API.G_EXC_ERROR;

3239: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
3240: FND_MESSAGE.Set_Token('TKN',p_category_id);
3241: FND_MSG_PUB.Add;
3242: END IF;
3243: RAISE FND_API.G_EXC_ERROR;
3244: END IF;
3245: --
3246:
3247: -- Debug Message

Line 3255: p_encoded => FND_API.G_FALSE,

3251: FND_MSG_PUB.Add;
3252: END IF;
3253: --Standard call to get message count and if count=1, get the message
3254: FND_MSG_PUB.Count_And_Get (
3255: p_encoded => FND_API.G_FALSE,
3256: p_count => x_msg_count,
3257: p_data => x_msg_data
3258: );
3259: EXCEPTION

Line 3260: WHEN FND_API.G_EXC_ERROR THEN

3256: p_count => x_msg_count,
3257: p_data => x_msg_data
3258: );
3259: EXCEPTION
3260: WHEN FND_API.G_EXC_ERROR THEN
3261: ROLLBACK TO Get_ItemsPerCategory_PVT;
3262: x_return_status := FND_API.G_RET_STS_ERROR;
3263: -- Standard call to get message count and if count=1, get the message
3264: FND_MSG_PUB.Count_And_Get (

Line 3262: x_return_status := FND_API.G_RET_STS_ERROR;

3258: );
3259: EXCEPTION
3260: WHEN FND_API.G_EXC_ERROR THEN
3261: ROLLBACK TO Get_ItemsPerCategory_PVT;
3262: x_return_status := FND_API.G_RET_STS_ERROR;
3263: -- Standard call to get message count and if count=1, get the message
3264: FND_MSG_PUB.Count_And_Get (
3265: p_encoded => FND_API.G_FALSE,
3266: p_count => x_msg_count,

Line 3265: p_encoded => FND_API.G_FALSE,

3261: ROLLBACK TO Get_ItemsPerCategory_PVT;
3262: x_return_status := FND_API.G_RET_STS_ERROR;
3263: -- Standard call to get message count and if count=1, get the message
3264: FND_MSG_PUB.Count_And_Get (
3265: p_encoded => FND_API.G_FALSE,
3266: p_count => x_msg_count,
3267: p_data => x_msg_data
3268: );
3269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3265: p_encoded => FND_API.G_FALSE,
3266: p_count => x_msg_count,
3267: p_data => x_msg_data
3268: );
3269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3270: ROLLBACK TO Get_ItemsPerCategory_PVT;
3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3272: -- Standard call to get message count and if count=1, get the message
3273: FND_MSG_PUB.Count_And_Get (

Line 3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3267: p_data => x_msg_data
3268: );
3269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3270: ROLLBACK TO Get_ItemsPerCategory_PVT;
3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3272: -- Standard call to get message count and if count=1, get the message
3273: FND_MSG_PUB.Count_And_Get (
3274: p_encoded => FND_API.G_FALSE,
3275: p_count => x_msg_count,

Line 3274: p_encoded => FND_API.G_FALSE,

3270: ROLLBACK TO Get_ItemsPerCategory_PVT;
3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3272: -- Standard call to get message count and if count=1, get the message
3273: FND_MSG_PUB.Count_And_Get (
3274: p_encoded => FND_API.G_FALSE,
3275: p_count => x_msg_count,
3276: p_data => x_msg_data
3277: );
3278: WHEN OTHERS THEN

Line 3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3276: p_data => x_msg_data
3277: );
3278: WHEN OTHERS THEN
3279: ROLLBACK TO Get_ItemsPerCategory_PVT;
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3281: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3282: THEN
3283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3284: END IF;

Line 3287: p_encoded => FND_API.G_FALSE,

3283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3284: END IF;
3285: -- Standard call to get message count and if count=1, get the message
3286: FND_MSG_PUB.Count_And_Get (
3287: p_encoded => FND_API.G_FALSE,
3288: p_count => x_msg_count,
3289: p_data => x_msg_data
3290: );
3291: --

Line 3310: -- Default = FND_API.G_FALSE

3306: -- Function : returns category id for a category or subcategory name.
3307: -- Parameters :
3308: -- IN p_api_version IN NUMBER Required
3309: -- p_init_msg_list IN VARCHAR2 Optional
3310: -- Default = FND_API.G_FALSE
3311: -- p_validation_level IN NUMBER Optional
3312: -- Default = FND_API.G_VALID_LEVEL_FULL
3313: -- p_category_name IN VARCHAR2 Required
3314: -- (sub)category id

Line 3312: -- Default = FND_API.G_VALID_LEVEL_FULL

3308: -- IN p_api_version IN NUMBER Required
3309: -- p_init_msg_list IN VARCHAR2 Optional
3310: -- Default = FND_API.G_FALSE
3311: -- p_validation_level IN NUMBER Optional
3312: -- Default = FND_API.G_VALID_LEVEL_FULL
3313: -- p_category_name IN VARCHAR2 Required
3314: -- (sub)category id
3315: -- p_parent_category_id IN NUMBER Optional
3316: -- Default = FND_API.G_MISS_NUM

Line 3316: -- Default = FND_API.G_MISS_NUM

3312: -- Default = FND_API.G_VALID_LEVEL_FULL
3313: -- p_category_name IN VARCHAR2 Required
3314: -- (sub)category id
3315: -- p_parent_category_id IN NUMBER Optional
3316: -- Default = FND_API.G_MISS_NUM
3317: -- parent category id
3318: -- p_parent_category_name IN VARCHAR2 Optional
3319: -- Default = FND_API.G_MISS_CHAR
3320: -- parent category name

Line 3319: -- Default = FND_API.G_MISS_CHAR

3315: -- p_parent_category_id IN NUMBER Optional
3316: -- Default = FND_API.G_MISS_NUM
3317: -- parent category id
3318: -- p_parent_category_name IN VARCHAR2 Optional
3319: -- Default = FND_API.G_MISS_CHAR
3320: -- parent category name
3321: -- parent id or name required for subcategory name
3322: -- OUT : x_return_status OUT VARCHAR2
3323: -- x_msg_count OUT NUMBER

Line 3335: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3331: --
3332: --
3333: PROCEDURE Fetch_CategoryId
3334: ( p_api_version IN NUMBER,
3335: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3337: x_return_status OUT NOCOPY VARCHAR2,
3338: x_msg_count OUT NOCOPY NUMBER,
3339: x_msg_data OUT NOCOPY VARCHAR2,

Line 3336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3332: --
3333: PROCEDURE Fetch_CategoryId
3334: ( p_api_version IN NUMBER,
3335: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3337: x_return_status OUT NOCOPY VARCHAR2,
3338: x_msg_count OUT NOCOPY NUMBER,
3339: x_msg_data OUT NOCOPY VARCHAR2,
3340: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 3340: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

3336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3337: x_return_status OUT NOCOPY VARCHAR2,
3338: x_msg_count OUT NOCOPY NUMBER,
3339: x_msg_data OUT NOCOPY VARCHAR2,
3340: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
3341: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
3342: p_category_name IN VARCHAR2,
3343: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
3344: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 3343: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

3339: x_msg_data OUT NOCOPY VARCHAR2,
3340: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
3341: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
3342: p_category_name IN VARCHAR2,
3343: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
3344: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3345: x_category_id OUT NOCOPY NUMBER
3346: )
3347: IS

Line 3344: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

3340: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
3341: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
3342: p_category_name IN VARCHAR2,
3343: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
3344: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
3345: x_category_id OUT NOCOPY NUMBER
3346: )
3347: IS
3348: l_api_name CONSTANT VARCHAR2(30) := 'Fetch_CategoryId';

Line 3368: IF NOT FND_API.Compatible_API_Call (

3364: BEGIN
3365: -- Standard begin of API savepoint
3366: SAVEPOINT Fetch_CategoryId_PVT;
3367: -- Standard call to check for call compatibility.
3368: IF NOT FND_API.Compatible_API_Call (
3369: l_api_version,
3370: p_api_version,
3371: l_api_name,
3372: G_PKG_NAME)

Line 3374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3370: p_api_version,
3371: l_api_name,
3372: G_PKG_NAME)
3373: THEN
3374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3375: END IF;
3376: -- Debug Message
3377: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3378: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 3383: IF FND_API.To_Boolean (p_init_msg_list) THEN

3379: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3380: FND_MSG_PUB.Add;
3381: END IF;
3382: --Initialize message list if p_init_msg_list is TRUE.
3383: IF FND_API.To_Boolean (p_init_msg_list) THEN
3384: FND_MSG_PUB.initialize;
3385: END IF;
3386: -- Get the current (login) user id.
3387: AMV_UTILITY_PVT.Get_UserInfo(

Line 3394: IF (p_check_login_user = FND_API.G_TRUE) THEN

3390: x_login_id => l_login_user_id,
3391: x_user_status => l_login_user_status
3392: );
3393: -- check login user
3394: IF (p_check_login_user = FND_API.G_TRUE) THEN
3395: -- Check if user is login and has the required privilege.
3396: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3397: -- User is not login.
3398: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3396: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3392: );
3393: -- check login user
3394: IF (p_check_login_user = FND_API.G_TRUE) THEN
3395: -- Check if user is login and has the required privilege.
3396: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3397: -- User is not login.
3398: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3399: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3400: FND_MSG_PUB.Add;

Line 3402: RAISE FND_API.G_EXC_ERROR;

3398: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3399: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3400: FND_MSG_PUB.Add;
3401: END IF;
3402: RAISE FND_API.G_EXC_ERROR;
3403: END IF;
3404: END IF;
3405: -- This fix is for executing api in sqlplus mode
3406: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 3406: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3402: RAISE FND_API.G_EXC_ERROR;
3403: END IF;
3404: END IF;
3405: -- This fix is for executing api in sqlplus mode
3406: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3407: l_login_user_id := g_login_user_id;
3408: l_user_id := g_user_id;
3409: l_resource_id := g_resource_id;
3410: END IF;

Line 3412: x_return_status := FND_API.G_RET_STS_SUCCESS;

3408: l_user_id := g_user_id;
3409: l_resource_id := g_resource_id;
3410: END IF;
3411: -- Initialize API return status to sucess
3412: x_return_status := FND_API.G_RET_STS_SUCCESS;
3413:
3414: --
3415: Validate_CategoryStatus(
3416: x_return_status => x_return_status,

Line 3426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3422: x_error_msg => l_Error_Msg,
3423: x_error_token => l_Error_Token
3424: );
3425: --
3426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3428: THEN
3429: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3430: FND_MESSAGE.Set_Token('TKN',l_Error_Token);

Line 3433: RAISE FND_API.G_EXC_ERROR;

3429: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3430: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3431: FND_MSG_PUB.Add;
3432: END IF;
3433: RAISE FND_API.G_EXC_ERROR;
3434: END IF;
3435:
3436: -- Debug Message
3437: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 3444: p_encoded => FND_API.G_FALSE,

3440: FND_MSG_PUB.Add;
3441: END IF;
3442: --Standard call to get message count and if count=1, get the message
3443: FND_MSG_PUB.Count_And_Get (
3444: p_encoded => FND_API.G_FALSE,
3445: p_count => x_msg_count,
3446: p_data => x_msg_data
3447: );
3448: EXCEPTION

Line 3449: WHEN FND_API.G_EXC_ERROR THEN

3445: p_count => x_msg_count,
3446: p_data => x_msg_data
3447: );
3448: EXCEPTION
3449: WHEN FND_API.G_EXC_ERROR THEN
3450: ROLLBACK TO Fetch_CategoryId_PVT;
3451: x_return_status := FND_API.G_RET_STS_ERROR;
3452: -- Standard call to get message count and if count=1, get the message
3453: FND_MSG_PUB.Count_And_Get (

Line 3451: x_return_status := FND_API.G_RET_STS_ERROR;

3447: );
3448: EXCEPTION
3449: WHEN FND_API.G_EXC_ERROR THEN
3450: ROLLBACK TO Fetch_CategoryId_PVT;
3451: x_return_status := FND_API.G_RET_STS_ERROR;
3452: -- Standard call to get message count and if count=1, get the message
3453: FND_MSG_PUB.Count_And_Get (
3454: p_encoded => FND_API.G_FALSE,
3455: p_count => x_msg_count,

Line 3454: p_encoded => FND_API.G_FALSE,

3450: ROLLBACK TO Fetch_CategoryId_PVT;
3451: x_return_status := FND_API.G_RET_STS_ERROR;
3452: -- Standard call to get message count and if count=1, get the message
3453: FND_MSG_PUB.Count_And_Get (
3454: p_encoded => FND_API.G_FALSE,
3455: p_count => x_msg_count,
3456: p_data => x_msg_data
3457: );
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3454: p_encoded => FND_API.G_FALSE,
3455: p_count => x_msg_count,
3456: p_data => x_msg_data
3457: );
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK TO Fetch_CategoryId_PVT;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: -- Standard call to get message count and if count=1, get the message
3462: FND_MSG_PUB.Count_And_Get (

Line 3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3456: p_data => x_msg_data
3457: );
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK TO Fetch_CategoryId_PVT;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: -- Standard call to get message count and if count=1, get the message
3462: FND_MSG_PUB.Count_And_Get (
3463: p_encoded => FND_API.G_FALSE,
3464: p_count => x_msg_count,

Line 3463: p_encoded => FND_API.G_FALSE,

3459: ROLLBACK TO Fetch_CategoryId_PVT;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: -- Standard call to get message count and if count=1, get the message
3462: FND_MSG_PUB.Count_And_Get (
3463: p_encoded => FND_API.G_FALSE,
3464: p_count => x_msg_count,
3465: p_data => x_msg_data
3466: );
3467: WHEN OTHERS THEN

Line 3469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3465: p_data => x_msg_data
3466: );
3467: WHEN OTHERS THEN
3468: ROLLBACK TO Fetch_CategoryId_PVT;
3469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3470: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3471: THEN
3472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3473: END IF;

Line 3476: p_encoded => FND_API.G_FALSE,

3472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3473: END IF;
3474: -- Standard call to get message count and if count=1, get the message
3475: FND_MSG_PUB.Count_And_Get (
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => x_msg_count,
3478: p_data => x_msg_data
3479: );
3480: --

Line 3494: -- Default = FND_API.G_FALSE

3490: -- for a category id.
3491: -- Parameters :
3492: -- IN p_api_version IN NUMBER Required
3493: -- p_init_msg_list IN VARCHAR2 Optional
3494: -- Default = FND_API.G_FALSE
3495: -- p_validation_level IN NUMBER Optional
3496: -- Default = FND_API.G_VALID_LEVEL_FULL
3497: -- p_category_id IN NUMBER Required
3498: -- (sub)category id

Line 3496: -- Default = FND_API.G_VALID_LEVEL_FULL

3492: -- IN p_api_version IN NUMBER Required
3493: -- p_init_msg_list IN VARCHAR2 Optional
3494: -- Default = FND_API.G_FALSE
3495: -- p_validation_level IN NUMBER Optional
3496: -- Default = FND_API.G_VALID_LEVEL_FULL
3497: -- p_category_id IN NUMBER Required
3498: -- (sub)category id
3499: -- OUT : x_return_status OUT VARCHAR2
3500: -- x_msg_count OUT NUMBER

Line 3512: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3508: --
3509: --
3510: PROCEDURE Get_CatParentsHierarchy
3511: ( p_api_version IN NUMBER,
3512: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3513: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3514: x_return_status OUT NOCOPY VARCHAR2,
3515: x_msg_count OUT NOCOPY NUMBER,
3516: x_msg_data OUT NOCOPY VARCHAR2,

Line 3513: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3509: --
3510: PROCEDURE Get_CatParentsHierarchy
3511: ( p_api_version IN NUMBER,
3512: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3513: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3514: x_return_status OUT NOCOPY VARCHAR2,
3515: x_msg_count OUT NOCOPY NUMBER,
3516: x_msg_data OUT NOCOPY VARCHAR2,
3517: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 3517: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

3513: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3514: x_return_status OUT NOCOPY VARCHAR2,
3515: x_msg_count OUT NOCOPY NUMBER,
3516: x_msg_data OUT NOCOPY VARCHAR2,
3517: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
3518: p_category_id IN NUMBER,
3519: x_category_hierarchy OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
3520: )
3521: IS

Line 3541: IF NOT FND_API.Compatible_API_Call (

3537: BEGIN
3538: -- Standard begin of API savepoint
3539: SAVEPOINT Get_CatParentsHrPVT;
3540: -- Standard call to check for call compatibility.
3541: IF NOT FND_API.Compatible_API_Call (
3542: l_api_version,
3543: p_api_version,
3544: l_api_name,
3545: G_PKG_NAME)

Line 3547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3543: p_api_version,
3544: l_api_name,
3545: G_PKG_NAME)
3546: THEN
3547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3548: END IF;
3549: -- Debug Message
3550: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3551: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 3556: IF FND_API.To_Boolean (p_init_msg_list) THEN

3552: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3553: FND_MSG_PUB.Add;
3554: END IF;
3555: --Initialize message list if p_init_msg_list is TRUE.
3556: IF FND_API.To_Boolean (p_init_msg_list) THEN
3557: FND_MSG_PUB.initialize;
3558: END IF;
3559: -- Get the current (login) user id.
3560: AMV_UTILITY_PVT.Get_UserInfo(

Line 3567: IF (p_check_login_user = FND_API.G_TRUE) THEN

3563: x_login_id => l_login_user_id,
3564: x_user_status => l_login_user_status
3565: );
3566: -- check login user
3567: IF (p_check_login_user = FND_API.G_TRUE) THEN
3568: -- Check if user is login and has the required privilege.
3569: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3570: -- User is not login.
3571: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3569: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3565: );
3566: -- check login user
3567: IF (p_check_login_user = FND_API.G_TRUE) THEN
3568: -- Check if user is login and has the required privilege.
3569: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3570: -- User is not login.
3571: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3572: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3573: FND_MSG_PUB.Add;

Line 3575: RAISE FND_API.G_EXC_ERROR;

3571: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3572: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3573: FND_MSG_PUB.Add;
3574: END IF;
3575: RAISE FND_API.G_EXC_ERROR;
3576: END IF;
3577: END IF;
3578: -- This fix is for executing api in sqlplus mode
3579: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 3579: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3575: RAISE FND_API.G_EXC_ERROR;
3576: END IF;
3577: END IF;
3578: -- This fix is for executing api in sqlplus mode
3579: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3580: l_login_user_id := g_login_user_id;
3581: l_user_id := g_user_id;
3582: l_resource_id := g_resource_id;
3583: END IF;

Line 3585: x_return_status := FND_API.G_RET_STS_SUCCESS;

3581: l_user_id := g_user_id;
3582: l_resource_id := g_resource_id;
3583: END IF;
3584: -- Initialize API return status to sucess
3585: x_return_status := FND_API.G_RET_STS_SUCCESS;
3586:
3587: --
3588: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
3589:

Line 3603: RAISE FND_API.G_EXC_ERROR;

3599: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
3600: FND_MESSAGE.Set_Token('TKN',p_category_id);
3601: FND_MSG_PUB.Add;
3602: END IF;
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;
3605: --
3606:
3607: -- Debug Message

Line 3615: p_encoded => FND_API.G_FALSE,

3611: FND_MSG_PUB.Add;
3612: END IF;
3613: --Standard call to get message count and if count=1, get the message
3614: FND_MSG_PUB.Count_And_Get (
3615: p_encoded => FND_API.G_FALSE,
3616: p_count => x_msg_count,
3617: p_data => x_msg_data
3618: );
3619: EXCEPTION

Line 3620: WHEN FND_API.G_EXC_ERROR THEN

3616: p_count => x_msg_count,
3617: p_data => x_msg_data
3618: );
3619: EXCEPTION
3620: WHEN FND_API.G_EXC_ERROR THEN
3621: ROLLBACK TO Get_CatParentsHrPVT;
3622: x_return_status := FND_API.G_RET_STS_ERROR;
3623: -- Standard call to get message count and if count=1, get the message
3624: FND_MSG_PUB.Count_And_Get (

Line 3622: x_return_status := FND_API.G_RET_STS_ERROR;

3618: );
3619: EXCEPTION
3620: WHEN FND_API.G_EXC_ERROR THEN
3621: ROLLBACK TO Get_CatParentsHrPVT;
3622: x_return_status := FND_API.G_RET_STS_ERROR;
3623: -- Standard call to get message count and if count=1, get the message
3624: FND_MSG_PUB.Count_And_Get (
3625: p_encoded => FND_API.G_FALSE,
3626: p_count => x_msg_count,

Line 3625: p_encoded => FND_API.G_FALSE,

3621: ROLLBACK TO Get_CatParentsHrPVT;
3622: x_return_status := FND_API.G_RET_STS_ERROR;
3623: -- Standard call to get message count and if count=1, get the message
3624: FND_MSG_PUB.Count_And_Get (
3625: p_encoded => FND_API.G_FALSE,
3626: p_count => x_msg_count,
3627: p_data => x_msg_data
3628: );
3629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3625: p_encoded => FND_API.G_FALSE,
3626: p_count => x_msg_count,
3627: p_data => x_msg_data
3628: );
3629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3630: ROLLBACK TO Get_CatParentsHrPVT;
3631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3632: -- Standard call to get message count and if count=1, get the message
3633: FND_MSG_PUB.Count_And_Get (

Line 3631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3627: p_data => x_msg_data
3628: );
3629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3630: ROLLBACK TO Get_CatParentsHrPVT;
3631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3632: -- Standard call to get message count and if count=1, get the message
3633: FND_MSG_PUB.Count_And_Get (
3634: p_encoded => FND_API.G_FALSE,
3635: p_count => x_msg_count,

Line 3634: p_encoded => FND_API.G_FALSE,

3630: ROLLBACK TO Get_CatParentsHrPVT;
3631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3632: -- Standard call to get message count and if count=1, get the message
3633: FND_MSG_PUB.Count_And_Get (
3634: p_encoded => FND_API.G_FALSE,
3635: p_count => x_msg_count,
3636: p_data => x_msg_data
3637: );
3638: WHEN OTHERS THEN

Line 3640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3636: p_data => x_msg_data
3637: );
3638: WHEN OTHERS THEN
3639: ROLLBACK TO Get_CatParentsHrPVT;
3640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3641: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3642: THEN
3643: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3644: END IF;

Line 3647: p_encoded => FND_API.G_FALSE,

3643: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3644: END IF;
3645: -- Standard call to get message count and if count=1, get the message
3646: FND_MSG_PUB.Count_And_Get (
3647: p_encoded => FND_API.G_FALSE,
3648: p_count => x_msg_count,
3649: p_data => x_msg_data
3650: );
3651: --

Line 3665: -- Default = FND_API.G_FALSE

3661: -- for a category id.
3662: -- Parameters :
3663: -- IN p_api_version IN NUMBER Required
3664: -- p_init_msg_list IN VARCHAR2 Optional
3665: -- Default = FND_API.G_FALSE
3666: -- p_validation_level IN NUMBER Optional
3667: -- Default = FND_API.G_VALID_LEVEL_FULL
3668: -- p_category_id IN NUMBER Required
3669: -- (sub)category id

Line 3667: -- Default = FND_API.G_VALID_LEVEL_FULL

3663: -- IN p_api_version IN NUMBER Required
3664: -- p_init_msg_list IN VARCHAR2 Optional
3665: -- Default = FND_API.G_FALSE
3666: -- p_validation_level IN NUMBER Optional
3667: -- Default = FND_API.G_VALID_LEVEL_FULL
3668: -- p_category_id IN NUMBER Required
3669: -- (sub)category id
3670: -- OUT : x_return_status OUT VARCHAR2
3671: -- x_msg_count OUT NUMBER

Line 3683: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3679: --
3680: --
3681: PROCEDURE Get_CatChildrenHierarchy
3682: ( p_api_version IN NUMBER,
3683: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3685: x_return_status OUT NOCOPY VARCHAR2,
3686: x_msg_count OUT NOCOPY NUMBER,
3687: x_msg_data OUT NOCOPY VARCHAR2,

Line 3684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3680: --
3681: PROCEDURE Get_CatChildrenHierarchy
3682: ( p_api_version IN NUMBER,
3683: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3685: x_return_status OUT NOCOPY VARCHAR2,
3686: x_msg_count OUT NOCOPY NUMBER,
3687: x_msg_data OUT NOCOPY VARCHAR2,
3688: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 3688: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

3684: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3685: x_return_status OUT NOCOPY VARCHAR2,
3686: x_msg_count OUT NOCOPY NUMBER,
3687: x_msg_data OUT NOCOPY VARCHAR2,
3688: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
3689: p_category_id IN NUMBER,
3690: x_category_hierarchy OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
3691: )
3692: IS

Line 3712: IF NOT FND_API.Compatible_API_Call (

3708: BEGIN
3709: -- Standard begin of API savepoint
3710: SAVEPOINT Get_CatChildrenHrPVT;
3711: -- Standard call to check for call compatibility.
3712: IF NOT FND_API.Compatible_API_Call (
3713: l_api_version,
3714: p_api_version,
3715: l_api_name,
3716: G_PKG_NAME)

Line 3718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3714: p_api_version,
3715: l_api_name,
3716: G_PKG_NAME)
3717: THEN
3718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3719: END IF;
3720: -- Debug Message
3721: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3722: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 3727: IF FND_API.To_Boolean (p_init_msg_list) THEN

3723: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3724: FND_MSG_PUB.Add;
3725: END IF;
3726: --Initialize message list if p_init_msg_list is TRUE.
3727: IF FND_API.To_Boolean (p_init_msg_list) THEN
3728: FND_MSG_PUB.initialize;
3729: END IF;
3730: -- Get the current (login) user id.
3731: AMV_UTILITY_PVT.Get_UserInfo(

Line 3738: IF (p_check_login_user = FND_API.G_TRUE) THEN

3734: x_login_id => l_login_user_id,
3735: x_user_status => l_login_user_status
3736: );
3737: -- check login user
3738: IF (p_check_login_user = FND_API.G_TRUE) THEN
3739: -- Check if user is login and has the required privilege.
3740: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3741: -- User is not login.
3742: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3740: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3736: );
3737: -- check login user
3738: IF (p_check_login_user = FND_API.G_TRUE) THEN
3739: -- Check if user is login and has the required privilege.
3740: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3741: -- User is not login.
3742: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3743: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3744: FND_MSG_PUB.Add;

Line 3746: RAISE FND_API.G_EXC_ERROR;

3742: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3743: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3744: FND_MSG_PUB.Add;
3745: END IF;
3746: RAISE FND_API.G_EXC_ERROR;
3747: END IF;
3748: END IF;
3749: -- This fix is for executing api in sqlplus mode
3750: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 3750: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3746: RAISE FND_API.G_EXC_ERROR;
3747: END IF;
3748: END IF;
3749: -- This fix is for executing api in sqlplus mode
3750: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3751: l_login_user_id := g_login_user_id;
3752: l_user_id := g_user_id;
3753: l_resource_id := g_resource_id;
3754: END IF;

Line 3756: x_return_status := FND_API.G_RET_STS_SUCCESS;

3752: l_user_id := g_user_id;
3753: l_resource_id := g_resource_id;
3754: END IF;
3755: -- Initialize API return status to sucess
3756: x_return_status := FND_API.G_RET_STS_SUCCESS;
3757:
3758: --
3759: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
3760:

Line 3774: RAISE FND_API.G_EXC_ERROR;

3770: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
3771: FND_MESSAGE.Set_Token('TKN',p_category_id);
3772: FND_MSG_PUB.Add;
3773: END IF;
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF;
3776: --
3777:
3778: -- Debug Message

Line 3786: p_encoded => FND_API.G_FALSE,

3782: FND_MSG_PUB.Add;
3783: END IF;
3784: --Standard call to get message count and if count=1, get the message
3785: FND_MSG_PUB.Count_And_Get (
3786: p_encoded => FND_API.G_FALSE,
3787: p_count => x_msg_count,
3788: p_data => x_msg_data
3789: );
3790: EXCEPTION

Line 3791: WHEN FND_API.G_EXC_ERROR THEN

3787: p_count => x_msg_count,
3788: p_data => x_msg_data
3789: );
3790: EXCEPTION
3791: WHEN FND_API.G_EXC_ERROR THEN
3792: ROLLBACK TO Get_CatChildrenHrPVT;
3793: x_return_status := FND_API.G_RET_STS_ERROR;
3794: -- Standard call to get message count and if count=1, get the message
3795: FND_MSG_PUB.Count_And_Get (

Line 3793: x_return_status := FND_API.G_RET_STS_ERROR;

3789: );
3790: EXCEPTION
3791: WHEN FND_API.G_EXC_ERROR THEN
3792: ROLLBACK TO Get_CatChildrenHrPVT;
3793: x_return_status := FND_API.G_RET_STS_ERROR;
3794: -- Standard call to get message count and if count=1, get the message
3795: FND_MSG_PUB.Count_And_Get (
3796: p_encoded => FND_API.G_FALSE,
3797: p_count => x_msg_count,

Line 3796: p_encoded => FND_API.G_FALSE,

3792: ROLLBACK TO Get_CatChildrenHrPVT;
3793: x_return_status := FND_API.G_RET_STS_ERROR;
3794: -- Standard call to get message count and if count=1, get the message
3795: FND_MSG_PUB.Count_And_Get (
3796: p_encoded => FND_API.G_FALSE,
3797: p_count => x_msg_count,
3798: p_data => x_msg_data
3799: );
3800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3796: p_encoded => FND_API.G_FALSE,
3797: p_count => x_msg_count,
3798: p_data => x_msg_data
3799: );
3800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3801: ROLLBACK TO Get_CatChildrenHrPVT;
3802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3803: -- Standard call to get message count and if count=1, get the message
3804: FND_MSG_PUB.Count_And_Get (

Line 3802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3798: p_data => x_msg_data
3799: );
3800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3801: ROLLBACK TO Get_CatChildrenHrPVT;
3802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3803: -- Standard call to get message count and if count=1, get the message
3804: FND_MSG_PUB.Count_And_Get (
3805: p_encoded => FND_API.G_FALSE,
3806: p_count => x_msg_count,

Line 3805: p_encoded => FND_API.G_FALSE,

3801: ROLLBACK TO Get_CatChildrenHrPVT;
3802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3803: -- Standard call to get message count and if count=1, get the message
3804: FND_MSG_PUB.Count_And_Get (
3805: p_encoded => FND_API.G_FALSE,
3806: p_count => x_msg_count,
3807: p_data => x_msg_data
3808: );
3809: WHEN OTHERS THEN

Line 3811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3807: p_data => x_msg_data
3808: );
3809: WHEN OTHERS THEN
3810: ROLLBACK TO Get_CatChildrenHrPVT;
3811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3812: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3813: THEN
3814: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3815: END IF;

Line 3818: p_encoded => FND_API.G_FALSE,

3814: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3815: END IF;
3816: -- Standard call to get message count and if count=1, get the message
3817: FND_MSG_PUB.Count_And_Get (
3818: p_encoded => FND_API.G_FALSE,
3819: p_count => x_msg_count,
3820: p_data => x_msg_data
3821: );
3822: --

Line 3836: -- Default = FND_API.G_FALSE

3832: -- for a channel id.
3833: -- Parameters :
3834: -- IN p_api_version IN NUMBER Required
3835: -- p_init_msg_list IN VARCHAR2 Optional
3836: -- Default = FND_API.G_FALSE
3837: -- p_validation_level IN NUMBER Optional
3838: -- Default = FND_API.G_VALID_LEVEL_FULL
3839: -- p_channel_id IN NUMBER Required
3840: -- channel id

Line 3838: -- Default = FND_API.G_VALID_LEVEL_FULL

3834: -- IN p_api_version IN NUMBER Required
3835: -- p_init_msg_list IN VARCHAR2 Optional
3836: -- Default = FND_API.G_FALSE
3837: -- p_validation_level IN NUMBER Optional
3838: -- Default = FND_API.G_VALID_LEVEL_FULL
3839: -- p_channel_id IN NUMBER Required
3840: -- channel id
3841: -- OUT : x_return_status OUT VARCHAR2
3842: -- x_msg_count OUT NUMBER

Line 3855: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3851: --
3852: --
3853: PROCEDURE Get_ChnCategoryHierarchy
3854: ( p_api_version IN NUMBER,
3855: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3857: x_return_status OUT NOCOPY VARCHAR2,
3858: x_msg_count OUT NOCOPY NUMBER,
3859: x_msg_data OUT NOCOPY VARCHAR2,

Line 3856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3852: --
3853: PROCEDURE Get_ChnCategoryHierarchy
3854: ( p_api_version IN NUMBER,
3855: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3857: x_return_status OUT NOCOPY VARCHAR2,
3858: x_msg_count OUT NOCOPY NUMBER,
3859: x_msg_data OUT NOCOPY VARCHAR2,
3860: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 3860: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

3856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3857: x_return_status OUT NOCOPY VARCHAR2,
3858: x_msg_count OUT NOCOPY NUMBER,
3859: x_msg_data OUT NOCOPY VARCHAR2,
3860: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
3861: p_channel_id IN NUMBER,
3862: x_channel_name OUT NOCOPY VARCHAR2,
3863: x_category_hierarchy OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
3864: )

Line 3895: IF NOT FND_API.Compatible_API_Call (

3891: BEGIN
3892: -- Standard begin of API savepoint
3893: SAVEPOINT Get_ChnCategoryHierarchy;
3894: -- Standard call to check for call compatibility.
3895: IF NOT FND_API.Compatible_API_Call (
3896: l_api_version,
3897: p_api_version,
3898: l_api_name,
3899: G_PKG_NAME)

Line 3901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3897: p_api_version,
3898: l_api_name,
3899: G_PKG_NAME)
3900: THEN
3901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3902: END IF;
3903: -- Debug Message
3904: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3905: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 3910: IF FND_API.To_Boolean (p_init_msg_list) THEN

3906: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3907: FND_MSG_PUB.Add;
3908: END IF;
3909: --Initialize message list if p_init_msg_list is TRUE.
3910: IF FND_API.To_Boolean (p_init_msg_list) THEN
3911: FND_MSG_PUB.initialize;
3912: END IF;
3913: -- Get the current (login) user id.
3914: AMV_UTILITY_PVT.Get_UserInfo(

Line 3921: IF (p_check_login_user = FND_API.G_TRUE) THEN

3917: x_login_id => l_login_user_id,
3918: x_user_status => l_login_user_status
3919: );
3920: -- check login user
3921: IF (p_check_login_user = FND_API.G_TRUE) THEN
3922: -- Check if user is login and has the required privilege.
3923: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3924: -- User is not login.
3925: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3923: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3919: );
3920: -- check login user
3921: IF (p_check_login_user = FND_API.G_TRUE) THEN
3922: -- Check if user is login and has the required privilege.
3923: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3924: -- User is not login.
3925: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3926: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3927: FND_MSG_PUB.Add;

Line 3929: RAISE FND_API.G_EXC_ERROR;

3925: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3926: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3927: FND_MSG_PUB.Add;
3928: END IF;
3929: RAISE FND_API.G_EXC_ERROR;
3930: END IF;
3931: END IF;
3932: -- This fix is for executing api in sqlplus mode
3933: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 3933: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

3929: RAISE FND_API.G_EXC_ERROR;
3930: END IF;
3931: END IF;
3932: -- This fix is for executing api in sqlplus mode
3933: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3934: l_login_user_id := g_login_user_id;
3935: l_user_id := g_user_id;
3936: l_resource_id := g_resource_id;
3937: END IF;

Line 3939: x_return_status := FND_API.G_RET_STS_SUCCESS;

3935: l_user_id := g_user_id;
3936: l_resource_id := g_resource_id;
3937: END IF;
3938: -- Initialize API return status to sucess
3939: x_return_status := FND_API.G_RET_STS_SUCCESS;
3940:
3941: --
3942: IF AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) THEN
3943: OPEN Get_ChannelData;

Line 3959: RAISE FND_API.G_EXC_ERROR;

3955: FND_MESSAGE.Set_Name('AMV', 'AMV_CHANNEL_ID_INVALID');
3956: FND_MESSAGE.Set_Token('TKN',p_channel_id);
3957: FND_MSG_PUB.Add;
3958: END IF;
3959: RAISE FND_API.G_EXC_ERROR;
3960: END IF;
3961: --
3962:
3963: -- Debug Message

Line 3971: p_encoded => FND_API.G_FALSE,

3967: FND_MSG_PUB.Add;
3968: END IF;
3969: --Standard call to get message count and if count=1, get the message
3970: FND_MSG_PUB.Count_And_Get (
3971: p_encoded => FND_API.G_FALSE,
3972: p_count => x_msg_count,
3973: p_data => x_msg_data
3974: );
3975: EXCEPTION

Line 3976: WHEN FND_API.G_EXC_ERROR THEN

3972: p_count => x_msg_count,
3973: p_data => x_msg_data
3974: );
3975: EXCEPTION
3976: WHEN FND_API.G_EXC_ERROR THEN
3977: ROLLBACK TO Get_ChnCategoryHierarchy;
3978: x_return_status := FND_API.G_RET_STS_ERROR;
3979: -- Standard call to get message count and if count=1, get the message
3980: FND_MSG_PUB.Count_And_Get (

Line 3978: x_return_status := FND_API.G_RET_STS_ERROR;

3974: );
3975: EXCEPTION
3976: WHEN FND_API.G_EXC_ERROR THEN
3977: ROLLBACK TO Get_ChnCategoryHierarchy;
3978: x_return_status := FND_API.G_RET_STS_ERROR;
3979: -- Standard call to get message count and if count=1, get the message
3980: FND_MSG_PUB.Count_And_Get (
3981: p_encoded => FND_API.G_FALSE,
3982: p_count => x_msg_count,

Line 3981: p_encoded => FND_API.G_FALSE,

3977: ROLLBACK TO Get_ChnCategoryHierarchy;
3978: x_return_status := FND_API.G_RET_STS_ERROR;
3979: -- Standard call to get message count and if count=1, get the message
3980: FND_MSG_PUB.Count_And_Get (
3981: p_encoded => FND_API.G_FALSE,
3982: p_count => x_msg_count,
3983: p_data => x_msg_data
3984: );
3985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3981: p_encoded => FND_API.G_FALSE,
3982: p_count => x_msg_count,
3983: p_data => x_msg_data
3984: );
3985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3986: ROLLBACK TO Get_ChnCategoryHierarchy;
3987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3988: -- Standard call to get message count and if count=1, get the message
3989: FND_MSG_PUB.Count_And_Get (

Line 3987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3983: p_data => x_msg_data
3984: );
3985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3986: ROLLBACK TO Get_ChnCategoryHierarchy;
3987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3988: -- Standard call to get message count and if count=1, get the message
3989: FND_MSG_PUB.Count_And_Get (
3990: p_encoded => FND_API.G_FALSE,
3991: p_count => x_msg_count,

Line 3990: p_encoded => FND_API.G_FALSE,

3986: ROLLBACK TO Get_ChnCategoryHierarchy;
3987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3988: -- Standard call to get message count and if count=1, get the message
3989: FND_MSG_PUB.Count_And_Get (
3990: p_encoded => FND_API.G_FALSE,
3991: p_count => x_msg_count,
3992: p_data => x_msg_data
3993: );
3994: WHEN OTHERS THEN

Line 3996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3992: p_data => x_msg_data
3993: );
3994: WHEN OTHERS THEN
3995: ROLLBACK TO Get_ChnCategoryHierarchy;
3996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3997: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3998: THEN
3999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4000: END IF;

Line 4003: p_encoded => FND_API.G_FALSE,

3999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4000: END IF;
4001: -- Standard call to get message count and if count=1, get the message
4002: FND_MSG_PUB.Count_And_Get (
4003: p_encoded => FND_API.G_FALSE,
4004: p_count => x_msg_count,
4005: p_data => x_msg_data
4006: );
4007: --

Line 4020: -- Default = FND_API.G_FALSE

4016: -- Function : attaches a category to a parent category
4017: -- Parameters :
4018: -- IN p_api_version IN NUMBER Required
4019: -- p_init_msg_list IN VARCHAR2 Optional
4020: -- Default = FND_API.G_FALSE
4021: -- p_validation_level IN NUMBER Optional
4022: -- Default = FND_API.G_VALID_LEVEL_FULL
4023: -- p_category_id IN NUMBER Required
4024: -- category id

Line 4022: -- Default = FND_API.G_VALID_LEVEL_FULL

4018: -- IN p_api_version IN NUMBER Required
4019: -- p_init_msg_list IN VARCHAR2 Optional
4020: -- Default = FND_API.G_FALSE
4021: -- p_validation_level IN NUMBER Optional
4022: -- Default = FND_API.G_VALID_LEVEL_FULL
4023: -- p_category_id IN NUMBER Required
4024: -- category id
4025: -- p_parent_category_id IN NUMBER Required
4026: -- parent category id

Line 4028: -- Default = FND_API.G_FALSE

4024: -- category id
4025: -- p_parent_category_id IN NUMBER Required
4026: -- parent category id
4027: -- p_replace_existing IN VARCHAR2 Optional
4028: -- Default = FND_API.G_FALSE
4029: -- OUT : x_return_status OUT VARCHAR2
4030: -- x_msg_count OUT NUMBER
4031: -- x_msg_data OUT VARCHAR2
4032: -- Version : Current version 1.0

Line 4041: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4037: --
4038: --
4039: PROCEDURE Add_CategoryParent
4040: ( p_api_version IN NUMBER,
4041: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4042: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4043: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4044: x_return_status OUT NOCOPY VARCHAR2,
4045: x_msg_count OUT NOCOPY NUMBER,

Line 4042: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4038: --
4039: PROCEDURE Add_CategoryParent
4040: ( p_api_version IN NUMBER,
4041: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4042: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4043: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4044: x_return_status OUT NOCOPY VARCHAR2,
4045: x_msg_count OUT NOCOPY NUMBER,
4046: x_msg_data OUT NOCOPY VARCHAR2,

Line 4043: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4039: PROCEDURE Add_CategoryParent
4040: ( p_api_version IN NUMBER,
4041: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4042: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4043: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4044: x_return_status OUT NOCOPY VARCHAR2,
4045: x_msg_count OUT NOCOPY NUMBER,
4046: x_msg_data OUT NOCOPY VARCHAR2,
4047: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 4047: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

4043: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4044: x_return_status OUT NOCOPY VARCHAR2,
4045: x_msg_count OUT NOCOPY NUMBER,
4046: x_msg_data OUT NOCOPY VARCHAR2,
4047: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
4048: p_object_version_number IN NUMBER,
4049: p_category_id IN NUMBER,
4050: p_parent_category_id IN NUMBER,
4051: p_replace_existing IN VARCHAR2 := FND_API.G_FALSE

Line 4051: p_replace_existing IN VARCHAR2 := FND_API.G_FALSE

4047: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
4048: p_object_version_number IN NUMBER,
4049: p_category_id IN NUMBER,
4050: p_parent_category_id IN NUMBER,
4051: p_replace_existing IN VARCHAR2 := FND_API.G_FALSE
4052: )
4053: IS
4054: l_api_name CONSTANT VARCHAR2(30) := 'Add_CategoryParent';
4055: l_api_version CONSTANT NUMBER := 1.0;

Line 4072: l_update_flag varchar2(1) := FND_API.G_FALSE;

4068: l_object_version_number number;
4069: l_application_id number;
4070: l_order number;
4071: l_channel_count number;
4072: l_update_flag varchar2(1) := FND_API.G_FALSE;
4073: l_subcat_name varchar2(80);
4074: l_cat_name varchar2(80);
4075: --
4076: CURSOR Get_ParentId IS

Line 4096: IF NOT FND_API.Compatible_API_Call (

4092: BEGIN
4093: -- Standard begin of API savepoint
4094: SAVEPOINT Add_CategoryParent;
4095: -- Standard call to check for call compatibility.
4096: IF NOT FND_API.Compatible_API_Call (
4097: l_api_version,
4098: p_api_version,
4099: l_api_name,
4100: G_PKG_NAME)

Line 4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4098: p_api_version,
4099: l_api_name,
4100: G_PKG_NAME)
4101: THEN
4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4103: END IF;
4104: -- Debug Message
4105: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4106: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 4111: IF FND_API.To_Boolean (p_init_msg_list) THEN

4107: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4108: FND_MSG_PUB.Add;
4109: END IF;
4110: --Initialize message list if p_init_msg_list is TRUE.
4111: IF FND_API.To_Boolean (p_init_msg_list) THEN
4112: FND_MSG_PUB.initialize;
4113: END IF;
4114: -- Get the current (login) user id.
4115: AMV_UTILITY_PVT.Get_UserInfo(

Line 4122: IF (p_check_login_user = FND_API.G_TRUE) THEN

4118: x_login_id => l_login_user_id,
4119: x_user_status => l_login_user_status
4120: );
4121: -- check login user
4122: IF (p_check_login_user = FND_API.G_TRUE) THEN
4123: -- Check if user is login and has the required privilege.
4124: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4125: -- User is not login.
4126: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 4124: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

4120: );
4121: -- check login user
4122: IF (p_check_login_user = FND_API.G_TRUE) THEN
4123: -- Check if user is login and has the required privilege.
4124: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4125: -- User is not login.
4126: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4127: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4128: FND_MSG_PUB.Add;

Line 4130: RAISE FND_API.G_EXC_ERROR;

4126: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4127: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4128: FND_MSG_PUB.Add;
4129: END IF;
4130: RAISE FND_API.G_EXC_ERROR;
4131: END IF;
4132: END IF;
4133: -- This fix is for executing api in sqlplus mode
4134: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 4134: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

4130: RAISE FND_API.G_EXC_ERROR;
4131: END IF;
4132: END IF;
4133: -- This fix is for executing api in sqlplus mode
4134: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4135: l_login_user_id := g_login_user_id;
4136: l_user_id := g_user_id;
4137: l_resource_id := g_resource_id;
4138: END IF;

Line 4140: x_return_status := FND_API.G_RET_STS_SUCCESS;

4136: l_user_id := g_user_id;
4137: l_resource_id := g_resource_id;
4138: END IF;
4139: -- Initialize API return status to sucess
4140: x_return_status := FND_API.G_RET_STS_SUCCESS;
4141:
4142: --
4143: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
4144: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_parent_category_id) THEN

Line 4154: l_update_flag := FND_API.G_TRUE;

4150: l_order,
4151: l_channel_count;
4152: CLOSE Get_ParentId;
4153: IF l_parent_category_id is null THEN
4154: l_update_flag := FND_API.G_TRUE;
4155: ELSE
4156: IF p_replace_existing = FND_API.G_TRUE THEN
4157: l_update_flag := FND_API.G_TRUE;
4158: ELSE

Line 4156: IF p_replace_existing = FND_API.G_TRUE THEN

4152: CLOSE Get_ParentId;
4153: IF l_parent_category_id is null THEN
4154: l_update_flag := FND_API.G_TRUE;
4155: ELSE
4156: IF p_replace_existing = FND_API.G_TRUE THEN
4157: l_update_flag := FND_API.G_TRUE;
4158: ELSE
4159: l_update_flag := FND_API.G_FALSE;
4160: END IF;

Line 4157: l_update_flag := FND_API.G_TRUE;

4153: IF l_parent_category_id is null THEN
4154: l_update_flag := FND_API.G_TRUE;
4155: ELSE
4156: IF p_replace_existing = FND_API.G_TRUE THEN
4157: l_update_flag := FND_API.G_TRUE;
4158: ELSE
4159: l_update_flag := FND_API.G_FALSE;
4160: END IF;
4161: END IF;

Line 4159: l_update_flag := FND_API.G_FALSE;

4155: ELSE
4156: IF p_replace_existing = FND_API.G_TRUE THEN
4157: l_update_flag := FND_API.G_TRUE;
4158: ELSE
4159: l_update_flag := FND_API.G_FALSE;
4160: END IF;
4161: END IF;
4162: ELSE
4163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 4169: RAISE FND_API.G_EXC_ERROR;

4165: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
4166: FND_MESSAGE.Set_Token('TKN',p_parent_category_id);
4167: FND_MSG_PUB.Add;
4168: END IF;
4169: RAISE FND_API.G_EXC_ERROR;
4170: END IF;
4171: ELSE
4172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4173: THEN

Line 4178: RAISE FND_API.G_EXC_ERROR;

4174: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
4175: FND_MESSAGE.Set_Token('TKN',p_category_id);
4176: FND_MSG_PUB.Add;
4177: END IF;
4178: RAISE FND_API.G_EXC_ERROR;
4179: END IF;
4180:
4181:
4182: -- update parent

Line 4183: IF l_update_flag = FND_API.G_TRUE THEN

4179: END IF;
4180:
4181:
4182: -- update parent
4183: IF l_update_flag = FND_API.G_TRUE THEN
4184: IF p_object_version_number = l_object_version_number THEN
4185: -- check to see if parent is not its child
4186: l_category_hr := amv_cat_hierarchy_varray_type();
4187: Get_CategoryHierarchy(p_category_id, l_category_level, l_category_hr);

Line 4190: l_update_flag := FND_API.G_FALSE;

4186: l_category_hr := amv_cat_hierarchy_varray_type();
4187: Get_CategoryHierarchy(p_category_id, l_category_level, l_category_hr);
4188: FOR i in 1..l_category_hr.count LOOP
4189: IF l_category_hr(i).id = p_parent_category_id THEN
4190: l_update_flag := FND_API.G_FALSE;
4191: END IF;
4192: EXIT WHEN l_category_hr(i).id = p_parent_category_id;
4193: END LOOP;
4194: IF l_update_flag = FND_API.G_FALSE THEN

Line 4194: IF l_update_flag = FND_API.G_FALSE THEN

4190: l_update_flag := FND_API.G_FALSE;
4191: END IF;
4192: EXIT WHEN l_category_hr(i).id = p_parent_category_id;
4193: END LOOP;
4194: IF l_update_flag = FND_API.G_FALSE THEN
4195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4196: THEN
4197: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_PARENT_LOOPING');
4198: FND_MESSAGE.Set_Token('TKN',p_parent_category_id);

Line 4201: RAISE FND_API.G_EXC_ERROR;

4197: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_PARENT_LOOPING');
4198: FND_MESSAGE.Set_Token('TKN',p_parent_category_id);
4199: FND_MSG_PUB.Add;
4200: END IF;
4201: RAISE FND_API.G_EXC_ERROR;
4202: END IF;
4203:
4204: -- check to see if no other category exist with same name under parent
4205: OPEN Get_SubCatName;

Line 4210: l_update_flag := FND_API.G_FALSE;

4206: LOOP
4207: FETCH Get_SubCatName INTO l_subcat_name;
4208: EXIT WHEN Get_SubCatName%NOTFOUND;
4209: IF UPPER(l_subcat_name) = UPPER(l_cat_name) THEN
4210: l_update_flag := FND_API.G_FALSE;
4211: END IF;
4212: EXIT WHEN UPPER(l_subcat_name) = UPPER(l_cat_name);
4213: END LOOP;
4214: CLOSE Get_SubCatName;

Line 4215: IF l_update_flag = FND_API.G_FALSE THEN

4211: END IF;
4212: EXIT WHEN UPPER(l_subcat_name) = UPPER(l_cat_name);
4213: END LOOP;
4214: CLOSE Get_SubCatName;
4215: IF l_update_flag = FND_API.G_FALSE THEN
4216: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4217: THEN
4218: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_NAME_EXISTS');
4219: FND_MESSAGE.Set_Token('TKN',p_category_id);

Line 4222: RAISE FND_API.G_EXC_ERROR;

4218: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_NAME_EXISTS');
4219: FND_MESSAGE.Set_Token('TKN',p_category_id);
4220: FND_MSG_PUB.Add;
4221: END IF;
4222: RAISE FND_API.G_EXC_ERROR;
4223: END IF;
4224:
4225: BEGIN
4226: AMV_C_CATEGORIES_PKG.UPDATE_B_ROW(

Line 4247: RAISE FND_API.G_EXC_ERROR;

4243: FND_MESSAGE.Set_Token('ACTION', 'Updating');
4244: FND_MESSAGE.Set_Token('TABLE', 'Categories');
4245: FND_MSG_PUB.Add;
4246: END IF;
4247: RAISE FND_API.G_EXC_ERROR;
4248: END;
4249: ELSE
4250: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4251: THEN

Line 4255: RAISE FND_API.G_EXC_ERROR;

4251: THEN
4252: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');
4253: FND_MSG_PUB.Add;
4254: END IF;
4255: RAISE FND_API.G_EXC_ERROR;
4256: END IF;
4257: ELSE
4258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4259: THEN

Line 4264: RAISE FND_API.G_EXC_ERROR;

4260: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_PARENT_EXISTS');
4261: FND_MESSAGE.Set_Token('TKN',l_parent_category_id);
4262: FND_MSG_PUB.Add;
4263: END IF;
4264: RAISE FND_API.G_EXC_ERROR;
4265: END IF;
4266: --
4267:
4268: --Standard check of commit

Line 4269: IF FND_API.To_Boolean ( p_commit ) THEN

4265: END IF;
4266: --
4267:
4268: --Standard check of commit
4269: IF FND_API.To_Boolean ( p_commit ) THEN
4270: COMMIT WORK;
4271: END IF;
4272:
4273: -- Debug Message

Line 4281: p_encoded => FND_API.G_FALSE,

4277: FND_MSG_PUB.Add;
4278: END IF;
4279: --Standard call to get message count and if count=1, get the message
4280: FND_MSG_PUB.Count_And_Get (
4281: p_encoded => FND_API.G_FALSE,
4282: p_count => x_msg_count,
4283: p_data => x_msg_data
4284: );
4285: EXCEPTION

Line 4286: WHEN FND_API.G_EXC_ERROR THEN

4282: p_count => x_msg_count,
4283: p_data => x_msg_data
4284: );
4285: EXCEPTION
4286: WHEN FND_API.G_EXC_ERROR THEN
4287: ROLLBACK TO Add_CategoryParent;
4288: x_return_status := FND_API.G_RET_STS_ERROR;
4289: -- Standard call to get message count and if count=1, get the message
4290: FND_MSG_PUB.Count_And_Get (

Line 4288: x_return_status := FND_API.G_RET_STS_ERROR;

4284: );
4285: EXCEPTION
4286: WHEN FND_API.G_EXC_ERROR THEN
4287: ROLLBACK TO Add_CategoryParent;
4288: x_return_status := FND_API.G_RET_STS_ERROR;
4289: -- Standard call to get message count and if count=1, get the message
4290: FND_MSG_PUB.Count_And_Get (
4291: p_encoded => FND_API.G_FALSE,
4292: p_count => x_msg_count,

Line 4291: p_encoded => FND_API.G_FALSE,

4287: ROLLBACK TO Add_CategoryParent;
4288: x_return_status := FND_API.G_RET_STS_ERROR;
4289: -- Standard call to get message count and if count=1, get the message
4290: FND_MSG_PUB.Count_And_Get (
4291: p_encoded => FND_API.G_FALSE,
4292: p_count => x_msg_count,
4293: p_data => x_msg_data
4294: );
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4291: p_encoded => FND_API.G_FALSE,
4292: p_count => x_msg_count,
4293: p_data => x_msg_data
4294: );
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: ROLLBACK TO Add_CategoryParent;
4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4298: -- Standard call to get message count and if count=1, get the message
4299: FND_MSG_PUB.Count_And_Get (

Line 4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4293: p_data => x_msg_data
4294: );
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: ROLLBACK TO Add_CategoryParent;
4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4298: -- Standard call to get message count and if count=1, get the message
4299: FND_MSG_PUB.Count_And_Get (
4300: p_encoded => FND_API.G_FALSE,
4301: p_count => x_msg_count,

Line 4300: p_encoded => FND_API.G_FALSE,

4296: ROLLBACK TO Add_CategoryParent;
4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4298: -- Standard call to get message count and if count=1, get the message
4299: FND_MSG_PUB.Count_And_Get (
4300: p_encoded => FND_API.G_FALSE,
4301: p_count => x_msg_count,
4302: p_data => x_msg_data
4303: );
4304: WHEN OTHERS THEN

Line 4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4302: p_data => x_msg_data
4303: );
4304: WHEN OTHERS THEN
4305: ROLLBACK TO Add_CategoryParent;
4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4307: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4308: THEN
4309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4310: END IF;

Line 4313: p_encoded => FND_API.G_FALSE,

4309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4310: END IF;
4311: -- Standard call to get message count and if count=1, get the message
4312: FND_MSG_PUB.Count_And_Get (
4313: p_encoded => FND_API.G_FALSE,
4314: p_count => x_msg_count,
4315: p_data => x_msg_data
4316: );
4317: --

Line 4330: -- Default = FND_API.G_FALSE

4326: -- Function : removes a category to from a parent category
4327: -- Parameters :
4328: -- IN p_api_version IN NUMBER Required
4329: -- p_init_msg_list IN VARCHAR2 Optional
4330: -- Default = FND_API.G_FALSE
4331: -- p_validation_level IN NUMBER Optional
4332: -- Default = FND_API.G_VALID_LEVEL_FULL
4333: -- p_category_id IN NUMBER Required
4334: -- category id

Line 4332: -- Default = FND_API.G_VALID_LEVEL_FULL

4328: -- IN p_api_version IN NUMBER Required
4329: -- p_init_msg_list IN VARCHAR2 Optional
4330: -- Default = FND_API.G_FALSE
4331: -- p_validation_level IN NUMBER Optional
4332: -- Default = FND_API.G_VALID_LEVEL_FULL
4333: -- p_category_id IN NUMBER Required
4334: -- category id
4335: -- OUT : x_return_status OUT VARCHAR2
4336: -- x_msg_count OUT NUMBER

Line 4347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4343: --
4344: --
4345: PROCEDURE Remove_CategoryParent
4346: ( p_api_version IN NUMBER,
4347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4350: x_return_status OUT NOCOPY VARCHAR2,
4351: x_msg_count OUT NOCOPY NUMBER,

Line 4348: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4344: --
4345: PROCEDURE Remove_CategoryParent
4346: ( p_api_version IN NUMBER,
4347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4350: x_return_status OUT NOCOPY VARCHAR2,
4351: x_msg_count OUT NOCOPY NUMBER,
4352: x_msg_data OUT NOCOPY VARCHAR2,

Line 4349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4345: PROCEDURE Remove_CategoryParent
4346: ( p_api_version IN NUMBER,
4347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4350: x_return_status OUT NOCOPY VARCHAR2,
4351: x_msg_count OUT NOCOPY NUMBER,
4352: x_msg_data OUT NOCOPY VARCHAR2,
4353: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 4353: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

4349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4350: x_return_status OUT NOCOPY VARCHAR2,
4351: x_msg_count OUT NOCOPY NUMBER,
4352: x_msg_data OUT NOCOPY VARCHAR2,
4353: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
4354: p_object_version_number IN NUMBER,
4355: p_category_id IN NUMBER
4356: )
4357: IS

Line 4388: IF NOT FND_API.Compatible_API_Call (

4384: BEGIN
4385: -- Standard begin of API savepoint
4386: SAVEPOINT Remove_CategoryParent;
4387: -- Standard call to check for call compatibility.
4388: IF NOT FND_API.Compatible_API_Call (
4389: l_api_version,
4390: p_api_version,
4391: l_api_name,
4392: G_PKG_NAME)

Line 4394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4390: p_api_version,
4391: l_api_name,
4392: G_PKG_NAME)
4393: THEN
4394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4395: END IF;
4396: -- Debug Message
4397: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4398: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

Line 4403: IF FND_API.To_Boolean (p_init_msg_list) THEN

4399: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4400: FND_MSG_PUB.Add;
4401: END IF;
4402: --Initialize message list if p_init_msg_list is TRUE.
4403: IF FND_API.To_Boolean (p_init_msg_list) THEN
4404: FND_MSG_PUB.initialize;
4405: END IF;
4406: -- Get the current (login) user id.
4407: AMV_UTILITY_PVT.Get_UserInfo(

Line 4414: IF (p_check_login_user = FND_API.G_TRUE) THEN

4410: x_login_id => l_login_user_id,
4411: x_user_status => l_login_user_status
4412: );
4413: -- check login user
4414: IF (p_check_login_user = FND_API.G_TRUE) THEN
4415: -- Check if user is login and has the required privilege.
4416: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4417: -- User is not login.
4418: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 4416: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

4412: );
4413: -- check login user
4414: IF (p_check_login_user = FND_API.G_TRUE) THEN
4415: -- Check if user is login and has the required privilege.
4416: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4417: -- User is not login.
4418: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4419: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4420: FND_MSG_PUB.Add;

Line 4422: RAISE FND_API.G_EXC_ERROR;

4418: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4419: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4420: FND_MSG_PUB.Add;
4421: END IF;
4422: RAISE FND_API.G_EXC_ERROR;
4423: END IF;
4424: END IF;
4425: -- This fix is for executing api in sqlplus mode
4426: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 4426: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

4422: RAISE FND_API.G_EXC_ERROR;
4423: END IF;
4424: END IF;
4425: -- This fix is for executing api in sqlplus mode
4426: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4427: l_login_user_id := g_login_user_id;
4428: l_user_id := g_user_id;
4429: l_resource_id := g_resource_id;
4430: END IF;

Line 4432: x_return_status := FND_API.G_RET_STS_SUCCESS;

4428: l_user_id := g_user_id;
4429: l_resource_id := g_resource_id;
4430: END IF;
4431: -- Initialize API return status to sucess
4432: x_return_status := FND_API.G_RET_STS_SUCCESS;
4433:
4434: --
4435: IF AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) THEN
4436: OPEN Get_ParentId;

Line 4468: RAISE FND_API.G_EXC_ERROR;

4464: FND_MESSAGE.Set_Token('ACTION', 'Updating');
4465: FND_MESSAGE.Set_Token('TABLE', 'Categories');
4466: FND_MSG_PUB.Add;
4467: END IF;
4468: RAISE FND_API.G_EXC_ERROR;
4469: END;
4470: ELSE
4471: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4472: THEN

Line 4476: RAISE FND_API.G_EXC_ERROR;

4472: THEN
4473: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');
4474: FND_MSG_PUB.Add;
4475: END IF;
4476: RAISE FND_API.G_EXC_ERROR;
4477: END IF;
4478: ELSE
4479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4480: THEN

Line 4485: RAISE FND_API.G_EXC_ERROR;

4481: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
4482: FND_MESSAGE.Set_Token('TKN',p_category_id);
4483: FND_MSG_PUB.Add;
4484: END IF;
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;
4487: --
4488:
4489: --Standard check of commit

Line 4490: IF FND_API.To_Boolean ( p_commit ) THEN

4486: END IF;
4487: --
4488:
4489: --Standard check of commit
4490: IF FND_API.To_Boolean ( p_commit ) THEN
4491: COMMIT WORK;
4492: END IF;
4493:
4494: -- Debug Message

Line 4502: p_encoded => FND_API.G_FALSE,

4498: FND_MSG_PUB.Add;
4499: END IF;
4500: --Standard call to get message count and if count=1, get the message
4501: FND_MSG_PUB.Count_And_Get (
4502: p_encoded => FND_API.G_FALSE,
4503: p_count => x_msg_count,
4504: p_data => x_msg_data
4505: );
4506: EXCEPTION

Line 4507: WHEN FND_API.G_EXC_ERROR THEN

4503: p_count => x_msg_count,
4504: p_data => x_msg_data
4505: );
4506: EXCEPTION
4507: WHEN FND_API.G_EXC_ERROR THEN
4508: ROLLBACK TO Remove_CategoryParent;
4509: x_return_status := FND_API.G_RET_STS_ERROR;
4510: -- Standard call to get message count and if count=1, get the message
4511: FND_MSG_PUB.Count_And_Get (

Line 4509: x_return_status := FND_API.G_RET_STS_ERROR;

4505: );
4506: EXCEPTION
4507: WHEN FND_API.G_EXC_ERROR THEN
4508: ROLLBACK TO Remove_CategoryParent;
4509: x_return_status := FND_API.G_RET_STS_ERROR;
4510: -- Standard call to get message count and if count=1, get the message
4511: FND_MSG_PUB.Count_And_Get (
4512: p_encoded => FND_API.G_FALSE,
4513: p_count => x_msg_count,

Line 4512: p_encoded => FND_API.G_FALSE,

4508: ROLLBACK TO Remove_CategoryParent;
4509: x_return_status := FND_API.G_RET_STS_ERROR;
4510: -- Standard call to get message count and if count=1, get the message
4511: FND_MSG_PUB.Count_And_Get (
4512: p_encoded => FND_API.G_FALSE,
4513: p_count => x_msg_count,
4514: p_data => x_msg_data
4515: );
4516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4512: p_encoded => FND_API.G_FALSE,
4513: p_count => x_msg_count,
4514: p_data => x_msg_data
4515: );
4516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4517: ROLLBACK TO Remove_CategoryParent;
4518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4519: -- Standard call to get message count and if count=1, get the message
4520: FND_MSG_PUB.Count_And_Get (

Line 4518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4514: p_data => x_msg_data
4515: );
4516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4517: ROLLBACK TO Remove_CategoryParent;
4518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4519: -- Standard call to get message count and if count=1, get the message
4520: FND_MSG_PUB.Count_And_Get (
4521: p_encoded => FND_API.G_FALSE,
4522: p_count => x_msg_count,

Line 4521: p_encoded => FND_API.G_FALSE,

4517: ROLLBACK TO Remove_CategoryParent;
4518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4519: -- Standard call to get message count and if count=1, get the message
4520: FND_MSG_PUB.Count_And_Get (
4521: p_encoded => FND_API.G_FALSE,
4522: p_count => x_msg_count,
4523: p_data => x_msg_data
4524: );
4525: WHEN OTHERS THEN

Line 4527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4523: p_data => x_msg_data
4524: );
4525: WHEN OTHERS THEN
4526: ROLLBACK TO Remove_CategoryParent;
4527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4528: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4529: THEN
4530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4531: END IF;

Line 4534: p_encoded => FND_API.G_FALSE,

4530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4531: END IF;
4532: -- Standard call to get message count and if count=1, get the message
4533: FND_MSG_PUB.Count_And_Get (
4534: p_encoded => FND_API.G_FALSE,
4535: p_count => x_msg_count,
4536: p_data => x_msg_data
4537: );
4538: --