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

Line 42: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

38: -- 1. Raise exception if the object_version_number doesn't match.
39: --------------------------------------------------------------------
40: PROCEDURE Lock_ListField (
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
43: p_commit IN VARCHAR2 := FND_API.g_false,
44: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
45:
46: x_return_status OUT VARCHAR2,

Line 43: p_commit IN VARCHAR2 := FND_API.g_false,

39: --------------------------------------------------------------------
40: PROCEDURE Lock_ListField (
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
43: p_commit IN VARCHAR2 := FND_API.g_false,
44: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
45:
46: x_return_status OUT VARCHAR2,
47: x_msg_count OUT NUMBER,

Line 44: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

40: PROCEDURE Lock_ListField (
41: p_api_version IN NUMBER,
42: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
43: p_commit IN VARCHAR2 := FND_API.g_false,
44: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
45:
46: x_return_status OUT VARCHAR2,
47: x_msg_count OUT NUMBER,
48: x_msg_data OUT VARCHAR2,

Line 77: IF FND_API.to_boolean (p_init_msg_list) THEN

73: BEGIN
74: --------------------- initialize -----------------------
75: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
76:
77: IF FND_API.to_boolean (p_init_msg_list) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: IF NOT FND_API.compatible_api_call (

Line 81: IF NOT FND_API.compatible_api_call (

77: IF FND_API.to_boolean (p_init_msg_list) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: IF NOT FND_API.compatible_api_call (
82: l_api_version,
83: p_api_version,
84: l_api_name,
85: g_pkg_name

Line 87: RAISE FND_API.g_exc_unexpected_error;

83: p_api_version,
84: l_api_name,
85: g_pkg_name
86: ) THEN
87: RAISE FND_API.g_exc_unexpected_error;
88: END IF;
89:
90: x_return_status := FND_API.g_ret_sts_success;
91:

Line 90: x_return_status := FND_API.g_ret_sts_success;

86: ) THEN
87: RAISE FND_API.g_exc_unexpected_error;
88: END IF;
89:
90: x_return_status := FND_API.g_ret_sts_success;
91:
92: ------------------------ lock -------------------------
93: OPEN c_lock_req;
94: FETCH c_lock_req INTO l_dummy;

Line 101: RAISE FND_API.g_exc_error;

97: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
98: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
99: FND_MSG_PUB.add;
100: END IF;
101: RAISE FND_API.g_exc_error;
102: END IF;
103: CLOSE c_lock_req;
104:
105: -------------------- finish --------------------------

Line 107: p_encoded => FND_API.g_false,

103: CLOSE c_lock_req;
104:
105: -------------------- finish --------------------------
106: FND_MSG_PUB.count_and_get (
107: p_encoded => FND_API.g_false,
108: p_count => x_msg_count,
109: p_data => x_msg_data
110: );
111:

Line 116: x_return_status := FND_API.g_ret_sts_error;

112: AMS_Utility_PVT.debug_message (l_full_name || ': End');
113:
114: EXCEPTION
115: WHEN AMS_Utility_PVT.resource_locked THEN
116: x_return_status := FND_API.g_ret_sts_error;
117: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
118: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
119: FND_MSG_PUB.add;
120: END IF;

Line 123: p_encoded => FND_API.g_false,

119: FND_MSG_PUB.add;
120: END IF;
121:
122: FND_MSG_PUB.count_and_get(
123: p_encoded => FND_API.g_false,
124: p_count => x_msg_count,
125: p_data => x_msg_data
126: );
127: WHEN FND_API.g_exc_error THEN

Line 127: WHEN FND_API.g_exc_error THEN

123: p_encoded => FND_API.g_false,
124: p_count => x_msg_count,
125: p_data => x_msg_data
126: );
127: WHEN FND_API.g_exc_error THEN
128: x_return_status := FND_API.g_ret_sts_error;
129: FND_MSG_PUB.count_and_get (
130: p_encoded => FND_API.g_false,
131: p_count => x_msg_count,

Line 128: x_return_status := FND_API.g_ret_sts_error;

124: p_count => x_msg_count,
125: p_data => x_msg_data
126: );
127: WHEN FND_API.g_exc_error THEN
128: x_return_status := FND_API.g_ret_sts_error;
129: FND_MSG_PUB.count_and_get (
130: p_encoded => FND_API.g_false,
131: p_count => x_msg_count,
132: p_data => x_msg_data

Line 130: p_encoded => FND_API.g_false,

126: );
127: WHEN FND_API.g_exc_error THEN
128: x_return_status := FND_API.g_ret_sts_error;
129: FND_MSG_PUB.count_and_get (
130: p_encoded => FND_API.g_false,
131: p_count => x_msg_count,
132: p_data => x_msg_data
133: );
134: WHEN FND_API.g_exc_unexpected_error THEN

Line 134: WHEN FND_API.g_exc_unexpected_error THEN

130: p_encoded => FND_API.g_false,
131: p_count => x_msg_count,
132: p_data => x_msg_data
133: );
134: WHEN FND_API.g_exc_unexpected_error THEN
135: x_return_status := FND_API.g_ret_sts_unexp_error ;
136: FND_MSG_PUB.count_and_get (
137: p_encoded => FND_API.g_false,
138: p_count => x_msg_count,

Line 135: x_return_status := FND_API.g_ret_sts_unexp_error ;

131: p_count => x_msg_count,
132: p_data => x_msg_data
133: );
134: WHEN FND_API.g_exc_unexpected_error THEN
135: x_return_status := FND_API.g_ret_sts_unexp_error ;
136: FND_MSG_PUB.count_and_get (
137: p_encoded => FND_API.g_false,
138: p_count => x_msg_count,
139: p_data => x_msg_data

Line 137: p_encoded => FND_API.g_false,

133: );
134: WHEN FND_API.g_exc_unexpected_error THEN
135: x_return_status := FND_API.g_ret_sts_unexp_error ;
136: FND_MSG_PUB.count_and_get (
137: p_encoded => FND_API.g_false,
138: p_count => x_msg_count,
139: p_data => x_msg_data
140: );
141: WHEN OTHERS THEN

Line 142: x_return_status := FND_API.g_ret_sts_unexp_error ;

138: p_count => x_msg_count,
139: p_data => x_msg_data
140: );
141: WHEN OTHERS THEN
142: x_return_status := FND_API.g_ret_sts_unexp_error ;
143: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
144: THEN
145: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
146: END IF;

Line 149: p_encoded => FND_API.g_false,

145: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
146: END IF;
147:
148: FND_MSG_PUB.count_and_get (
149: p_encoded => FND_API.g_false,
150: p_count => x_msg_count,
151: p_data => x_msg_data
152: );
153: END Lock_ListField;

Line 168: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

164: -- p_listfield_rec: the record representing AMS_LIST_FIELDS_VL.
165: --
166: -- NOTES
167: -- 1. Raise exception if the object_version_number doesn't match.
168: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
169: -- that column won't be updated.
170: --------------------------------------------------------------------
171: PROCEDURE Update_ListField (
172: p_api_version IN NUMBER,

Line 173: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

169: -- that column won't be updated.
170: --------------------------------------------------------------------
171: PROCEDURE Update_ListField (
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
174: p_commit IN VARCHAR2 := FND_API.g_false,
175: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
176:
177: x_return_status OUT VARCHAR2,

Line 174: p_commit IN VARCHAR2 := FND_API.g_false,

170: --------------------------------------------------------------------
171: PROCEDURE Update_ListField (
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
174: p_commit IN VARCHAR2 := FND_API.g_false,
175: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
176:
177: x_return_status OUT VARCHAR2,
178: x_msg_count OUT NUMBER,

Line 175: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

171: PROCEDURE Update_ListField (
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
174: p_commit IN VARCHAR2 := FND_API.g_false,
175: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
176:
177: x_return_status OUT VARCHAR2,
178: x_msg_count OUT NUMBER,
179: x_msg_data OUT VARCHAR2,

Line 196: IF FND_API.to_boolean (p_init_msg_list) THEN

192: SAVEPOINT Update_ListField;
193:
194: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
195:
196: IF FND_API.to_boolean (p_init_msg_list) THEN
197: FND_MSG_PUB.initialize;
198: END IF;
199:
200: IF NOT FND_API.compatible_api_call(

Line 200: IF NOT FND_API.compatible_api_call(

196: IF FND_API.to_boolean (p_init_msg_list) THEN
197: FND_MSG_PUB.initialize;
198: END IF;
199:
200: IF NOT FND_API.compatible_api_call(
201: l_api_version,
202: p_api_version,
203: l_api_name,
204: g_pkg_name

Line 206: RAISE FND_API.g_exc_unexpected_error;

202: p_api_version,
203: l_api_name,
204: g_pkg_name
205: ) THEN
206: RAISE FND_API.g_exc_unexpected_error;
207: END IF;
208:
209: x_return_status := FND_API.g_ret_sts_success;
210:

Line 209: x_return_status := FND_API.g_ret_sts_success;

205: ) THEN
206: RAISE FND_API.g_exc_unexpected_error;
207: END IF;
208:
209: x_return_status := FND_API.g_ret_sts_success;
210:
211: ----------------------- validate ----------------------
212: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
213:

Line 224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

220: p_validation_mode => JTF_PLSQL_API.g_update,
221: x_return_status => l_return_status
222: );
223:
224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
225: RAISE FND_API.g_exc_unexpected_error;
226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
227: RAISE FND_API.g_exc_error;
228: END IF;

Line 225: RAISE FND_API.g_exc_unexpected_error;

221: x_return_status => l_return_status
222: );
223:
224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
225: RAISE FND_API.g_exc_unexpected_error;
226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
227: RAISE FND_API.g_exc_error;
228: END IF;
229: END IF;

Line 226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

222: );
223:
224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
225: RAISE FND_API.g_exc_unexpected_error;
226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
227: RAISE FND_API.g_exc_error;
228: END IF;
229: END IF;
230:

Line 227: RAISE FND_API.g_exc_error;

223:
224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
225: RAISE FND_API.g_exc_unexpected_error;
226: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
227: RAISE FND_API.g_exc_error;
228: END IF;
229: END IF;
230:
231: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

Line 238: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

234: p_complete_rec => l_listfield_rec,
235: x_return_status => l_return_status
236: );
237:
238: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
239: RAISE FND_API.g_exc_unexpected_error;
240: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
241: RAISE FND_API.g_exc_error;
242: END IF;

Line 239: RAISE FND_API.g_exc_unexpected_error;

235: x_return_status => l_return_status
236: );
237:
238: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
239: RAISE FND_API.g_exc_unexpected_error;
240: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
241: RAISE FND_API.g_exc_error;
242: END IF;
243: END IF;

Line 240: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

236: );
237:
238: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
239: RAISE FND_API.g_exc_unexpected_error;
240: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
241: RAISE FND_API.g_exc_error;
242: END IF;
243: END IF;
244:

Line 241: RAISE FND_API.g_exc_error;

237:
238: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
239: RAISE FND_API.g_exc_unexpected_error;
240: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
241: RAISE FND_API.g_exc_error;
242: END IF;
243: END IF;
244:
245: -------------------------- update --------------------

Line 265: RAISE FND_API.g_exc_error;

261: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
262: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
263: FND_MSG_PUB.add;
264: END IF;
265: RAISE FND_API.g_exc_error;
266: END IF;
267:
268: UPDATE ams_list_fields_tl
269: SET

Line 283: RAISE FND_API.g_exc_error;

279: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
280: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
281: FND_MSG_PUB.add;
282: END IF;
283: RAISE FND_API.g_exc_error;
284: END IF;
285:
286: -------------------- finish --------------------------
287: IF FND_API.to_boolean (p_commit) THEN

Line 287: IF FND_API.to_boolean (p_commit) THEN

283: RAISE FND_API.g_exc_error;
284: END IF;
285:
286: -------------------- finish --------------------------
287: IF FND_API.to_boolean (p_commit) THEN
288: COMMIT;
289: END IF;
290:
291: FND_MSG_PUB.count_and_get (

Line 292: p_encoded => FND_API.g_false,

288: COMMIT;
289: END IF;
290:
291: FND_MSG_PUB.count_and_get (
292: p_encoded => FND_API.g_false,
293: p_count => x_msg_count,
294: p_data => x_msg_data
295: );
296:

Line 300: WHEN FND_API.g_exc_error THEN

296:
297: AMS_Utility_PVT.debug_message (l_full_name || ': End');
298:
299: EXCEPTION
300: WHEN FND_API.g_exc_error THEN
301: ROLLBACK TO Update_ListField;
302: x_return_status := FND_API.g_ret_sts_error;
303: FND_MSG_PUB.count_and_get (
304: p_encoded => FND_API.g_false,

Line 302: x_return_status := FND_API.g_ret_sts_error;

298:
299: EXCEPTION
300: WHEN FND_API.g_exc_error THEN
301: ROLLBACK TO Update_ListField;
302: x_return_status := FND_API.g_ret_sts_error;
303: FND_MSG_PUB.count_and_get (
304: p_encoded => FND_API.g_false,
305: p_count => x_msg_count,
306: p_data => x_msg_data

Line 304: p_encoded => FND_API.g_false,

300: WHEN FND_API.g_exc_error THEN
301: ROLLBACK TO Update_ListField;
302: x_return_status := FND_API.g_ret_sts_error;
303: FND_MSG_PUB.count_and_get (
304: p_encoded => FND_API.g_false,
305: p_count => x_msg_count,
306: p_data => x_msg_data
307: );
308: WHEN FND_API.g_exc_unexpected_error THEN

Line 308: WHEN FND_API.g_exc_unexpected_error THEN

304: p_encoded => FND_API.g_false,
305: p_count => x_msg_count,
306: p_data => x_msg_data
307: );
308: WHEN FND_API.g_exc_unexpected_error THEN
309: ROLLBACK TO Update_ListField;
310: x_return_status := FND_API.g_ret_sts_unexp_error ;
311: FND_MSG_PUB.count_and_get (
312: p_encoded => FND_API.g_false,

Line 310: x_return_status := FND_API.g_ret_sts_unexp_error ;

306: p_data => x_msg_data
307: );
308: WHEN FND_API.g_exc_unexpected_error THEN
309: ROLLBACK TO Update_ListField;
310: x_return_status := FND_API.g_ret_sts_unexp_error ;
311: FND_MSG_PUB.count_and_get (
312: p_encoded => FND_API.g_false,
313: p_count => x_msg_count,
314: p_data => x_msg_data

Line 312: p_encoded => FND_API.g_false,

308: WHEN FND_API.g_exc_unexpected_error THEN
309: ROLLBACK TO Update_ListField;
310: x_return_status := FND_API.g_ret_sts_unexp_error ;
311: FND_MSG_PUB.count_and_get (
312: p_encoded => FND_API.g_false,
313: p_count => x_msg_count,
314: p_data => x_msg_data
315: );
316: WHEN OTHERS THEN

Line 318: x_return_status := FND_API.g_ret_sts_unexp_error ;

314: p_data => x_msg_data
315: );
316: WHEN OTHERS THEN
317: ROLLBACK TO Update_ListField;
318: x_return_status := FND_API.g_ret_sts_unexp_error ;
319:
320: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
321: THEN
322: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 326: p_encoded => FND_API.g_false,

322: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
323: END IF;
324:
325: FND_MSG_PUB.count_and_get (
326: p_encoded => FND_API.g_false,
327: p_count => x_msg_count,
328: p_data => x_msg_data
329: );
330: END Update_ListField;

Line 345: -- should not be any FND_API.g_miss_char/num/date in it.

341: -- p_listfield_rec: the record representing AMS_LIST_FIELDS_VL.
342: --
343: -- NOTES
344: -- 1. p_listfield_rec should be the complete list field record. There
345: -- should not be any FND_API.g_miss_char/num/date in it.
346: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
347: -- an exception, as those values are not handled.
348: --------------------------------------------------------------------
349: PROCEDURE Validate_ListField (

Line 346: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise

342: --
343: -- NOTES
344: -- 1. p_listfield_rec should be the complete list field record. There
345: -- should not be any FND_API.g_miss_char/num/date in it.
346: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
347: -- an exception, as those values are not handled.
348: --------------------------------------------------------------------
349: PROCEDURE Validate_ListField (
350: p_api_version IN NUMBER,

Line 351: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

347: -- an exception, as those values are not handled.
348: --------------------------------------------------------------------
349: PROCEDURE Validate_ListField (
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
352: p_commit IN VARCHAR2 := FND_API.g_false,
353: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
354:
355: x_return_status OUT VARCHAR2,

Line 352: p_commit IN VARCHAR2 := FND_API.g_false,

348: --------------------------------------------------------------------
349: PROCEDURE Validate_ListField (
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
352: p_commit IN VARCHAR2 := FND_API.g_false,
353: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
354:
355: x_return_status OUT VARCHAR2,
356: x_msg_count OUT NUMBER,

Line 353: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

349: PROCEDURE Validate_ListField (
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
352: p_commit IN VARCHAR2 := FND_API.g_false,
353: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
354:
355: x_return_status OUT VARCHAR2,
356: x_msg_count OUT NUMBER,
357: x_msg_data OUT VARCHAR2,

Line 371: IF FND_API.to_boolean (p_init_msg_list) THEN

367: BEGIN
368: --------------------- initialize -----------------------
369: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
370:
371: IF FND_API.to_boolean (p_init_msg_list) THEN
372: FND_MSG_PUB.initialize;
373: END IF;
374:
375: IF NOT FND_API.compatible_api_call (

Line 375: IF NOT FND_API.compatible_api_call (

371: IF FND_API.to_boolean (p_init_msg_list) THEN
372: FND_MSG_PUB.initialize;
373: END IF;
374:
375: IF NOT FND_API.compatible_api_call (
376: l_api_version,
377: p_api_version,
378: l_api_name,
379: g_pkg_name

Line 381: RAISE FND_API.g_exc_unexpected_error;

377: p_api_version,
378: l_api_name,
379: g_pkg_name
380: ) THEN
381: RAISE FND_API.g_exc_unexpected_error;
382: END IF;
383:
384: x_return_status := FND_API.g_ret_sts_success;
385:

Line 384: x_return_status := FND_API.g_ret_sts_success;

380: ) THEN
381: RAISE FND_API.g_exc_unexpected_error;
382: END IF;
383:
384: x_return_status := FND_API.g_ret_sts_success;
385:
386: ---------------------- validate ------------------------
387: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
388:

Line 396: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

392: p_validation_mode => JTF_PLSQL_API.g_create,
393: x_return_status => l_return_status
394: );
395:
396: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
397: RAISE FND_API.g_exc_unexpected_error;
398: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
399: RAISE FND_API.g_exc_error;
400: END IF;

Line 397: RAISE FND_API.g_exc_unexpected_error;

393: x_return_status => l_return_status
394: );
395:
396: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
397: RAISE FND_API.g_exc_unexpected_error;
398: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
399: RAISE FND_API.g_exc_error;
400: END IF;
401: END IF;

Line 398: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

394: );
395:
396: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
397: RAISE FND_API.g_exc_unexpected_error;
398: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
399: RAISE FND_API.g_exc_error;
400: END IF;
401: END IF;
402:

Line 399: RAISE FND_API.g_exc_error;

395:
396: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
397: RAISE FND_API.g_exc_unexpected_error;
398: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
399: RAISE FND_API.g_exc_error;
400: END IF;
401: END IF;
402:
403: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');

Line 412: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

408: p_complete_rec => NULL,
409: x_return_status => l_return_status
410: );
411:
412: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
413: RAISE FND_API.g_exc_unexpected_error;
414: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
415: RAISE FND_API.g_exc_error;
416: END IF;

Line 413: RAISE FND_API.g_exc_unexpected_error;

409: x_return_status => l_return_status
410: );
411:
412: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
413: RAISE FND_API.g_exc_unexpected_error;
414: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
415: RAISE FND_API.g_exc_error;
416: END IF;
417: END IF;

Line 414: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

410: );
411:
412: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
413: RAISE FND_API.g_exc_unexpected_error;
414: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
415: RAISE FND_API.g_exc_error;
416: END IF;
417: END IF;
418:

Line 415: RAISE FND_API.g_exc_error;

411:
412: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
413: RAISE FND_API.g_exc_unexpected_error;
414: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
415: RAISE FND_API.g_exc_error;
416: END IF;
417: END IF;
418:
419: -------------------- finish --------------------------

Line 421: p_encoded => FND_API.g_false,

417: END IF;
418:
419: -------------------- finish --------------------------
420: FND_MSG_PUB.count_and_get (
421: p_encoded => FND_API.g_false,
422: p_count => x_msg_count,
423: p_data => x_msg_data
424: );
425:

Line 429: WHEN FND_API.g_exc_error THEN

425:
426: AMS_Utility_PVT.debug_message (l_full_name || ': End');
427:
428: EXCEPTION
429: WHEN FND_API.g_exc_error THEN
430: x_return_status := FND_API.g_ret_sts_error;
431: FND_MSG_PUB.count_and_get (
432: p_encoded => FND_API.g_false,
433: p_count => x_msg_count,

Line 430: x_return_status := FND_API.g_ret_sts_error;

426: AMS_Utility_PVT.debug_message (l_full_name || ': End');
427:
428: EXCEPTION
429: WHEN FND_API.g_exc_error THEN
430: x_return_status := FND_API.g_ret_sts_error;
431: FND_MSG_PUB.count_and_get (
432: p_encoded => FND_API.g_false,
433: p_count => x_msg_count,
434: p_data => x_msg_data

Line 432: p_encoded => FND_API.g_false,

428: EXCEPTION
429: WHEN FND_API.g_exc_error THEN
430: x_return_status := FND_API.g_ret_sts_error;
431: FND_MSG_PUB.count_and_get (
432: p_encoded => FND_API.g_false,
433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );
436: WHEN FND_API.g_exc_unexpected_error THEN

Line 436: WHEN FND_API.g_exc_unexpected_error THEN

432: p_encoded => FND_API.g_false,
433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );
436: WHEN FND_API.g_exc_unexpected_error THEN
437: x_return_status := FND_API.g_ret_sts_unexp_error ;
438: FND_MSG_PUB.count_and_get (
439: p_encoded => FND_API.g_false,
440: p_count => x_msg_count,

Line 437: x_return_status := FND_API.g_ret_sts_unexp_error ;

433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );
436: WHEN FND_API.g_exc_unexpected_error THEN
437: x_return_status := FND_API.g_ret_sts_unexp_error ;
438: FND_MSG_PUB.count_and_get (
439: p_encoded => FND_API.g_false,
440: p_count => x_msg_count,
441: p_data => x_msg_data

Line 439: p_encoded => FND_API.g_false,

435: );
436: WHEN FND_API.g_exc_unexpected_error THEN
437: x_return_status := FND_API.g_ret_sts_unexp_error ;
438: FND_MSG_PUB.count_and_get (
439: p_encoded => FND_API.g_false,
440: p_count => x_msg_count,
441: p_data => x_msg_data
442: );
443: WHEN OTHERS THEN

Line 444: x_return_status := FND_API.g_ret_sts_unexp_error;

440: p_count => x_msg_count,
441: p_data => x_msg_data
442: );
443: WHEN OTHERS THEN
444: x_return_status := FND_API.g_ret_sts_unexp_error;
445: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
446: THEN
447: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
448: END IF;

Line 451: p_encoded => FND_API.g_false,

447: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
448: END IF;
449:
450: FND_MSG_PUB.count_and_get (
451: p_encoded => FND_API.g_false,
452: p_count => x_msg_count,
453: p_data => x_msg_data
454: );
455: END Validate_ListField;

Line 484: IF x_return_status <> FND_API.g_ret_sts_success THEN

480: p_listfield_rec => p_listfield_rec,
481: x_return_status => x_return_status
482: );
483:
484: IF x_return_status <> FND_API.g_ret_sts_success THEN
485: RETURN;
486: END IF;
487: END Check_ListField_Items;
488:

Line 498: -- as FND_API.g_miss_char/num/date

494: -- Check the record level business rules.
495: --
496: -- PARAMETERS
497: -- p_listfield_rec: the record to be validated; may contain attributes
498: -- as FND_API.g_miss_char/num/date
499: -- p_complete_rec: the complete record after all "g_miss" items
500: -- have been replaced by current database values
501: ---------------------------------------------------------------------
502: PROCEDURE Check_ListField_Record (

Line 509: x_return_status := FND_API.g_ret_sts_success;

505: x_return_status OUT VARCHAR2
506: )
507: IS
508: BEGIN
509: x_return_status := FND_API.g_ret_sts_success;
510: END Check_ListField_Record;
511:
512:
513: ---------------------------------------------------------------------

Line 518: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

514: -- PROCEDURE
515: -- Init_ListField_Rec
516: --
517: -- PURPOSE
518: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
519: ---------------------------------------------------------------------
520: PROCEDURE Init_ListField_Rec (
521: x_listfield_rec OUT List_Field_Rec_Type
522: )

Line 525: x_listfield_rec.list_field_id := FND_API.g_miss_num;

521: x_listfield_rec OUT List_Field_Rec_Type
522: )
523: IS
524: BEGIN
525: x_listfield_rec.list_field_id := FND_API.g_miss_num;
526: x_listfield_rec.last_update_date := FND_API.g_miss_date;
527: x_listfield_rec.last_updated_by := FND_API.g_miss_num;
528: x_listfield_rec.creation_date := FND_API.g_miss_date;
529: x_listfield_rec.created_by := FND_API.g_miss_num;

