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

Line 52: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

48: ,p_attribute13 IN VARCHAR2
49: ,p_attribute14 IN VARCHAR2
50: ,p_attribute15 IN VARCHAR2
51: ) IS
52: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
53: l_found BOOLEAN;
54: l_msg_count NUMBER ;
55: l_msg_data VARCHAR2(240);
56: BEGIN

Line 60: RAISE fnd_api.g_exc_unexpected_error;

56: BEGIN
57:
58: IF p_action NOT IN ('INSERT', 'UPDATE', 'LOCK', 'DELETE') THEN
59: -- unknown exception
60: RAISE fnd_api.g_exc_unexpected_error;
61: END IF;
62:
63: /* check existence */
64: IF check_existence(p_rule_id, p_sequence_number) THEN

Line 68: RAISE fnd_api.g_exc_error;

64: IF check_existence(p_rule_id, p_sequence_number) THEN
65: IF p_action = 'INSERT' THEN
66: fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_EXISTS');
67: fnd_msg_pub.ADD;
68: RAISE fnd_api.g_exc_error;
69: END IF;
70: ELSE
71: IF p_action IN ('DELETE','LOCK','UPDATE') THEN
72: fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_NOT_FOUND');

Line 74: RAISE fnd_api.g_exc_error;

70: ELSE
71: IF p_action IN ('DELETE','LOCK','UPDATE') THEN
72: fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_NOT_FOUND');
73: fnd_msg_pub.ADD;
74: RAISE fnd_api.g_exc_error;
75: END IF;
76: END IF;
77:
78: /* more input validation update and insert */

Line 84: ,p_init_msg_list => fnd_api.g_false

80: /* check foreign keys */
81: wms_rule_form_pkg.find_rule
82: (
83: p_api_version => 1.0
84: ,p_init_msg_list => fnd_api.g_false
85: ,x_return_status => l_return_status
86: ,x_msg_count => l_msg_count
87: ,x_msg_data => l_msg_data
88: ,p_rule_id => p_rule_id

Line 92: if x_return_status = fnd_api.g_ret_sts_unexp_error then

88: ,p_rule_id => p_rule_id
89: ,x_found => l_found
90: );
91:
92: if x_return_status = fnd_api.g_ret_sts_unexp_error then
93: raise fnd_api.g_exc_unexpected_error;
94: elsif x_return_status = fnd_api.g_ret_sts_error then
95: raise fnd_api.g_exc_error;
96: end if;

Line 93: raise fnd_api.g_exc_unexpected_error;

89: ,x_found => l_found
90: );
91:
92: if x_return_status = fnd_api.g_ret_sts_unexp_error then
93: raise fnd_api.g_exc_unexpected_error;
94: elsif x_return_status = fnd_api.g_ret_sts_error then
95: raise fnd_api.g_exc_error;
96: end if;
97:

Line 94: elsif x_return_status = fnd_api.g_ret_sts_error then

90: );
91:
92: if x_return_status = fnd_api.g_ret_sts_unexp_error then
93: raise fnd_api.g_exc_unexpected_error;
94: elsif x_return_status = fnd_api.g_ret_sts_error then
95: raise fnd_api.g_exc_error;
96: end if;
97:
98: IF l_found = FALSE THEN

Line 95: raise fnd_api.g_exc_error;

91:
92: if x_return_status = fnd_api.g_ret_sts_unexp_error then
93: raise fnd_api.g_exc_unexpected_error;
94: elsif x_return_status = fnd_api.g_ret_sts_error then
95: raise fnd_api.g_exc_error;
96: end if;
97:
98: IF l_found = FALSE THEN
99: fnd_message.set_name('WMS', 'WMS_RULE_NOT_FOUND');

Line 101: RAISE fnd_api.g_exc_error;

97:
98: IF l_found = FALSE THEN
99: fnd_message.set_name('WMS', 'WMS_RULE_NOT_FOUND');
100: fnd_msg_pub.ADD;
101: RAISE fnd_api.g_exc_error;
102: END IF;
103:
104: -- other input parameters are not validated currently
105: /* like parameter id */

Line 111: WHEN fnd_api.g_exc_error THEN

107:
108: x_return_status := l_return_status;
109:
110: EXCEPTION
111: WHEN fnd_api.g_exc_error THEN
112: x_return_status := fnd_api.g_ret_sts_error;
113:
114: WHEN fnd_api.g_exc_unexpected_error THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 112: x_return_status := fnd_api.g_ret_sts_error;

108: x_return_status := l_return_status;
109:
110: EXCEPTION
111: WHEN fnd_api.g_exc_error THEN
112: x_return_status := fnd_api.g_ret_sts_error;
113:
114: WHEN fnd_api.g_exc_unexpected_error THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116:

Line 114: WHEN fnd_api.g_exc_unexpected_error THEN