Line 526: x_listfield_rec.last_update_date := FND_API.g_miss_date;

522: )
523: IS
524: BEGIN
525: x_listfield_rec.list_field_id := FND_API.g_miss_num;
526: x_listfield_rec.last_update_date := FND_API.g_miss_date;
527: x_listfield_rec.last_updated_by := FND_API.g_miss_num;
528: x_listfield_rec.creation_date := FND_API.g_miss_date;
529: x_listfield_rec.created_by := FND_API.g_miss_num;
530: x_listfield_rec.last_update_login := FND_API.g_miss_num;

Line 527: x_listfield_rec.last_updated_by := FND_API.g_miss_num;

523: IS
524: BEGIN
525: x_listfield_rec.list_field_id := FND_API.g_miss_num;
526: x_listfield_rec.last_update_date := FND_API.g_miss_date;
527: x_listfield_rec.last_updated_by := FND_API.g_miss_num;
528: x_listfield_rec.creation_date := FND_API.g_miss_date;
529: x_listfield_rec.created_by := FND_API.g_miss_num;
530: x_listfield_rec.last_update_login := FND_API.g_miss_num;
531: x_listfield_rec.object_version_number := FND_API.g_miss_num;

Line 528: x_listfield_rec.creation_date := FND_API.g_miss_date;

524: BEGIN
525: x_listfield_rec.list_field_id := FND_API.g_miss_num;
526: x_listfield_rec.last_update_date := FND_API.g_miss_date;
527: x_listfield_rec.last_updated_by := FND_API.g_miss_num;
528: x_listfield_rec.creation_date := FND_API.g_miss_date;
529: x_listfield_rec.created_by := FND_API.g_miss_num;
530: x_listfield_rec.last_update_login := FND_API.g_miss_num;
531: x_listfield_rec.object_version_number := FND_API.g_miss_num;
532: x_listfield_rec.field_table_name := FND_API.g_miss_char;

Line 529: x_listfield_rec.created_by := FND_API.g_miss_num;

525: x_listfield_rec.list_field_id := FND_API.g_miss_num;
526: x_listfield_rec.last_update_date := FND_API.g_miss_date;
527: x_listfield_rec.last_updated_by := FND_API.g_miss_num;
528: x_listfield_rec.creation_date := FND_API.g_miss_date;
529: x_listfield_rec.created_by := FND_API.g_miss_num;
530: x_listfield_rec.last_update_login := FND_API.g_miss_num;
531: x_listfield_rec.object_version_number := FND_API.g_miss_num;
532: x_listfield_rec.field_table_name := FND_API.g_miss_char;
533: x_listfield_rec.field_column_name := FND_API.g_miss_char;