110: EXCEPTION
111: WHEN fnd_api.g_exc_error THEN
112: x_return_status := fnd_api.g_ret_sts_error;
113:
114: WHEN fnd_api.g_exc_unexpected_error THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116:
117: WHEN OTHERS THEN
118: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 115: x_return_status := fnd_api.g_ret_sts_unexp_error;

111: WHEN fnd_api.g_exc_error THEN
112: x_return_status := fnd_api.g_ret_sts_error;
113:
114: WHEN fnd_api.g_exc_unexpected_error THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116:
117: WHEN OTHERS THEN
118: x_return_status := fnd_api.g_ret_sts_unexp_error;
119:

Line 118: x_return_status := fnd_api.g_ret_sts_unexp_error;

114: WHEN fnd_api.g_exc_unexpected_error THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116:
117: WHEN OTHERS THEN
118: x_return_status := fnd_api.g_ret_sts_unexp_error;
119:
120: END validate_input;
121:
122: procedure insert_sort_criteria

Line 125: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

121:
122: procedure insert_sort_criteria
123: (
124: p_api_version IN NUMBER
125: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
126: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
127: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
129: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 126: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

122: procedure insert_sort_criteria
123: (
124: p_api_version IN NUMBER
125: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
126: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
127: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
129: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130: ,p_rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 155: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

151: ) IS
152: -- API standard variables
153: l_api_version constant number := 1.0;
154: l_api_name constant varchar2(30) := 'Insert_Sort_criteria';
155: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
156: l_row_id VARCHAR2(20);
157: l_date DATE;
158: l_user_id NUMBER;
159: l_login_id NUMBER;

Line 164: if not fnd_api.compatible_api_call( l_api_version

160: l_found BOOLEAN;
161: begin
162:
163: -- Standard call to check for call compatibility
164: if not fnd_api.compatible_api_call( l_api_version
165: ,p_api_version
166: ,l_api_name
167: ,g_pkg_name ) then
168: raise fnd_api.g_exc_unexpected_error;

Line 168: raise fnd_api.g_exc_unexpected_error;

164: if not fnd_api.compatible_api_call( l_api_version
165: ,p_api_version
166: ,l_api_name
167: ,g_pkg_name ) then
168: raise fnd_api.g_exc_unexpected_error;
169: end if;
170:
171: -- Initialize message list if p_init_msg_list is set to TRUE
172: if fnd_api.to_boolean( p_init_msg_list ) then

Line 172: if fnd_api.to_boolean( p_init_msg_list ) then

168: raise fnd_api.g_exc_unexpected_error;
169: end if;
170:
171: -- Initialize message list if p_init_msg_list is set to TRUE
172: if fnd_api.to_boolean( p_init_msg_list ) then
173: fnd_msg_pub.initialize;
174: end if;
175:
176: /* add validation here */

Line 208: if x_return_status = fnd_api.g_ret_sts_unexp_error then

204: ,p_attribute14 => p_attribute14
205: ,p_attribute15 => p_attribute15
206: );
207:
208: if x_return_status = fnd_api.g_ret_sts_unexp_error then
209: raise fnd_api.g_exc_unexpected_error;
210: elsif x_return_status = fnd_api.g_ret_sts_error then
211: raise fnd_api.g_exc_error;
212: end if;

Line 209: raise fnd_api.g_exc_unexpected_error;

205: ,p_attribute15 => p_attribute15
206: );
207:
208: if x_return_status = fnd_api.g_ret_sts_unexp_error then
209: raise fnd_api.g_exc_unexpected_error;
210: elsif x_return_status = fnd_api.g_ret_sts_error then
211: raise fnd_api.g_exc_error;
212: end if;
213:

Line 210: elsif x_return_status = fnd_api.g_ret_sts_error then

206: );
207:
208: if x_return_status = fnd_api.g_ret_sts_unexp_error then
209: raise fnd_api.g_exc_unexpected_error;
210: elsif x_return_status = fnd_api.g_ret_sts_error then
211: raise fnd_api.g_exc_error;
212: end if;
213:
214: /* call the table handler to do the insert */

Line 211: raise fnd_api.g_exc_error;

207:
208: if x_return_status = fnd_api.g_ret_sts_unexp_error then
209: raise fnd_api.g_exc_unexpected_error;
210: elsif x_return_status = fnd_api.g_ret_sts_error then
211: raise fnd_api.g_exc_error;
212: end if;
213:
214: /* call the table handler to do the insert */
215: wms_sort_criteria_pkg.insert_row

Line 248: when fnd_api.g_exc_error then

244:
245: x_return_status := l_return_status;
246:
247: EXCEPTION
248: when fnd_api.g_exc_error then
249: x_return_status := fnd_api.g_ret_sts_error;
250: fnd_msg_pub.count_and_get( p_count => x_msg_count
251: ,p_data => x_msg_data );
252:

Line 249: x_return_status := fnd_api.g_ret_sts_error;