Line 530: x_listfield_rec.last_update_login := FND_API.g_miss_num;

526: x_listfield_rec.last_update_date := FND_API.g_miss_date;
527: x_listfield_rec.last_updated_by := FND_API.g_miss_num;
528: x_listfield_rec.creation_date := FND_API.g_miss_date;
529: x_listfield_rec.created_by := FND_API.g_miss_num;
530: x_listfield_rec.last_update_login := FND_API.g_miss_num;
531: x_listfield_rec.object_version_number := FND_API.g_miss_num;
532: x_listfield_rec.field_table_name := FND_API.g_miss_char;
533: x_listfield_rec.field_column_name := FND_API.g_miss_char;
534: x_listfield_rec.column_data_type := FND_API.g_miss_char;

Line 531: x_listfield_rec.object_version_number := FND_API.g_miss_num;

527: x_listfield_rec.last_updated_by := FND_API.g_miss_num;
528: x_listfield_rec.creation_date := FND_API.g_miss_date;
529: x_listfield_rec.created_by := FND_API.g_miss_num;
530: x_listfield_rec.last_update_login := FND_API.g_miss_num;
531: x_listfield_rec.object_version_number := FND_API.g_miss_num;
532: x_listfield_rec.field_table_name := FND_API.g_miss_char;
533: x_listfield_rec.field_column_name := FND_API.g_miss_char;
534: x_listfield_rec.column_data_type := FND_API.g_miss_char;
535: x_listfield_rec.column_data_length := FND_API.g_miss_num;