245: x_return_status := l_return_status;
246:
247: EXCEPTION
248: when fnd_api.g_exc_error then
249: x_return_status := fnd_api.g_ret_sts_error;
250: fnd_msg_pub.count_and_get( p_count => x_msg_count
251: ,p_data => x_msg_data );
252:
253: when fnd_api.g_exc_unexpected_error then

Line 253: when fnd_api.g_exc_unexpected_error then

249: x_return_status := fnd_api.g_ret_sts_error;
250: fnd_msg_pub.count_and_get( p_count => x_msg_count
251: ,p_data => x_msg_data );
252:
253: when fnd_api.g_exc_unexpected_error then
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get( p_count => x_msg_count
256: ,p_data => x_msg_data );
257:

Line 254: x_return_status := fnd_api.g_ret_sts_unexp_error;

250: fnd_msg_pub.count_and_get( p_count => x_msg_count
251: ,p_data => x_msg_data );
252:
253: when fnd_api.g_exc_unexpected_error then
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get( p_count => x_msg_count
256: ,p_data => x_msg_data );
257:
258: when others then

Line 259: x_return_status := fnd_api.g_ret_sts_unexp_error;

255: fnd_msg_pub.count_and_get( p_count => x_msg_count
256: ,p_data => x_msg_data );
257:
258: when others then
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
261: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
262: end if;
263: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 270: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

266: end insert_sort_criteria;
267:
268: procedure lock_sort_criteria (
269: p_api_version IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
271: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
272: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
273: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
274: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 271: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

267:
268: procedure lock_sort_criteria (
269: p_api_version IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
271: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
272: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
273: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
274: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
275: ,p_rowid IN VARCHAR2

Line 300: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

296: ) is
297: -- API standard variables
298: l_api_version constant number := 1.0;
299: l_api_name constant varchar2(30) := 'Lock_Sort_criteria';
300: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
301: begin
302: -- Standard call to check for call compatibility
303: if not fnd_api.compatible_api_call( l_api_version
304: ,p_api_version

Line 303: if not fnd_api.compatible_api_call( l_api_version

299: l_api_name constant varchar2(30) := 'Lock_Sort_criteria';
300: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
301: begin
302: -- Standard call to check for call compatibility
303: if not fnd_api.compatible_api_call( l_api_version
304: ,p_api_version
305: ,l_api_name
306: ,g_pkg_name ) then
307: raise fnd_api.g_exc_unexpected_error;

Line 307: raise fnd_api.g_exc_unexpected_error;

303: if not fnd_api.compatible_api_call( l_api_version
304: ,p_api_version
305: ,l_api_name
306: ,g_pkg_name ) then
307: raise fnd_api.g_exc_unexpected_error;
308: end if;
309:
310: -- Initialize message list if p_init_msg_list is set to TRUE
311: if fnd_api.to_boolean( p_init_msg_list ) then

Line 311: if fnd_api.to_boolean( p_init_msg_list ) then

307: raise fnd_api.g_exc_unexpected_error;
308: end if;
309:
310: -- Initialize message list if p_init_msg_list is set to TRUE
311: if fnd_api.to_boolean( p_init_msg_list ) then
312: fnd_msg_pub.initialize;
313: end if;
314:
315: validate_input

Line 341: if x_return_status = fnd_api.g_ret_sts_unexp_error then

337: ,p_attribute14 => p_attribute14
338: ,p_attribute15 => p_attribute15
339: );
340:
341: if x_return_status = fnd_api.g_ret_sts_unexp_error then
342: raise fnd_api.g_exc_unexpected_error;
343: elsif x_return_status = fnd_api.g_ret_sts_error then
344: raise fnd_api.g_exc_error;
345: end if;

Line 342: raise fnd_api.g_exc_unexpected_error;

338: ,p_attribute15 => p_attribute15
339: );
340:
341: if x_return_status = fnd_api.g_ret_sts_unexp_error then
342: raise fnd_api.g_exc_unexpected_error;
343: elsif x_return_status = fnd_api.g_ret_sts_error then
344: raise fnd_api.g_exc_error;
345: end if;
346:

Line 343: elsif x_return_status = fnd_api.g_ret_sts_error then

339: );
340:
341: if x_return_status = fnd_api.g_ret_sts_unexp_error then
342: raise fnd_api.g_exc_unexpected_error;
343: elsif x_return_status = fnd_api.g_ret_sts_error then
344: raise fnd_api.g_exc_error;
345: end if;
346:
347: wms_sort_criteria_pkg.lock_row (

Line 344: raise fnd_api.g_exc_error;

340:
341: if x_return_status = fnd_api.g_ret_sts_unexp_error then
342: raise fnd_api.g_exc_unexpected_error;
343: elsif x_return_status = fnd_api.g_ret_sts_error then
344: raise fnd_api.g_exc_error;
345: end if;
346:
347: wms_sort_criteria_pkg.lock_row (
348: x_rowid => p_rowid

Line 374: WHEN fnd_api.g_exc_error THEN

370:
371: x_return_status := l_return_status;
372:
373: EXCEPTION
374: WHEN fnd_api.g_exc_error THEN
375: x_return_status := fnd_api.g_ret_sts_error;
376: fnd_msg_pub.count_and_get( p_count => x_msg_count
377: ,p_data => x_msg_data );
378:

Line 375: x_return_status := fnd_api.g_ret_sts_error;

371: x_return_status := l_return_status;
372:
373: EXCEPTION
374: WHEN fnd_api.g_exc_error THEN
375: x_return_status := fnd_api.g_ret_sts_error;
376: fnd_msg_pub.count_and_get( p_count => x_msg_count
377: ,p_data => x_msg_data );
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN

Line 379: WHEN fnd_api.g_exc_unexpected_error THEN

375: x_return_status := fnd_api.g_ret_sts_error;
376: fnd_msg_pub.count_and_get( p_count => x_msg_count
377: ,p_data => x_msg_data );
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: fnd_msg_pub.count_and_get( p_count => x_msg_count
382: ,p_data => x_msg_data );
383:

Line 380: x_return_status := fnd_api.g_ret_sts_unexp_error;

376: fnd_msg_pub.count_and_get( p_count => x_msg_count
377: ,p_data => x_msg_data );
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: fnd_msg_pub.count_and_get( p_count => x_msg_count
382: ,p_data => x_msg_data );
383:
384: WHEN OTHERS THEN

Line 385: x_return_status := fnd_api.g_ret_sts_unexp_error;

381: fnd_msg_pub.count_and_get( p_count => x_msg_count
382: ,p_data => x_msg_data );
383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
387: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
388: end if;
389: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 396: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

392: end lock_sort_criteria ;
393:
394: procedure update_sort_criteria (
395: p_api_version IN NUMBER
396: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
397: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
398: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
399: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
400: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 397: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

393:
394: procedure update_sort_criteria (
395: p_api_version IN NUMBER
396: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
397: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
398: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
399: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
400: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
401: ,p_rowid IN VARCHAR2

Line 426: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

422: ) is
423: -- API standard variables
424: l_api_version constant number := 1.0;
425: l_api_name constant varchar2(30) := 'Update_Sort_criteria';
426: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
427: l_row_id VARCHAR2(20);
428: l_date DATE;
429: l_user_id NUMBER;
430: l_login_id NUMBER;

Line 434: if not fnd_api.compatible_api_call( l_api_version

430: l_login_id NUMBER;
431: l_found BOOLEAN;
432: begin
433: -- Standard call to check for call compatibility
434: if not fnd_api.compatible_api_call( l_api_version
435: ,p_api_version
436: ,l_api_name
437: ,g_pkg_name ) then
438: raise fnd_api.g_exc_unexpected_error;

Line 438: raise fnd_api.g_exc_unexpected_error;

434: if not fnd_api.compatible_api_call( l_api_version
435: ,p_api_version
436: ,l_api_name
437: ,g_pkg_name ) then
438: raise fnd_api.g_exc_unexpected_error;
439: end if;
440:
441: -- Initialize message list if p_init_msg_list is set to TRUE
442: if fnd_api.to_boolean( p_init_msg_list ) then

Line 442: if fnd_api.to_boolean( p_init_msg_list ) then

438: raise fnd_api.g_exc_unexpected_error;
439: end if;
440:
441: -- Initialize message list if p_init_msg_list is set to TRUE
442: if fnd_api.to_boolean( p_init_msg_list ) then
443: fnd_msg_pub.initialize;
444: end if;
445:
446: validate_input

Line 472: if x_return_status = fnd_api.g_ret_sts_unexp_error then

468: ,p_attribute14 => p_attribute14
469: ,p_attribute15 => p_attribute15
470: );
471:
472: if x_return_status = fnd_api.g_ret_sts_unexp_error then
473: raise fnd_api.g_exc_unexpected_error;
474: elsif x_return_status = fnd_api.g_ret_sts_error then
475: raise fnd_api.g_exc_error;
476: end if;

Line 473: raise fnd_api.g_exc_unexpected_error;

469: ,p_attribute15 => p_attribute15
470: );
471:
472: if x_return_status = fnd_api.g_ret_sts_unexp_error then
473: raise fnd_api.g_exc_unexpected_error;
474: elsif x_return_status = fnd_api.g_ret_sts_error then
475: raise fnd_api.g_exc_error;
476: end if;
477:

Line 474: elsif x_return_status = fnd_api.g_ret_sts_error then

470: );
471:
472: if x_return_status = fnd_api.g_ret_sts_unexp_error then
473: raise fnd_api.g_exc_unexpected_error;
474: elsif x_return_status = fnd_api.g_ret_sts_error then
475: raise fnd_api.g_exc_error;
476: end if;
477:
478: /* get who column information */

Line 475: raise fnd_api.g_exc_error;

471:
472: if x_return_status = fnd_api.g_ret_sts_unexp_error then
473: raise fnd_api.g_exc_unexpected_error;
474: elsif x_return_status = fnd_api.g_ret_sts_error then
475: raise fnd_api.g_exc_error;
476: end if;
477:
478: /* get who column information */
479: SELECT Sysdate INTO l_date FROM dual;

Line 515: WHEN fnd_api.g_exc_error THEN

511:
512: x_return_status := l_return_status;
513:
514: EXCEPTION
515: WHEN fnd_api.g_exc_error THEN
516: x_return_status := fnd_api.g_ret_sts_error;
517: fnd_msg_pub.count_and_get( p_count => x_msg_count
518: ,p_data => x_msg_data );
519:

Line 516: x_return_status := fnd_api.g_ret_sts_error;

512: x_return_status := l_return_status;
513:
514: EXCEPTION
515: WHEN fnd_api.g_exc_error THEN
516: x_return_status := fnd_api.g_ret_sts_error;
517: fnd_msg_pub.count_and_get( p_count => x_msg_count
518: ,p_data => x_msg_data );
519:
520: WHEN fnd_api.g_exc_unexpected_error THEN

Line 520: WHEN fnd_api.g_exc_unexpected_error THEN

516: x_return_status := fnd_api.g_ret_sts_error;
517: fnd_msg_pub.count_and_get( p_count => x_msg_count
518: ,p_data => x_msg_data );
519:
520: WHEN fnd_api.g_exc_unexpected_error THEN
521: x_return_status := fnd_api.g_ret_sts_unexp_error;
522: fnd_msg_pub.count_and_get( p_count => x_msg_count
523: ,p_data => x_msg_data );
524:

Line 521: x_return_status := fnd_api.g_ret_sts_unexp_error;

517: fnd_msg_pub.count_and_get( p_count => x_msg_count
518: ,p_data => x_msg_data );
519:
520: WHEN fnd_api.g_exc_unexpected_error THEN
521: x_return_status := fnd_api.g_ret_sts_unexp_error;
522: fnd_msg_pub.count_and_get( p_count => x_msg_count
523: ,p_data => x_msg_data );
524:
525: when others then

Line 526: x_return_status := fnd_api.g_ret_sts_unexp_error;

522: fnd_msg_pub.count_and_get( p_count => x_msg_count
523: ,p_data => x_msg_data );
524:
525: when others then
526: x_return_status := fnd_api.g_ret_sts_unexp_error;
527: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
528: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
529: end if;
530: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 537: p_init_msg_list in varchar2 := fnd_api.g_false,

533: end update_sort_criteria ;
534:
535: procedure delete_sort_criteria (
536: p_api_version in NUMBER,
537: p_init_msg_list in varchar2 := fnd_api.g_false,
538: p_validation_level in number := fnd_api.g_valid_level_full,
539: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
540: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
541: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 538: p_validation_level in number := fnd_api.g_valid_level_full,

534:
535: procedure delete_sort_criteria (
536: p_api_version in NUMBER,
537: p_init_msg_list in varchar2 := fnd_api.g_false,
538: p_validation_level in number := fnd_api.g_valid_level_full,
539: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
540: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
541: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
542: p_rowid IN VARCHAR2,

Line 549: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

545: ) is
546: -- API standard variables
547: l_api_version constant number := 1.0;
548: l_api_name constant varchar2(30) := 'Delete_Sort_criteria';
549: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
550: l_dummy_rowid VARCHAR2(18);
551: BEGIN
552:
553: -- Standard call to check for call compatibility

Line 554: if not fnd_api.compatible_api_call( l_api_version

550: l_dummy_rowid VARCHAR2(18);
551: BEGIN
552:
553: -- Standard call to check for call compatibility
554: if not fnd_api.compatible_api_call( l_api_version
555: ,p_api_version
556: ,l_api_name
557: ,g_pkg_name ) then
558: raise fnd_api.g_exc_unexpected_error;

Line 558: raise fnd_api.g_exc_unexpected_error;

554: if not fnd_api.compatible_api_call( l_api_version
555: ,p_api_version
556: ,l_api_name
557: ,g_pkg_name ) then
558: raise fnd_api.g_exc_unexpected_error;
559: end if;
560:
561: -- Initialize message list if p_init_msg_list is set to TRUE
562: if fnd_api.to_boolean( p_init_msg_list ) then

Line 562: if fnd_api.to_boolean( p_init_msg_list ) then

558: raise fnd_api.g_exc_unexpected_error;
559: end if;
560:
561: -- Initialize message list if p_init_msg_list is set to TRUE
562: if fnd_api.to_boolean( p_init_msg_list ) then
563: fnd_msg_pub.initialize;
564: end if;
565:
566: validate_input

Line 572: ,p_parameter_id => fnd_api.g_miss_num -- dont care

568: x_return_status => x_return_status
569: ,p_action => 'DELETE'
570: ,p_rule_id => p_rule_id
571: ,p_sequence_number => p_sequence_number
572: ,p_parameter_id => fnd_api.g_miss_num -- dont care
573: ,p_order_code => fnd_api.g_miss_num
574: ,p_attribute_category => fnd_api.g_miss_char
575: ,p_attribute1 => fnd_api.g_miss_char
576: ,p_attribute2 => fnd_api.g_miss_char

Line 573: ,p_order_code => fnd_api.g_miss_num

569: ,p_action => 'DELETE'
570: ,p_rule_id => p_rule_id
571: ,p_sequence_number => p_sequence_number
572: ,p_parameter_id => fnd_api.g_miss_num -- dont care
573: ,p_order_code => fnd_api.g_miss_num
574: ,p_attribute_category => fnd_api.g_miss_char
575: ,p_attribute1 => fnd_api.g_miss_char
576: ,p_attribute2 => fnd_api.g_miss_char
577: ,p_attribute3 => fnd_api.g_miss_char

Line 574: ,p_attribute_category => fnd_api.g_miss_char

570: ,p_rule_id => p_rule_id
571: ,p_sequence_number => p_sequence_number
572: ,p_parameter_id => fnd_api.g_miss_num -- dont care
573: ,p_order_code => fnd_api.g_miss_num
574: ,p_attribute_category => fnd_api.g_miss_char
575: ,p_attribute1 => fnd_api.g_miss_char
576: ,p_attribute2 => fnd_api.g_miss_char
577: ,p_attribute3 => fnd_api.g_miss_char
578: ,p_attribute4 => fnd_api.g_miss_char

Line 575: ,p_attribute1 => fnd_api.g_miss_char

571: ,p_sequence_number => p_sequence_number
572: ,p_parameter_id => fnd_api.g_miss_num -- dont care
573: ,p_order_code => fnd_api.g_miss_num
574: ,p_attribute_category => fnd_api.g_miss_char
575: ,p_attribute1 => fnd_api.g_miss_char
576: ,p_attribute2 => fnd_api.g_miss_char
577: ,p_attribute3 => fnd_api.g_miss_char
578: ,p_attribute4 => fnd_api.g_miss_char
579: ,p_attribute5 => fnd_api.g_miss_char

Line 576: ,p_attribute2 => fnd_api.g_miss_char

572: ,p_parameter_id => fnd_api.g_miss_num -- dont care
573: ,p_order_code => fnd_api.g_miss_num
574: ,p_attribute_category => fnd_api.g_miss_char
575: ,p_attribute1 => fnd_api.g_miss_char
576: ,p_attribute2 => fnd_api.g_miss_char
577: ,p_attribute3 => fnd_api.g_miss_char
578: ,p_attribute4 => fnd_api.g_miss_char
579: ,p_attribute5 => fnd_api.g_miss_char
580: ,p_attribute6 => fnd_api.g_miss_char

Line 577: ,p_attribute3 => fnd_api.g_miss_char

573: ,p_order_code => fnd_api.g_miss_num
574: ,p_attribute_category => fnd_api.g_miss_char
575: ,p_attribute1 => fnd_api.g_miss_char
576: ,p_attribute2 => fnd_api.g_miss_char
577: ,p_attribute3 => fnd_api.g_miss_char
578: ,p_attribute4 => fnd_api.g_miss_char
579: ,p_attribute5 => fnd_api.g_miss_char
580: ,p_attribute6 => fnd_api.g_miss_char
581: ,p_attribute7 => fnd_api.g_miss_char

Line 578: ,p_attribute4 => fnd_api.g_miss_char

574: ,p_attribute_category => fnd_api.g_miss_char
575: ,p_attribute1 => fnd_api.g_miss_char
576: ,p_attribute2 => fnd_api.g_miss_char
577: ,p_attribute3 => fnd_api.g_miss_char
578: ,p_attribute4 => fnd_api.g_miss_char
579: ,p_attribute5 => fnd_api.g_miss_char
580: ,p_attribute6 => fnd_api.g_miss_char
581: ,p_attribute7 => fnd_api.g_miss_char
582: ,p_attribute8 => fnd_api.g_miss_char

Line 579: ,p_attribute5 => fnd_api.g_miss_char

575: ,p_attribute1 => fnd_api.g_miss_char
576: ,p_attribute2 => fnd_api.g_miss_char
577: ,p_attribute3 => fnd_api.g_miss_char
578: ,p_attribute4 => fnd_api.g_miss_char
579: ,p_attribute5 => fnd_api.g_miss_char
580: ,p_attribute6 => fnd_api.g_miss_char
581: ,p_attribute7 => fnd_api.g_miss_char
582: ,p_attribute8 => fnd_api.g_miss_char
583: ,p_attribute9 => fnd_api.g_miss_char

Line 580: ,p_attribute6 => fnd_api.g_miss_char

576: ,p_attribute2 => fnd_api.g_miss_char
577: ,p_attribute3 => fnd_api.g_miss_char
578: ,p_attribute4 => fnd_api.g_miss_char
579: ,p_attribute5 => fnd_api.g_miss_char
580: ,p_attribute6 => fnd_api.g_miss_char
581: ,p_attribute7 => fnd_api.g_miss_char
582: ,p_attribute8 => fnd_api.g_miss_char
583: ,p_attribute9 => fnd_api.g_miss_char
584: ,p_attribute10 => fnd_api.g_miss_char

Line 581: ,p_attribute7 => fnd_api.g_miss_char

577: ,p_attribute3 => fnd_api.g_miss_char
578: ,p_attribute4 => fnd_api.g_miss_char
579: ,p_attribute5 => fnd_api.g_miss_char
580: ,p_attribute6 => fnd_api.g_miss_char
581: ,p_attribute7 => fnd_api.g_miss_char
582: ,p_attribute8 => fnd_api.g_miss_char
583: ,p_attribute9 => fnd_api.g_miss_char
584: ,p_attribute10 => fnd_api.g_miss_char
585: ,p_attribute11 => fnd_api.g_miss_char

Line 582: ,p_attribute8 => fnd_api.g_miss_char

578: ,p_attribute4 => fnd_api.g_miss_char
579: ,p_attribute5 => fnd_api.g_miss_char
580: ,p_attribute6 => fnd_api.g_miss_char
581: ,p_attribute7 => fnd_api.g_miss_char
582: ,p_attribute8 => fnd_api.g_miss_char
583: ,p_attribute9 => fnd_api.g_miss_char
584: ,p_attribute10 => fnd_api.g_miss_char
585: ,p_attribute11 => fnd_api.g_miss_char
586: ,p_attribute12 => fnd_api.g_miss_char

Line 583: ,p_attribute9 => fnd_api.g_miss_char

579: ,p_attribute5 => fnd_api.g_miss_char
580: ,p_attribute6 => fnd_api.g_miss_char
581: ,p_attribute7 => fnd_api.g_miss_char
582: ,p_attribute8 => fnd_api.g_miss_char
583: ,p_attribute9 => fnd_api.g_miss_char
584: ,p_attribute10 => fnd_api.g_miss_char
585: ,p_attribute11 => fnd_api.g_miss_char
586: ,p_attribute12 => fnd_api.g_miss_char
587: ,p_attribute13 => fnd_api.g_miss_char

Line 584: ,p_attribute10 => fnd_api.g_miss_char

580: ,p_attribute6 => fnd_api.g_miss_char
581: ,p_attribute7 => fnd_api.g_miss_char
582: ,p_attribute8 => fnd_api.g_miss_char
583: ,p_attribute9 => fnd_api.g_miss_char
584: ,p_attribute10 => fnd_api.g_miss_char
585: ,p_attribute11 => fnd_api.g_miss_char
586: ,p_attribute12 => fnd_api.g_miss_char
587: ,p_attribute13 => fnd_api.g_miss_char
588: ,p_attribute14 => fnd_api.g_miss_char

Line 585: ,p_attribute11 => fnd_api.g_miss_char

581: ,p_attribute7 => fnd_api.g_miss_char
582: ,p_attribute8 => fnd_api.g_miss_char
583: ,p_attribute9 => fnd_api.g_miss_char
584: ,p_attribute10 => fnd_api.g_miss_char
585: ,p_attribute11 => fnd_api.g_miss_char
586: ,p_attribute12 => fnd_api.g_miss_char
587: ,p_attribute13 => fnd_api.g_miss_char
588: ,p_attribute14 => fnd_api.g_miss_char
589: ,p_attribute15 => fnd_api.g_miss_char

Line 586: ,p_attribute12 => fnd_api.g_miss_char

582: ,p_attribute8 => fnd_api.g_miss_char
583: ,p_attribute9 => fnd_api.g_miss_char
584: ,p_attribute10 => fnd_api.g_miss_char
585: ,p_attribute11 => fnd_api.g_miss_char
586: ,p_attribute12 => fnd_api.g_miss_char
587: ,p_attribute13 => fnd_api.g_miss_char
588: ,p_attribute14 => fnd_api.g_miss_char
589: ,p_attribute15 => fnd_api.g_miss_char
590: );

Line 587: ,p_attribute13 => fnd_api.g_miss_char

583: ,p_attribute9 => fnd_api.g_miss_char
584: ,p_attribute10 => fnd_api.g_miss_char
585: ,p_attribute11 => fnd_api.g_miss_char
586: ,p_attribute12 => fnd_api.g_miss_char
587: ,p_attribute13 => fnd_api.g_miss_char
588: ,p_attribute14 => fnd_api.g_miss_char
589: ,p_attribute15 => fnd_api.g_miss_char
590: );
591:

Line 588: ,p_attribute14 => fnd_api.g_miss_char

584: ,p_attribute10 => fnd_api.g_miss_char
585: ,p_attribute11 => fnd_api.g_miss_char
586: ,p_attribute12 => fnd_api.g_miss_char
587: ,p_attribute13 => fnd_api.g_miss_char
588: ,p_attribute14 => fnd_api.g_miss_char
589: ,p_attribute15 => fnd_api.g_miss_char
590: );
591:
592: if x_return_status = fnd_api.g_ret_sts_unexp_error then