Line 532: x_listfield_rec.field_table_name := FND_API.g_miss_char;

528: x_listfield_rec.creation_date := FND_API.g_miss_date;
529: x_listfield_rec.created_by := FND_API.g_miss_num;
530: x_listfield_rec.last_update_login := FND_API.g_miss_num;
531: x_listfield_rec.object_version_number := FND_API.g_miss_num;
532: x_listfield_rec.field_table_name := FND_API.g_miss_char;
533: x_listfield_rec.field_column_name := FND_API.g_miss_char;
534: x_listfield_rec.column_data_type := FND_API.g_miss_char;
535: x_listfield_rec.column_data_length := FND_API.g_miss_num;
536: x_listfield_rec.enabled_flag := FND_API.g_miss_char;

Line 533: x_listfield_rec.field_column_name := FND_API.g_miss_char;

529: x_listfield_rec.created_by := FND_API.g_miss_num;
530: x_listfield_rec.last_update_login := FND_API.g_miss_num;
531: x_listfield_rec.object_version_number := FND_API.g_miss_num;
532: x_listfield_rec.field_table_name := FND_API.g_miss_char;
533: x_listfield_rec.field_column_name := FND_API.g_miss_char;
534: x_listfield_rec.column_data_type := FND_API.g_miss_char;
535: x_listfield_rec.column_data_length := FND_API.g_miss_num;
536: x_listfield_rec.enabled_flag := FND_API.g_miss_char;
537: x_listfield_rec.list_type_field_apply_on := FND_API.g_miss_char;

Line 534: x_listfield_rec.column_data_type := FND_API.g_miss_char;

530: x_listfield_rec.last_update_login := FND_API.g_miss_num;
531: x_listfield_rec.object_version_number := FND_API.g_miss_num;
532: x_listfield_rec.field_table_name := FND_API.g_miss_char;
533: x_listfield_rec.field_column_name := FND_API.g_miss_char;
534: x_listfield_rec.column_data_type := FND_API.g_miss_char;
535: x_listfield_rec.column_data_length := FND_API.g_miss_num;
536: x_listfield_rec.enabled_flag := FND_API.g_miss_char;
537: x_listfield_rec.list_type_field_apply_on := FND_API.g_miss_char;
538: x_listfield_rec.description := FND_API.g_miss_char;

Line 535: x_listfield_rec.column_data_length := FND_API.g_miss_num;

531: x_listfield_rec.object_version_number := FND_API.g_miss_num;
532: x_listfield_rec.field_table_name := FND_API.g_miss_char;
533: x_listfield_rec.field_column_name := FND_API.g_miss_char;
534: x_listfield_rec.column_data_type := FND_API.g_miss_char;
535: x_listfield_rec.column_data_length := FND_API.g_miss_num;
536: x_listfield_rec.enabled_flag := FND_API.g_miss_char;
537: x_listfield_rec.list_type_field_apply_on := FND_API.g_miss_char;
538: x_listfield_rec.description := FND_API.g_miss_char;
539: END Init_ListField_Rec;

Line 536: x_listfield_rec.enabled_flag := FND_API.g_miss_char;

532: x_listfield_rec.field_table_name := FND_API.g_miss_char;
533: x_listfield_rec.field_column_name := FND_API.g_miss_char;
534: x_listfield_rec.column_data_type := FND_API.g_miss_char;
535: x_listfield_rec.column_data_length := FND_API.g_miss_num;
536: x_listfield_rec.enabled_flag := FND_API.g_miss_char;
537: x_listfield_rec.list_type_field_apply_on := FND_API.g_miss_char;
538: x_listfield_rec.description := FND_API.g_miss_char;
539: END Init_ListField_Rec;
540:

Line 537: x_listfield_rec.list_type_field_apply_on := FND_API.g_miss_char;

533: x_listfield_rec.field_column_name := FND_API.g_miss_char;
534: x_listfield_rec.column_data_type := FND_API.g_miss_char;
535: x_listfield_rec.column_data_length := FND_API.g_miss_num;
536: x_listfield_rec.enabled_flag := FND_API.g_miss_char;
537: x_listfield_rec.list_type_field_apply_on := FND_API.g_miss_char;
538: x_listfield_rec.description := FND_API.g_miss_char;
539: END Init_ListField_Rec;
540:
541:

Line 538: x_listfield_rec.description := FND_API.g_miss_char;

534: x_listfield_rec.column_data_type := FND_API.g_miss_char;
535: x_listfield_rec.column_data_length := FND_API.g_miss_num;
536: x_listfield_rec.enabled_flag := FND_API.g_miss_char;
537: x_listfield_rec.list_type_field_apply_on := FND_API.g_miss_char;
538: x_listfield_rec.description := FND_API.g_miss_char;
539: END Init_ListField_Rec;
540:
541:
542: ---------------------------------------------------------------------

Line 548: -- FND_API.g_miss_char/num/date if the user doesn't want to

544: -- Complete_ListField_Rec
545: --
546: -- PURPOSE
547: -- For Update_ListField, some attributes may be passed in as
548: -- FND_API.g_miss_char/num/date if the user doesn't want to
549: -- update those attributes. This procedure will replace the
550: -- "g_miss" attributes with current database values.
551: --
552: -- PARAMETERS

Line 554: -- FND_API.g_miss_char/num/date