Line 589: ,p_attribute15 => fnd_api.g_miss_char

585: ,p_attribute11 => fnd_api.g_miss_char
586: ,p_attribute12 => fnd_api.g_miss_char
587: ,p_attribute13 => fnd_api.g_miss_char
588: ,p_attribute14 => fnd_api.g_miss_char
589: ,p_attribute15 => fnd_api.g_miss_char
590: );
591:
592: if x_return_status = fnd_api.g_ret_sts_unexp_error then
593: raise fnd_api.g_exc_unexpected_error;

Line 592: if x_return_status = fnd_api.g_ret_sts_unexp_error then

588: ,p_attribute14 => fnd_api.g_miss_char
589: ,p_attribute15 => fnd_api.g_miss_char
590: );
591:
592: if x_return_status = fnd_api.g_ret_sts_unexp_error then
593: raise fnd_api.g_exc_unexpected_error;
594: elsif x_return_status = fnd_api.g_ret_sts_error then
595: raise fnd_api.g_exc_error;
596: end if;

Line 593: raise fnd_api.g_exc_unexpected_error;

589: ,p_attribute15 => fnd_api.g_miss_char
590: );
591:
592: if x_return_status = fnd_api.g_ret_sts_unexp_error then
593: raise fnd_api.g_exc_unexpected_error;
594: elsif x_return_status = fnd_api.g_ret_sts_error then
595: raise fnd_api.g_exc_error;
596: end if;
597:

Line 594: elsif x_return_status = fnd_api.g_ret_sts_error then

590: );
591:
592: if x_return_status = fnd_api.g_ret_sts_unexp_error then
593: raise fnd_api.g_exc_unexpected_error;
594: elsif x_return_status = fnd_api.g_ret_sts_error then
595: raise fnd_api.g_exc_error;
596: end if;
597:
598: wms_sort_criteria_pkg.delete_row(p_rowid);

Line 595: raise fnd_api.g_exc_error;

591:
592: if x_return_status = fnd_api.g_ret_sts_unexp_error then
593: raise fnd_api.g_exc_unexpected_error;
594: elsif x_return_status = fnd_api.g_ret_sts_error then
595: raise fnd_api.g_exc_error;
596: end if;
597:
598: wms_sort_criteria_pkg.delete_row(p_rowid);
599: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 604: WHEN fnd_api.g_exc_error THEN

600: ,p_data => x_msg_data );
601: x_return_status := l_return_status;
602:
603: EXCEPTION
604: WHEN fnd_api.g_exc_error THEN
605: x_return_status := fnd_api.g_ret_sts_error;
606: fnd_msg_pub.count_and_get( p_count => x_msg_count
607: ,p_data => x_msg_data );
608:

Line 605: x_return_status := fnd_api.g_ret_sts_error;