550: -- "g_miss" attributes with current database values.
551: --
552: -- PARAMETERS
553: -- p_listdr_rec: the record which may contain attributes as
554: -- FND_API.g_miss_char/num/date
555: -- x_complete_rec: the complete record after all "g_miss" items
556: -- have been replaced by current database values
557: ---------------------------------------------------------------------
558: PROCEDURE Complete_ListField_Rec (

Line 582: RAISE FND_API.g_exc_error;

578: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
579: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
580: FND_MSG_PUB.add;
581: END IF;
582: RAISE FND_API.g_exc_error;
583: END IF;
584: CLOSE c_field;
585:
586: -- FIELD_TABLE_NAME

Line 587: IF p_listfield_rec.field_table_name = FND_API.g_miss_char THEN

583: END IF;
584: CLOSE c_field;
585:
586: -- FIELD_TABLE_NAME
587: IF p_listfield_rec.field_table_name = FND_API.g_miss_char THEN
588: x_complete_rec.field_table_name := l_listfield_rec.field_table_name;
589: END IF;
590:
591: -- FIELD_COLUMN_NAME

Line 592: IF p_listfield_rec.field_column_name = FND_API.g_miss_char THEN

588: x_complete_rec.field_table_name := l_listfield_rec.field_table_name;
589: END IF;
590:
591: -- FIELD_COLUMN_NAME
592: IF p_listfield_rec.field_column_name = FND_API.g_miss_char THEN
593: x_complete_rec.field_column_name := l_listfield_rec.field_column_name;
594: END IF;
595:
596: -- COLUMN_DATA_TYPE

Line 597: IF p_listfield_rec.column_data_type = FND_API.g_miss_char THEN

593: x_complete_rec.field_column_name := l_listfield_rec.field_column_name;
594: END IF;
595:
596: -- COLUMN_DATA_TYPE
597: IF p_listfield_rec.column_data_type = FND_API.g_miss_char THEN
598: x_complete_rec.column_data_type := l_listfield_rec.column_data_type;
599: END IF;
600:
601: -- COLUMN_DATA_LENGTH

Line 602: IF p_listfield_rec.column_data_length = FND_API.g_miss_num THEN

598: x_complete_rec.column_data_type := l_listfield_rec.column_data_type;
599: END IF;
600:
601: -- COLUMN_DATA_LENGTH
602: IF p_listfield_rec.column_data_length = FND_API.g_miss_num THEN
603: x_complete_rec.column_data_length := l_listfield_rec.column_data_length;
604: END IF;
605:
606: -- ENABLED_FLAG

Line 607: IF p_listfield_rec.enabled_flag = FND_API.g_miss_char THEN

603: x_complete_rec.column_data_length := l_listfield_rec.column_data_length;
604: END IF;
605:
606: -- ENABLED_FLAG
607: IF p_listfield_rec.enabled_flag = FND_API.g_miss_char THEN
608: x_complete_rec.enabled_flag := l_listfield_rec.enabled_flag;
609: END IF;
610:
611: -- LIST_TYPE_FIELD_APPLY_ON

Line 612: IF p_listfield_rec.list_type_field_apply_on = FND_API.g_miss_char THEN

608: x_complete_rec.enabled_flag := l_listfield_rec.enabled_flag;
609: END IF;
610:
611: -- LIST_TYPE_FIELD_APPLY_ON
612: IF p_listfield_rec.list_type_field_apply_on = FND_API.g_miss_char THEN
613: x_complete_rec.list_type_field_apply_on := l_listfield_rec.list_type_field_apply_on;
614: END IF;
615:
616: -------------------------------------------

Line 623: -- IF p_listfield_rec.description = FND_API.g_miss_char THEN

619: -- because of language setting in dev
620: -- database. Remove the leading comments
621: -- after language setting fixed.
622: -- DESCRIPTION
623: -- IF p_listfield_rec.description = FND_API.g_miss_char THEN
624: -- x_complete_rec.description := l_listfield_rec.description;
625: -- END IF;
626:
627: END Complete_ListField_Rec;

Line 648: x_return_status := FND_API.g_ret_sts_success;

644: x_return_status OUT VARCHAR2
645: )
646: IS
647: BEGIN
648: x_return_status := FND_API.g_ret_sts_success;
649:
650: --
651: -- ENABLED_FLAG
652: IF p_listfield_rec.enabled_flag <> FND_API.g_miss_char AND p_listfield_rec.enabled_flag IS NOT NULL THEN

Line 652: IF p_listfield_rec.enabled_flag <> FND_API.g_miss_char AND p_listfield_rec.enabled_flag IS NOT NULL THEN

648: x_return_status := FND_API.g_ret_sts_success;
649:
650: --
651: -- ENABLED_FLAG
652: IF p_listfield_rec.enabled_flag <> FND_API.g_miss_char AND p_listfield_rec.enabled_flag IS NOT NULL THEN
653: IF AMS_Utility_PVT.is_Y_or_N (p_listfield_rec.enabled_flag) = FND_API.g_false THEN
654: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
655: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');
656: FND_MSG_PUB.add;

Line 653: IF AMS_Utility_PVT.is_Y_or_N (p_listfield_rec.enabled_flag) = FND_API.g_false THEN

649:
650: --
651: -- ENABLED_FLAG
652: IF p_listfield_rec.enabled_flag <> FND_API.g_miss_char AND p_listfield_rec.enabled_flag IS NOT NULL THEN
653: IF AMS_Utility_PVT.is_Y_or_N (p_listfield_rec.enabled_flag) = FND_API.g_false THEN
654: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
655: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');
656: FND_MSG_PUB.add;
657: END IF;

Line 659: x_return_status := FND_API.g_ret_sts_error;

655: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');
656: FND_MSG_PUB.add;
657: END IF;
658:
659: x_return_status := FND_API.g_ret_sts_error;
660: RETURN;
661: END IF;
662: END IF;
663: END Check_ListField_Flag_Items;