601: x_return_status := l_return_status;
602:
603: EXCEPTION
604: WHEN fnd_api.g_exc_error THEN
605: x_return_status := fnd_api.g_ret_sts_error;
606: fnd_msg_pub.count_and_get( p_count => x_msg_count
607: ,p_data => x_msg_data );
608:
609: WHEN fnd_api.g_exc_unexpected_error THEN

Line 609: WHEN fnd_api.g_exc_unexpected_error THEN

605: x_return_status := fnd_api.g_ret_sts_error;
606: fnd_msg_pub.count_and_get( p_count => x_msg_count
607: ,p_data => x_msg_data );
608:
609: WHEN fnd_api.g_exc_unexpected_error THEN
610: x_return_status := fnd_api.g_ret_sts_unexp_error;
611: fnd_msg_pub.count_and_get( p_count => x_msg_count
612: ,p_data => x_msg_data );
613:

Line 610: x_return_status := fnd_api.g_ret_sts_unexp_error;

606: fnd_msg_pub.count_and_get( p_count => x_msg_count
607: ,p_data => x_msg_data );
608:
609: WHEN fnd_api.g_exc_unexpected_error THEN
610: x_return_status := fnd_api.g_ret_sts_unexp_error;
611: fnd_msg_pub.count_and_get( p_count => x_msg_count
612: ,p_data => x_msg_data );
613:
614: WHEN OTHERS THEN

Line 615: x_return_status := fnd_api.g_ret_sts_unexp_error;

611: fnd_msg_pub.count_and_get( p_count => x_msg_count
612: ,p_data => x_msg_data );
613:
614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
617: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
618: end if;
619: fnd_msg_pub.count_and_get( p_count => x_msg_count