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

Line 11: -- Default = FND_API.G_FALSE

7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 13: -- Default = FND_API.G_FALSE

9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2

Line 15: -- Default = FND_API.G_VALID_LEVEL_FULL

11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2
18: -- .
19: -- .

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

42:
43:
44: PROCEDURE get_org_code(
45: p_api_version IN NUMBER
46: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47: ,p_commit IN VARCHAR2 := fnd_api.g_false
48: ,p_validation_level IN NUMBER
49: := fnd_api.g_valid_level_full
50: ,p_organization_id IN NUMBER

Line 47: ,p_commit IN VARCHAR2 := fnd_api.g_false

43:
44: PROCEDURE get_org_code(
45: p_api_version IN NUMBER
46: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47: ,p_commit IN VARCHAR2 := fnd_api.g_false
48: ,p_validation_level IN NUMBER
49: := fnd_api.g_valid_level_full
50: ,p_organization_id IN NUMBER
51: ,x_organization_code OUT NOCOPY VARCHAR2

Line 49: := fnd_api.g_valid_level_full

45: p_api_version IN NUMBER
46: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47: ,p_commit IN VARCHAR2 := fnd_api.g_false
48: ,p_validation_level IN NUMBER
49: := fnd_api.g_valid_level_full
50: ,p_organization_id IN NUMBER
51: ,x_organization_code OUT NOCOPY VARCHAR2
52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER

Line 75: IF NOT fnd_api.compatible_api_call(

71: SAVEPOINT get_org_code_pvt;
72:
73: l_stmt_num := 20;
74: -- Standard call to check for call compatibility.
75: IF NOT fnd_api.compatible_api_call(
76: l_api_version
77: ,p_api_version
78: ,l_api_name
79: ,g_pkg_name) THEN

Line 80: RAISE fnd_api.g_exc_unexpected_error;

76: l_api_version
77: ,p_api_version
78: ,l_api_name
79: ,g_pkg_name) THEN
80: RAISE fnd_api.g_exc_unexpected_error;
81: END IF;
82:
83: l_stmt_num := 30;
84: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 85: IF fnd_api.to_boolean(p_init_msg_list) THEN

81: END IF;
82:
83: l_stmt_num := 30;
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF fnd_api.to_boolean(p_init_msg_list) THEN
86: fnd_msg_pub.initialize;
87: END IF;
88:
89: l_stmt_num := 40;

Line 91: x_return_status := fnd_api.g_ret_sts_success;

87: END IF;
88:
89: l_stmt_num := 40;
90: -- Initialize API return status to success
91: x_return_status := fnd_api.g_ret_sts_success;
92:
93: l_stmt_num := 50;
94: -- API body
95: l_organization_id := 0;

Line 103: RAISE fnd_api.g_exc_error;

99:
100: fnd_message.set_name('EAM', 'EAM_INPUT_PARAMS_NULL');
101: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
102: fnd_msg_pub.add;
103: RAISE fnd_api.g_exc_error;
104: END IF;
105:
106: l_organization_id := p_organization_id;
107:

Line 117: RAISE fnd_api.g_exc_error;

113:
114: fnd_message.set_name('EAM', 'EAM_ORG_CODE_NULL');
115: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
116: fnd_msg_pub.add;
117: RAISE fnd_api.g_exc_error;
118: END IF;
119: CLOSE c_org_code;
120:
121: x_organization_code := l_organization_code;

Line 126: IF fnd_api.to_boolean(p_commit) THEN

122:
123: l_stmt_num := 998;
124: -- End of API body.
125: -- Standard check of p_commit.
126: IF fnd_api.to_boolean(p_commit) THEN
127: COMMIT WORK;
128: END IF;
129:
130: l_stmt_num := 999;

Line 136: WHEN fnd_api.g_exc_error THEN

132: fnd_msg_pub.count_and_get(
133: p_count => x_msg_count
134: ,p_data => x_msg_data);
135: EXCEPTION
136: WHEN fnd_api.g_exc_error THEN
137: ROLLBACK TO get_org_code_pvt;
138: x_return_status := fnd_api.g_ret_sts_error;
139: fnd_msg_pub.count_and_get(
140: p_count => x_msg_count

Line 138: x_return_status := fnd_api.g_ret_sts_error;

134: ,p_data => x_msg_data);
135: EXCEPTION
136: WHEN fnd_api.g_exc_error THEN
137: ROLLBACK TO get_org_code_pvt;
138: x_return_status := fnd_api.g_ret_sts_error;
139: fnd_msg_pub.count_and_get(
140: p_count => x_msg_count
141: ,p_data => x_msg_data);
142: WHEN fnd_api.g_exc_unexpected_error THEN

Line 142: WHEN fnd_api.g_exc_unexpected_error THEN

138: x_return_status := fnd_api.g_ret_sts_error;
139: fnd_msg_pub.count_and_get(
140: p_count => x_msg_count
141: ,p_data => x_msg_data);
142: WHEN fnd_api.g_exc_unexpected_error THEN
143: ROLLBACK TO get_org_code_pvt;
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145:
146: fnd_msg_pub.count_and_get(

Line 144: x_return_status := fnd_api.g_ret_sts_unexp_error;

140: p_count => x_msg_count
141: ,p_data => x_msg_data);
142: WHEN fnd_api.g_exc_unexpected_error THEN
143: ROLLBACK TO get_org_code_pvt;
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145:
146: fnd_msg_pub.count_and_get(
147: p_count => x_msg_count
148: ,p_data => x_msg_data);

Line 151: x_return_status := fnd_api.g_ret_sts_unexp_error;

147: p_count => x_msg_count
148: ,p_data => x_msg_data);
149: WHEN OTHERS THEN
150: ROLLBACK TO get_org_code_pvt;
151: x_return_status := fnd_api.g_ret_sts_unexp_error;
152: IF fnd_msg_pub.check_msg_level(
153: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
154: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
155: END IF;

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

160: END get_org_code;
161:
162: PROCEDURE get_item_id(
163: p_api_version IN NUMBER
164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165: ,p_commit IN VARCHAR2 := fnd_api.g_false
166: ,p_validation_level IN NUMBER
167: := fnd_api.g_valid_level_full
168: ,p_organization_id IN NUMBER

Line 165: ,p_commit IN VARCHAR2 := fnd_api.g_false

161:
162: PROCEDURE get_item_id(
163: p_api_version IN NUMBER
164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165: ,p_commit IN VARCHAR2 := fnd_api.g_false
166: ,p_validation_level IN NUMBER
167: := fnd_api.g_valid_level_full
168: ,p_organization_id IN NUMBER
169: ,p_concatenated_segments IN VARCHAR2

Line 167: := fnd_api.g_valid_level_full

163: p_api_version IN NUMBER
164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165: ,p_commit IN VARCHAR2 := fnd_api.g_false
166: ,p_validation_level IN NUMBER
167: := fnd_api.g_valid_level_full
168: ,p_organization_id IN NUMBER
169: ,p_concatenated_segments IN VARCHAR2
170: ,x_inventory_item_id OUT NOCOPY NUMBER
171: ,x_return_status OUT NOCOPY VARCHAR2

Line 189: IF NOT fnd_api.compatible_api_call(

185: SAVEPOINT get_item_id_pvt;
186:
187: l_stmt_num := 20;
188: -- Standard call to check for call compatibility.
189: IF NOT fnd_api.compatible_api_call(
190: l_api_version
191: ,p_api_version
192: ,l_api_name
193: ,g_pkg_name) THEN

Line 194: RAISE fnd_api.g_exc_unexpected_error;

190: l_api_version
191: ,p_api_version
192: ,l_api_name
193: ,g_pkg_name) THEN
194: RAISE fnd_api.g_exc_unexpected_error;
195: END IF;
196:
197: l_stmt_num := 30;
198: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 199: IF fnd_api.to_boolean(p_init_msg_list) THEN

195: END IF;
196:
197: l_stmt_num := 30;
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF fnd_api.to_boolean(p_init_msg_list) THEN
200: fnd_msg_pub.initialize;
201: END IF;
202:
203: l_stmt_num := 40;

Line 205: x_return_status := fnd_api.g_ret_sts_success;

201: END IF;
202:
203: l_stmt_num := 40;
204: -- Initialize API return status to success
205: x_return_status := fnd_api.g_ret_sts_success;
206:
207: l_stmt_num := 50;
208: -- API body
209: l_organization_id := NULL;

Line 219: RAISE fnd_api.g_exc_error;

215:
216: fnd_message.set_name('EAM', 'EAM_INPUT_PARAMS_NULL');
217: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
218: fnd_msg_pub.add;
219: RAISE fnd_api.g_exc_error;
220: END IF;
221:
222: l_organization_id := p_organization_id;
223: l_concatenated_segments := p_concatenated_segments;

Line 240: IF fnd_api.to_boolean(p_commit) THEN

236:
237: l_stmt_num := 998;
238: -- End of API body.
239: -- Standard check of p_commit.
240: IF fnd_api.to_boolean(p_commit) THEN
241: COMMIT WORK;
242: END IF;
243:
244: l_stmt_num := 999;

Line 250: WHEN fnd_api.g_exc_error THEN

246: fnd_msg_pub.count_and_get(
247: p_count => x_msg_count
248: ,p_data => x_msg_data);
249: EXCEPTION
250: WHEN fnd_api.g_exc_error THEN
251: ROLLBACK TO get_org_code_pvt;
252: x_return_status := fnd_api.g_ret_sts_error;
253: fnd_msg_pub.count_and_get(
254: p_count => x_msg_count

Line 252: x_return_status := fnd_api.g_ret_sts_error;

248: ,p_data => x_msg_data);
249: EXCEPTION
250: WHEN fnd_api.g_exc_error THEN
251: ROLLBACK TO get_org_code_pvt;
252: x_return_status := fnd_api.g_ret_sts_error;
253: fnd_msg_pub.count_and_get(
254: p_count => x_msg_count
255: ,p_data => x_msg_data);
256: WHEN fnd_api.g_exc_unexpected_error THEN

Line 256: WHEN fnd_api.g_exc_unexpected_error THEN

252: x_return_status := fnd_api.g_ret_sts_error;
253: fnd_msg_pub.count_and_get(
254: p_count => x_msg_count
255: ,p_data => x_msg_data);
256: WHEN fnd_api.g_exc_unexpected_error THEN
257: ROLLBACK TO get_org_code_pvt;
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259: fnd_msg_pub.count_and_get(
260: p_count => x_msg_count

Line 258: x_return_status := fnd_api.g_ret_sts_unexp_error;

254: p_count => x_msg_count
255: ,p_data => x_msg_data);
256: WHEN fnd_api.g_exc_unexpected_error THEN
257: ROLLBACK TO get_org_code_pvt;
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259: fnd_msg_pub.count_and_get(
260: p_count => x_msg_count
261: ,p_data => x_msg_data);
262: WHEN OTHERS THEN

Line 264: x_return_status := fnd_api.g_ret_sts_unexp_error;

260: p_count => x_msg_count
261: ,p_data => x_msg_data);
262: WHEN OTHERS THEN
263: ROLLBACK TO get_org_code_pvt;
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: IF fnd_msg_pub.check_msg_level(
267: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

279:
280:
281: PROCEDURE get_current_period(
282: p_api_version IN NUMBER
283: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
284: ,p_commit IN VARCHAR2 := fnd_api.g_false
285: ,p_validation_level IN NUMBER
286: := fnd_api.g_valid_level_full
287: ,p_organization_id IN NUMBER

Line 284: ,p_commit IN VARCHAR2 := fnd_api.g_false

280:
281: PROCEDURE get_current_period(
282: p_api_version IN NUMBER
283: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
284: ,p_commit IN VARCHAR2 := fnd_api.g_false
285: ,p_validation_level IN NUMBER
286: := fnd_api.g_valid_level_full
287: ,p_organization_id IN NUMBER
288: ,x_period_name OUT NOCOPY VARCHAR2

Line 286: := fnd_api.g_valid_level_full

282: p_api_version IN NUMBER
283: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
284: ,p_commit IN VARCHAR2 := fnd_api.g_false
285: ,p_validation_level IN NUMBER
286: := fnd_api.g_valid_level_full
287: ,p_organization_id IN NUMBER
288: ,x_period_name OUT NOCOPY VARCHAR2
289: ,x_return_status OUT NOCOPY VARCHAR2
290: ,x_msg_count OUT NOCOPY NUMBER

Line 309: IF NOT fnd_api.compatible_api_call(

305: SAVEPOINT get_current_period_pvt;
306:
307: l_stmt_num := 20;
308: -- Standard call to check for call compatibility.
309: IF NOT fnd_api.compatible_api_call(
310: l_api_version
311: ,p_api_version
312: ,l_api_name
313: ,g_pkg_name) THEN

Line 314: RAISE fnd_api.g_exc_unexpected_error;

310: l_api_version
311: ,p_api_version
312: ,l_api_name
313: ,g_pkg_name) THEN
314: RAISE fnd_api.g_exc_unexpected_error;
315: END IF;
316:
317: l_stmt_num := 30;
318: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 319: IF fnd_api.to_boolean(p_init_msg_list) THEN

315: END IF;
316:
317: l_stmt_num := 30;
318: -- Initialize message list if p_init_msg_list is set to TRUE.
319: IF fnd_api.to_boolean(p_init_msg_list) THEN
320: fnd_msg_pub.initialize;
321: END IF;
322:
323: l_stmt_num := 40;

Line 325: x_return_status := fnd_api.g_ret_sts_success;

321: END IF;
322:
323: l_stmt_num := 40;
324: -- Initialize API return status to success
325: x_return_status := fnd_api.g_ret_sts_success;
326:
327: l_stmt_num := 50;
328: -- API body
329: l_organization_id := 0;

Line 338: RAISE fnd_api.g_exc_error;

334:
335: fnd_message.set_name('EAM', 'EAM_INPUT_PARAMS_NULL');
336: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
337: fnd_msg_pub.add;
338: RAISE fnd_api.g_exc_error;
339: END IF;
340:
341: l_organization_id := p_organization_id;
342:

Line 360: IF fnd_api.to_boolean(p_commit) THEN

356:
357: l_stmt_num := 998;
358: -- End of API body.
359: -- Standard check of p_commit.
360: IF fnd_api.to_boolean(p_commit) THEN
361: COMMIT WORK;
362: END IF;
363:
364: l_stmt_num := 999;

Line 370: WHEN fnd_api.g_exc_error THEN

366: fnd_msg_pub.count_and_get(
367: p_count => x_msg_count
368: ,p_data => x_msg_data);
369: EXCEPTION
370: WHEN fnd_api.g_exc_error THEN
371: ROLLBACK TO get_current_period_pvt;
372: x_return_status := fnd_api.g_ret_sts_error;
373: fnd_msg_pub.count_and_get(
374: p_count => x_msg_count

Line 372: x_return_status := fnd_api.g_ret_sts_error;

368: ,p_data => x_msg_data);
369: EXCEPTION
370: WHEN fnd_api.g_exc_error THEN
371: ROLLBACK TO get_current_period_pvt;
372: x_return_status := fnd_api.g_ret_sts_error;
373: fnd_msg_pub.count_and_get(
374: p_count => x_msg_count
375: ,p_data => x_msg_data);
376: WHEN fnd_api.g_exc_unexpected_error THEN

Line 376: WHEN fnd_api.g_exc_unexpected_error THEN

372: x_return_status := fnd_api.g_ret_sts_error;
373: fnd_msg_pub.count_and_get(
374: p_count => x_msg_count
375: ,p_data => x_msg_data);
376: WHEN fnd_api.g_exc_unexpected_error THEN
377: ROLLBACK TO get_current_period_pvt;
378: x_return_status := fnd_api.g_ret_sts_unexp_error;
379: fnd_msg_pub.count_and_get(
380: p_count => x_msg_count

Line 378: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 384: x_return_status := fnd_api.g_ret_sts_unexp_error;

380: p_count => x_msg_count
381: ,p_data => x_msg_data);
382: WHEN OTHERS THEN
383: ROLLBACK TO get_current_period_pvt;
384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385:
386: IF fnd_msg_pub.check_msg_level(
387: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

398:
399:
400: PROCEDURE get_currency(
401: p_api_version IN NUMBER
402: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
403: ,p_commit IN VARCHAR2 := fnd_api.g_false
404: ,p_validation_level IN NUMBER
405: := fnd_api.g_valid_level_full
406: ,p_organization_id IN NUMBER

Line 403: ,p_commit IN VARCHAR2 := fnd_api.g_false

399:
400: PROCEDURE get_currency(
401: p_api_version IN NUMBER
402: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
403: ,p_commit IN VARCHAR2 := fnd_api.g_false
404: ,p_validation_level IN NUMBER
405: := fnd_api.g_valid_level_full
406: ,p_organization_id IN NUMBER
407: ,x_currency OUT NOCOPY VARCHAR2

Line 405: := fnd_api.g_valid_level_full

401: p_api_version IN NUMBER
402: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
403: ,p_commit IN VARCHAR2 := fnd_api.g_false
404: ,p_validation_level IN NUMBER
405: := fnd_api.g_valid_level_full
406: ,p_organization_id IN NUMBER
407: ,x_currency OUT NOCOPY VARCHAR2
408: ,x_return_status OUT NOCOPY VARCHAR2
409: ,x_msg_count OUT NOCOPY NUMBER

Line 426: IF NOT fnd_api.compatible_api_call(

422: SAVEPOINT get_currency_pvt;
423:
424: l_stmt_num := 20;
425: -- Standard call to check for call compatibility.
426: IF NOT fnd_api.compatible_api_call(
427: l_api_version
428: ,p_api_version
429: ,l_api_name
430: ,g_pkg_name) THEN

Line 431: RAISE fnd_api.g_exc_unexpected_error;

427: l_api_version
428: ,p_api_version
429: ,l_api_name
430: ,g_pkg_name) THEN
431: RAISE fnd_api.g_exc_unexpected_error;
432: END IF;
433:
434: l_stmt_num := 30;
435: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 436: IF fnd_api.to_boolean(p_init_msg_list) THEN

432: END IF;
433:
434: l_stmt_num := 30;
435: -- Initialize message list if p_init_msg_list is set to TRUE.
436: IF fnd_api.to_boolean(p_init_msg_list) THEN
437: fnd_msg_pub.initialize;
438: END IF;
439:
440: l_stmt_num := 40;

Line 442: x_return_status := fnd_api.g_ret_sts_success;

438: END IF;
439:
440: l_stmt_num := 40;
441: -- Initialize API return status to success
442: x_return_status := fnd_api.g_ret_sts_success;
443:
444: l_stmt_num := 50;
445: -- API body
446: l_organization_id := 0;

Line 455: RAISE fnd_api.g_exc_error;

451:
452: fnd_message.set_name('EAM', 'EAM_INPUT_PARAMS_NULL');
453: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
454: fnd_msg_pub.add;
455: RAISE fnd_api.g_exc_error;
456: END IF;
457:
458: l_organization_id := p_organization_id;
459:

Line 469: IF fnd_api.to_boolean(p_commit) THEN

465:
466: l_stmt_num := 998;
467: -- End of API body.
468: -- Standard check of p_commit.
469: IF fnd_api.to_boolean(p_commit) THEN
470: COMMIT WORK;
471: END IF;
472:
473: l_stmt_num := 999;

Line 479: WHEN fnd_api.g_exc_error THEN

475: fnd_msg_pub.count_and_get(
476: p_count => x_msg_count
477: ,p_data => x_msg_data);
478: EXCEPTION
479: WHEN fnd_api.g_exc_error THEN
480: ROLLBACK TO get_currency_pvt;
481: x_return_status := fnd_api.g_ret_sts_error;
482: fnd_msg_pub.count_and_get(
483: p_count => x_msg_count

Line 481: x_return_status := fnd_api.g_ret_sts_error;

477: ,p_data => x_msg_data);
478: EXCEPTION
479: WHEN fnd_api.g_exc_error THEN
480: ROLLBACK TO get_currency_pvt;
481: x_return_status := fnd_api.g_ret_sts_error;
482: fnd_msg_pub.count_and_get(
483: p_count => x_msg_count
484: ,p_data => x_msg_data);
485: WHEN fnd_api.g_exc_unexpected_error THEN

Line 485: WHEN fnd_api.g_exc_unexpected_error THEN

481: x_return_status := fnd_api.g_ret_sts_error;
482: fnd_msg_pub.count_and_get(
483: p_count => x_msg_count
484: ,p_data => x_msg_data);
485: WHEN fnd_api.g_exc_unexpected_error THEN
486: ROLLBACK TO get_currency_pvt;
487: x_return_status := fnd_api.g_ret_sts_unexp_error;
488: fnd_msg_pub.count_and_get(
489: p_count => x_msg_count

Line 487: x_return_status := fnd_api.g_ret_sts_unexp_error;

483: p_count => x_msg_count
484: ,p_data => x_msg_data);
485: WHEN fnd_api.g_exc_unexpected_error THEN
486: ROLLBACK TO get_currency_pvt;
487: x_return_status := fnd_api.g_ret_sts_unexp_error;
488: fnd_msg_pub.count_and_get(
489: p_count => x_msg_count
490: ,p_data => x_msg_data);
491: WHEN OTHERS THEN

Line 493: x_return_status := fnd_api.g_ret_sts_unexp_error;

489: p_count => x_msg_count
490: ,p_data => x_msg_data);
491: WHEN OTHERS THEN
492: ROLLBACK TO get_currency_pvt;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494:
495: IF fnd_msg_pub.check_msg_level(
496: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
497: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

506:
507:
508: PROCEDURE get_next_asset_number (
509: p_api_version IN NUMBER
510: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
511: ,p_commit IN VARCHAR2 := fnd_api.g_false
512: ,p_validation_level IN NUMBER
513: := fnd_api.g_valid_level_full
514: ,p_organization_id IN NUMBER

Line 511: ,p_commit IN VARCHAR2 := fnd_api.g_false

507:
508: PROCEDURE get_next_asset_number (
509: p_api_version IN NUMBER
510: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
511: ,p_commit IN VARCHAR2 := fnd_api.g_false
512: ,p_validation_level IN NUMBER
513: := fnd_api.g_valid_level_full
514: ,p_organization_id IN NUMBER
515: ,p_inventory_item_id IN NUMBER

Line 513: := fnd_api.g_valid_level_full

509: p_api_version IN NUMBER
510: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
511: ,p_commit IN VARCHAR2 := fnd_api.g_false
512: ,p_validation_level IN NUMBER
513: := fnd_api.g_valid_level_full
514: ,p_organization_id IN NUMBER
515: ,p_inventory_item_id IN NUMBER
516: ,x_asset_number OUT NOCOPY VARCHAR2
517: ,x_return_status OUT NOCOPY VARCHAR2

Line 544: IF NOT fnd_api.compatible_api_call(

540: SAVEPOINT get_next_asset_number_pvt;
541:
542: l_stmt_num := 20;
543: -- Standard call to check for call compatibility.
544: IF NOT fnd_api.compatible_api_call(
545: l_api_version
546: ,p_api_version
547: ,l_api_name
548: ,g_pkg_name) THEN

Line 549: RAISE fnd_api.g_exc_unexpected_error;

545: l_api_version
546: ,p_api_version
547: ,l_api_name
548: ,g_pkg_name) THEN
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551:
552: l_stmt_num := 30;
553: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 554: IF fnd_api.to_boolean(p_init_msg_list) THEN

550: END IF;
551:
552: l_stmt_num := 30;
553: -- Initialize message list if p_init_msg_list is set to TRUE.
554: IF fnd_api.to_boolean(p_init_msg_list) THEN
555: fnd_msg_pub.initialize;
556: END IF;
557:
558: l_stmt_num := 40;

Line 560: x_return_status := fnd_api.g_ret_sts_success;

556: END IF;
557:
558: l_stmt_num := 40;
559: -- Initialize API return status to success
560: x_return_status := fnd_api.g_ret_sts_success;
561:
562: l_stmt_num := 50;
563: -- API body
564: l_organization_id := 0;

Line 566: l_disable_allowed := FND_API.G_TRUE;

562: l_stmt_num := 50;
563: -- API body
564: l_organization_id := 0;
565:
566: l_disable_allowed := FND_API.G_TRUE;
567:
568: l_stmt_num := 60;
569: SELECT SERIAL_NUMBER_GENERATION
570: INTO l_serial_generation

Line 609: l_success := FND_API.G_FALSE;

605: -- FOR UPDATE OF START_AUTO_SERIAL_NUMBER;
606:
607: END IF;
608:
609: l_success := FND_API.G_FALSE;
610:
611: /* Here we use the condition "l_success = FND_API.G_FALSE"
612: * as the loop invariant. The loop will continue unless one
613: * of the validation test fails, when l_success will be assigned

Line 611: /* Here we use the condition "l_success = FND_API.G_FALSE"

607: END IF;
608:
609: l_success := FND_API.G_FALSE;
610:
611: /* Here we use the condition "l_success = FND_API.G_FALSE"
612: * as the loop invariant. The loop will continue unless one
613: * of the validation test fails, when l_success will be assigned
614: * FND_API.G_TRUE
615: */

Line 614: * FND_API.G_TRUE

610:
611: /* Here we use the condition "l_success = FND_API.G_FALSE"
612: * as the loop invariant. The loop will continue unless one
613: * of the validation test fails, when l_success will be assigned
614: * FND_API.G_TRUE
615: */
616: WHILE (l_success = FND_API.G_FALSE) LOOP
617:
618: l_success := FND_API.G_TRUE;

Line 616: WHILE (l_success = FND_API.G_FALSE) LOOP

612: * as the loop invariant. The loop will continue unless one
613: * of the validation test fails, when l_success will be assigned
614: * FND_API.G_TRUE
615: */
616: WHILE (l_success = FND_API.G_FALSE) LOOP
617:
618: l_success := FND_API.G_TRUE;
619:
620: IF (l_asset_number IS NOT NULL) THEN

Line 618: l_success := FND_API.G_TRUE;

614: * FND_API.G_TRUE
615: */
616: WHILE (l_success = FND_API.G_FALSE) LOOP
617:
618: l_success := FND_API.G_TRUE;
619:
620: IF (l_asset_number IS NOT NULL) THEN
621: l_concat_asset_number := l_asset_prefix ||l_asset_number;
622: ELSE

Line 625: --RAISE fnd_api.g_exc_error;

621: l_concat_asset_number := l_asset_prefix ||l_asset_number;
622: ELSE
623: l_concat_asset_number := NULL;
624: --commenting due to bug 3718290
625: --RAISE fnd_api.g_exc_error;
626: END IF;
627:
628: if (l_concat_asset_number is not null) then
629: l_stmt_num := 90;

Line 652: l_success := FND_API.G_FALSE;

648: /* Fix for bug 3408752. Case 2
649: added inventory_id join. */
650:
651: IF (l_count > 0) THEN
652: l_success := FND_API.G_FALSE;
653: /* Start Fix for bug 3408752. Case 1
654: Check for item start_serial_number in all orgs for that item */
655: ELSE
656: select count(*) into l_count

Line 666: l_success := FND_API.G_FALSE;

662: msi.inventory_item_id=p_inventory_item_id and
663: msi.auto_serial_alpha_prefix=l_asset_prefix and
664: msi.start_auto_serial_number-1=l_asset_number ;
665: IF (l_count > 0) THEN
666: l_success := FND_API.G_FALSE;
667: END IF;
668: /* End Fix for bug 3408752. Case 1
669: Check for item start_serial_number in all orgs for that item */
670: END IF;

Line 682: l_success := FND_API.G_FALSE;

678: WHERE SERIAL_NUMBER = l_concat_asset_number
679: AND CURRENT_ORGANIZATION_ID = p_organization_id;
680:
681: IF (l_count > 0) THEN
682: l_success := FND_API.G_FALSE;
683: END IF;
684:
685: l_stmt_num := 120;
686: SELECT count(*)

Line 695: IF (l_count > 0 AND l_success = FND_API.G_TRUE) THEN

691: AND S.SERIAL_NUMBER = l_concat_asset_number
692: AND P.SERIAL_NUMBER_TYPE = 3;
693:
694:
695: IF (l_count > 0 AND l_success = FND_API.G_TRUE) THEN
696: l_success := FND_API.G_FALSE;
697:
698: /* Start Fix for bug 3408752.
699: Check for item start_serial_number in the same org for all items*/

Line 696: l_success := FND_API.G_FALSE;

692: AND P.SERIAL_NUMBER_TYPE = 3;
693:
694:
695: IF (l_count > 0 AND l_success = FND_API.G_TRUE) THEN
696: l_success := FND_API.G_FALSE;
697:
698: /* Start Fix for bug 3408752.
699: Check for item start_serial_number in the same org for all items*/
700: ELSE

Line 717: l_success := FND_API.G_FALSE;

713: mp.auto_serial_alpha_prefix=l_asset_prefix and
714: mp.start_auto_serial_number-1=l_asset_number;
715: end if;
716: IF (l_count > 0) THEN
717: l_success := FND_API.G_FALSE;
718: END IF;
719: /* End Fix for bug 3408752.
720: Check for item start_serial_number in the same org for all items*/
721: END IF;

Line 732: l_success := FND_API.G_FALSE;

728: FROM MTL_SERIAL_NUMBERS
729: WHERE SERIAL_NUMBER = l_concat_asset_number;
730:
731: IF (l_count > 0 ) THEN
732: l_success := FND_API.G_FALSE;
733: /* Start Fix for bug 3408752.
734: Check for item start_serial_number in all orgs for all items*/
735: ELSE
736: /* Fix Case 5*/

Line 748: l_success := FND_API.G_FALSE;

744: msi.inventory_item_id=p_inventory_item_id and
745: msi.auto_serial_alpha_prefix=l_asset_prefix and
746: msi.start_auto_serial_number-1=l_asset_number;
747: IF (l_count > 0) THEN
748: l_success := FND_API.G_FALSE;
749: ELSE
750: /* Fix Case 6*/
751: /* check in orgs with org level serial number generation */
752: select count(*) into l_count

Line 760: l_success := FND_API.G_FALSE;

756: mp.serial_number_generation = 1 and
757: mp.auto_serial_alpha_prefix=l_asset_prefix and
758: mp.start_auto_serial_number-1=l_asset_number;
759: IF (l_count > 0) THEN
760: l_success := FND_API.G_FALSE;
761: END IF;
762: END IF;
763: /* End Fix for bug 3408752.
764: Check for item start_serial_number in all orgs for all items*/

Line 785: l_success := FND_API.G_FALSE;

781: and msn1.current_organization_id = msi1.organization_id
782: and msi1.base_item_id = l_base_item_id;
783:
784: if l_count > 0 then
785: l_success := FND_API.G_FALSE;
786: end if;
787: end if;
788: --Bug 5188972
789: else

Line 796: l_success := FND_API.G_FALSE;

792: FROM MTL_SERIAL_NUMBERS
793: WHERE serial_number = l_concat_asset_number
794: AND inventory_item_id=p_inventory_item_id;
795: IF (l_count > 0) THEN
796: l_success := FND_API.G_FALSE;
797: ELSE
798: SELECT count(*) INTO l_count
799: FROM
800: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp

Line 808: l_success := FND_API.G_FALSE;

804: msi.inventory_item_id=p_inventory_item_id AND
805: msi.auto_serial_alpha_prefix=l_asset_prefix AND
806: msi.start_auto_serial_number-1=l_asset_number ;
807: IF (l_count > 0) THEN
808: l_success := FND_API.G_FALSE;
809: END IF;
810: END IF;
811: end if;
812:

Line 818: RAISE fnd_api.g_exc_error;

814:
815:
816: ELSE
817: l_concat_asset_number := NULL;
818: RAISE fnd_api.g_exc_error;
819:
820: END IF;
821:
822: -- chrng: 2002-07-25: To fix bug 2479889.

Line 875: IF fnd_api.to_boolean(p_commit) THEN

871:
872: l_stmt_num := 998;
873: -- End of API body.
874: -- Standard check of p_commit.
875: IF fnd_api.to_boolean(p_commit) THEN
876: COMMIT WORK;
877: END IF;
878:
879: l_stmt_num := 999;

Line 882: p_encoded => fnd_api.g_false

878:
879: l_stmt_num := 999;
880: -- Standard call to get message count and if count is 1, get message info.
881: fnd_msg_pub.count_and_get(
882: p_encoded => fnd_api.g_false
883: ,p_count => x_msg_count
884: ,p_data => x_msg_data);
885:
886: EXCEPTION

Line 887: WHEN fnd_api.g_exc_error THEN

883: ,p_count => x_msg_count
884: ,p_data => x_msg_data);
885:
886: EXCEPTION
887: WHEN fnd_api.g_exc_error THEN
888: ROLLBACK TO get_next_asset_number_pvt;
889: x_return_status := fnd_api.g_ret_sts_error;
890: x_asset_number := NULL;
891: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

Line 889: x_return_status := fnd_api.g_ret_sts_error;

885:
886: EXCEPTION
887: WHEN fnd_api.g_exc_error THEN
888: ROLLBACK TO get_next_asset_number_pvt;
889: x_return_status := fnd_api.g_ret_sts_error;
890: x_asset_number := NULL;
891: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
892: fnd_msg_pub.count_and_get(
893: p_encoded => fnd_api.g_false

Line 893: p_encoded => fnd_api.g_false

889: x_return_status := fnd_api.g_ret_sts_error;
890: x_asset_number := NULL;
891: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
892: fnd_msg_pub.count_and_get(
893: p_encoded => fnd_api.g_false
894: ,p_count => x_msg_count
895: ,p_data => x_msg_data);
896: WHEN fnd_api.g_exc_unexpected_error THEN
897: ROLLBACK TO get_next_asset_number_pvt;

Line 896: WHEN fnd_api.g_exc_unexpected_error THEN

892: fnd_msg_pub.count_and_get(
893: p_encoded => fnd_api.g_false
894: ,p_count => x_msg_count
895: ,p_data => x_msg_data);
896: WHEN fnd_api.g_exc_unexpected_error THEN
897: ROLLBACK TO get_next_asset_number_pvt;
898: x_return_status := fnd_api.g_ret_sts_unexp_error;
899: x_asset_number := NULL;
900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

Line 898: x_return_status := fnd_api.g_ret_sts_unexp_error;

894: ,p_count => x_msg_count
895: ,p_data => x_msg_data);
896: WHEN fnd_api.g_exc_unexpected_error THEN
897: ROLLBACK TO get_next_asset_number_pvt;
898: x_return_status := fnd_api.g_ret_sts_unexp_error;
899: x_asset_number := NULL;
900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
901: fnd_msg_pub.count_and_get(
902: p_encoded => fnd_api.g_false

Line 902: p_encoded => fnd_api.g_false

898: x_return_status := fnd_api.g_ret_sts_unexp_error;
899: x_asset_number := NULL;
900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
901: fnd_msg_pub.count_and_get(
902: p_encoded => fnd_api.g_false
903: ,p_count => x_msg_count
904: ,p_data => x_msg_data);
905: WHEN OTHERS THEN
906: ROLLBACK TO get_next_asset_number_pvt;

Line 907: x_return_status := fnd_api.g_ret_sts_unexp_error;

903: ,p_count => x_msg_count
904: ,p_data => x_msg_data);
905: WHEN OTHERS THEN
906: ROLLBACK TO get_next_asset_number_pvt;
907: x_return_status := fnd_api.g_ret_sts_unexp_error;
908: x_asset_number := NULL;
909: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
910: IF fnd_msg_pub.check_msg_level(
911: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 916: p_encoded => fnd_api.g_false

912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;
914:
915: fnd_msg_pub.count_and_get(
916: p_encoded => fnd_api.g_false
917: ,p_count => x_msg_count
918: ,p_data => x_msg_data);
919:
920:

Line 934: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,

930: PROCEDURE verify_org(
931: p_resp_id number,
932: p_resp_app_id number,
933: p_org_id number,
934: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
935: x_boolean out NOCOPY number,
936: x_return_status out NOCOPY VARCHAR2,
937: x_msg_count out NOCOPY NUMBER,
938: x_msg_data out NOCOPY VARCHAR2)

Line 983: x_return_status := fnd_api.g_ret_sts_success;

979: from wip_eam_parameters wep
980: where wep.organization_id = p_org_id;
981: END IF;
982:
983: x_return_status := fnd_api.g_ret_sts_success;
984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: rollback;

Line 988: x_return_status := fnd_api.g_ret_sts_unexp_error;

984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: rollback;
988: x_return_status := fnd_api.g_ret_sts_unexp_error;
989: IF fnd_msg_pub.check_msg_level(
990: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
991: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
992: END IF;

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

1541:
1542:
1543: PROCEDURE get_work_order_count (
1544: p_api_version IN NUMBER
1545: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1546: ,p_commit IN VARCHAR2 := fnd_api.g_false
1547: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1548: ,p_organization_id IN VARCHAR2
1549: ,p_employee_id IN VARCHAR2

Line 1546: ,p_commit IN VARCHAR2 := fnd_api.g_false

1542:
1543: PROCEDURE get_work_order_count (
1544: p_api_version IN NUMBER
1545: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1546: ,p_commit IN VARCHAR2 := fnd_api.g_false
1547: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1548: ,p_organization_id IN VARCHAR2
1549: ,p_employee_id IN VARCHAR2
1550: ,p_instance_id IN NUMBER

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

1543: PROCEDURE get_work_order_count (
1544: p_api_version IN NUMBER
1545: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1546: ,p_commit IN VARCHAR2 := fnd_api.g_false
1547: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1548: ,p_organization_id IN VARCHAR2
1549: ,p_employee_id IN VARCHAR2
1550: ,p_instance_id IN NUMBER
1551: ,p_asset_group_id IN NUMBER

Line 1593: IF NOT fnd_api.compatible_api_call(

1589: SAVEPOINT get_work_order_count_pvt;
1590:
1591: l_stmt_num := 20;
1592: -- Standard call to check for call compatibility.
1593: IF NOT fnd_api.compatible_api_call(
1594: l_api_version
1595: ,p_api_version
1596: ,l_api_name
1597: ,g_pkg_name) THEN

Line 1598: RAISE fnd_api.g_exc_unexpected_error;

1594: l_api_version
1595: ,p_api_version
1596: ,l_api_name
1597: ,g_pkg_name) THEN
1598: RAISE fnd_api.g_exc_unexpected_error;
1599: END IF;
1600:
1601: l_stmt_num := 30;
1602: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1603: IF fnd_api.to_boolean(p_init_msg_list) THEN

1599: END IF;
1600:
1601: l_stmt_num := 30;
1602: -- Initialize message list if p_init_msg_list is set to TRUE.
1603: IF fnd_api.to_boolean(p_init_msg_list) THEN
1604: fnd_msg_pub.initialize;
1605: END IF;
1606:
1607: l_stmt_num := 40;

Line 1609: x_return_status := fnd_api.g_ret_sts_success;

1605: END IF;
1606:
1607: l_stmt_num := 40;
1608: -- Initialize API return status to success
1609: x_return_status := fnd_api.g_ret_sts_success;
1610:
1611: l_stmt_num := 50;
1612:
1613: -- API body

Line 2033: IF fnd_api.to_boolean(p_commit) THEN

2029:
2030: l_stmt_num := 998;
2031: -- End of API body.
2032: -- Standard check of p_commit.
2033: IF fnd_api.to_boolean(p_commit) THEN
2034: COMMIT WORK;
2035: END IF;
2036:
2037: l_stmt_num := 999;

Line 2040: p_encoded => fnd_api.g_false

2036:
2037: l_stmt_num := 999;
2038: -- Standard call to get message count and if count is 1, get message info.
2039: fnd_msg_pub.count_and_get(
2040: p_encoded => fnd_api.g_false
2041: ,p_count => x_msg_count
2042: ,p_data => x_msg_data);
2043:
2044: EXCEPTION

Line 2045: WHEN fnd_api.g_exc_error THEN

2041: ,p_count => x_msg_count
2042: ,p_data => x_msg_data);
2043:
2044: EXCEPTION
2045: WHEN fnd_api.g_exc_error THEN
2046: ROLLBACK TO get_work_order_count_pvt;
2047: x_return_status := fnd_api.g_ret_sts_error;
2048: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2049: fnd_msg_pub.count_and_get(

Line 2047: x_return_status := fnd_api.g_ret_sts_error;

2043:
2044: EXCEPTION
2045: WHEN fnd_api.g_exc_error THEN
2046: ROLLBACK TO get_work_order_count_pvt;
2047: x_return_status := fnd_api.g_ret_sts_error;
2048: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2049: fnd_msg_pub.count_and_get(
2050: p_encoded => fnd_api.g_false
2051: ,p_count => x_msg_count

Line 2050: p_encoded => fnd_api.g_false

2046: ROLLBACK TO get_work_order_count_pvt;
2047: x_return_status := fnd_api.g_ret_sts_error;
2048: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2049: fnd_msg_pub.count_and_get(
2050: p_encoded => fnd_api.g_false
2051: ,p_count => x_msg_count
2052: ,p_data => x_msg_data);
2053: WHEN fnd_api.g_exc_unexpected_error THEN
2054: ROLLBACK TO get_work_order_count_pvt;

Line 2053: WHEN fnd_api.g_exc_unexpected_error THEN

2049: fnd_msg_pub.count_and_get(
2050: p_encoded => fnd_api.g_false
2051: ,p_count => x_msg_count
2052: ,p_data => x_msg_data);
2053: WHEN fnd_api.g_exc_unexpected_error THEN
2054: ROLLBACK TO get_work_order_count_pvt;
2055: x_return_status := fnd_api.g_ret_sts_unexp_error;
2056: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2057: fnd_msg_pub.count_and_get(

Line 2055: x_return_status := fnd_api.g_ret_sts_unexp_error;

2051: ,p_count => x_msg_count
2052: ,p_data => x_msg_data);
2053: WHEN fnd_api.g_exc_unexpected_error THEN
2054: ROLLBACK TO get_work_order_count_pvt;
2055: x_return_status := fnd_api.g_ret_sts_unexp_error;
2056: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2057: fnd_msg_pub.count_and_get(
2058: p_encoded => fnd_api.g_false
2059: ,p_count => x_msg_count

Line 2058: p_encoded => fnd_api.g_false

2054: ROLLBACK TO get_work_order_count_pvt;
2055: x_return_status := fnd_api.g_ret_sts_unexp_error;
2056: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2057: fnd_msg_pub.count_and_get(
2058: p_encoded => fnd_api.g_false
2059: ,p_count => x_msg_count
2060: ,p_data => x_msg_data);
2061: WHEN OTHERS THEN
2062: ROLLBACK TO get_work_order_count_pvt;

Line 2063: x_return_status := fnd_api.g_ret_sts_unexp_error;

2059: ,p_count => x_msg_count
2060: ,p_data => x_msg_data);
2061: WHEN OTHERS THEN
2062: ROLLBACK TO get_work_order_count_pvt;
2063: x_return_status := fnd_api.g_ret_sts_unexp_error;
2064: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2065: IF fnd_msg_pub.check_msg_level(
2066: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2067: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 2071: p_encoded => fnd_api.g_false

2067: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2068: END IF;
2069:
2070: fnd_msg_pub.count_and_get(
2071: p_encoded => fnd_api.g_false
2072: ,p_count => x_msg_count
2073: ,p_data => x_msg_data);
2074:
2075:

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

2077:
2078:
2079: PROCEDURE insert_into_wori (
2080: p_api_version IN NUMBER
2081: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2082: ,p_commit IN VARCHAR2 := fnd_api.g_false
2083: ,p_organization_id IN VARCHAR2
2084: ,p_employee_id IN VARCHAR2
2085: ,p_wip_entity_id IN VARCHAR2

Line 2082: ,p_commit IN VARCHAR2 := fnd_api.g_false

2078:
2079: PROCEDURE insert_into_wori (
2080: p_api_version IN NUMBER
2081: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2082: ,p_commit IN VARCHAR2 := fnd_api.g_false
2083: ,p_organization_id IN VARCHAR2
2084: ,p_employee_id IN VARCHAR2
2085: ,p_wip_entity_id IN VARCHAR2
2086: ,p_operation_seq_num IN VARCHAR2

Line 2161: IF NOT fnd_api.compatible_api_call(

2157: SAVEPOINT insert_into_wori_pvt;
2158:
2159: l_stmt_num := 20;
2160: -- Standard call to check for call compatibility.
2161: IF NOT fnd_api.compatible_api_call(
2162: l_api_version
2163: ,p_api_version
2164: ,l_api_name
2165: ,g_pkg_name) THEN

Line 2166: RAISE fnd_api.g_exc_unexpected_error;

2162: l_api_version
2163: ,p_api_version
2164: ,l_api_name
2165: ,g_pkg_name) THEN
2166: RAISE fnd_api.g_exc_unexpected_error;
2167: END IF;
2168:
2169: l_stmt_num := 30;
2170: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2171: IF fnd_api.to_boolean(p_init_msg_list) THEN

2167: END IF;
2168:
2169: l_stmt_num := 30;
2170: -- Initialize message list if p_init_msg_list is set to TRUE.
2171: IF fnd_api.to_boolean(p_init_msg_list) THEN
2172: fnd_msg_pub.initialize;
2173: END IF;
2174:
2175: l_stmt_num := 40;

Line 2177: x_return_status := fnd_api.g_ret_sts_success;

2173: END IF;
2174:
2175: l_stmt_num := 40;
2176: -- Initialize API return status to success
2177: x_return_status := fnd_api.g_ret_sts_success;
2178:
2179: l_stmt_num := 50;
2180:
2181: -- API body

Line 2271: IF fnd_api.to_boolean(p_commit) THEN

2267:
2268:
2269: -- End of API body.
2270: -- Standard check of p_commit.
2271: IF fnd_api.to_boolean(p_commit) THEN
2272: COMMIT WORK;
2273: END IF;
2274:
2275: l_stmt_num := 999;

Line 2278: p_encoded => fnd_api.g_false

2274:
2275: l_stmt_num := 999;
2276: -- Standard call to get message count and if count is 1, get message info.
2277: fnd_msg_pub.count_and_get(
2278: p_encoded => fnd_api.g_false
2279: ,p_count => x_msg_count
2280: ,p_data => x_msg_data);
2281:
2282: EXCEPTION

Line 2283: WHEN fnd_api.g_exc_error THEN

2279: ,p_count => x_msg_count
2280: ,p_data => x_msg_data);
2281:
2282: EXCEPTION
2283: WHEN fnd_api.g_exc_error THEN
2284: ROLLBACK TO insert_into_wori_pvt;
2285: x_return_status := fnd_api.g_ret_sts_error;
2286: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2287: fnd_msg_pub.count_and_get(

Line 2285: x_return_status := fnd_api.g_ret_sts_error;

2281:
2282: EXCEPTION
2283: WHEN fnd_api.g_exc_error THEN
2284: ROLLBACK TO insert_into_wori_pvt;
2285: x_return_status := fnd_api.g_ret_sts_error;
2286: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2287: fnd_msg_pub.count_and_get(
2288: p_encoded => fnd_api.g_false
2289: ,p_count => x_msg_count

Line 2288: p_encoded => fnd_api.g_false

2284: ROLLBACK TO insert_into_wori_pvt;
2285: x_return_status := fnd_api.g_ret_sts_error;
2286: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2287: fnd_msg_pub.count_and_get(
2288: p_encoded => fnd_api.g_false
2289: ,p_count => x_msg_count
2290: ,p_data => x_msg_data);
2291: WHEN fnd_api.g_exc_unexpected_error THEN
2292: ROLLBACK TO insert_into_wori_pvt;

Line 2291: WHEN fnd_api.g_exc_unexpected_error THEN

2287: fnd_msg_pub.count_and_get(
2288: p_encoded => fnd_api.g_false
2289: ,p_count => x_msg_count
2290: ,p_data => x_msg_data);
2291: WHEN fnd_api.g_exc_unexpected_error THEN
2292: ROLLBACK TO insert_into_wori_pvt;
2293: x_return_status := fnd_api.g_ret_sts_unexp_error;
2294: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2295: fnd_msg_pub.count_and_get(

Line 2293: x_return_status := fnd_api.g_ret_sts_unexp_error;

2289: ,p_count => x_msg_count
2290: ,p_data => x_msg_data);
2291: WHEN fnd_api.g_exc_unexpected_error THEN
2292: ROLLBACK TO insert_into_wori_pvt;
2293: x_return_status := fnd_api.g_ret_sts_unexp_error;
2294: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2295: fnd_msg_pub.count_and_get(
2296: p_encoded => fnd_api.g_false
2297: ,p_count => x_msg_count

Line 2296: p_encoded => fnd_api.g_false

2292: ROLLBACK TO insert_into_wori_pvt;
2293: x_return_status := fnd_api.g_ret_sts_unexp_error;
2294: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2295: fnd_msg_pub.count_and_get(
2296: p_encoded => fnd_api.g_false
2297: ,p_count => x_msg_count
2298: ,p_data => x_msg_data);
2299: WHEN OTHERS THEN
2300: ROLLBACK TO insert_into_wori_pvt;

Line 2301: x_return_status := fnd_api.g_ret_sts_unexp_error;

2297: ,p_count => x_msg_count
2298: ,p_data => x_msg_data);
2299: WHEN OTHERS THEN
2300: ROLLBACK TO insert_into_wori_pvt;
2301: x_return_status := fnd_api.g_ret_sts_unexp_error;
2302: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
2303: IF fnd_msg_pub.check_msg_level(
2304: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2305: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 2309: p_encoded => fnd_api.g_false

2305: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2306: END IF;
2307:
2308: fnd_msg_pub.count_and_get(
2309: p_encoded => fnd_api.g_false
2310: ,p_count => x_msg_count
2311: ,p_data => x_msg_data);
2312:
2313:

Line 2374: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

2370: --This procedure validates and deactivates the asset
2371:
2372: PROCEDURE deactivate_assets(
2373: P_API_VERSION IN NUMBER,
2374: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2375: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
2376: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2377: P_INVENTORY_ITEM_ID IN NUMBER,
2378: P_SERIAL_NUMBER IN VARCHAR2,

Line 2375: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

2371:
2372: PROCEDURE deactivate_assets(
2373: P_API_VERSION IN NUMBER,
2374: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2375: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
2376: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2377: P_INVENTORY_ITEM_ID IN NUMBER,
2378: P_SERIAL_NUMBER IN VARCHAR2,
2379: P_ORGANIZATION_ID IN NUMBER,

Line 2376: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2372: PROCEDURE deactivate_assets(
2373: P_API_VERSION IN NUMBER,
2374: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
2375: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
2376: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2377: P_INVENTORY_ITEM_ID IN NUMBER,
2378: P_SERIAL_NUMBER IN VARCHAR2,
2379: P_ORGANIZATION_ID IN NUMBER,
2380: P_GEN_OBJECT_ID IN NUMBER,

Line 2407: IF NOT fnd_api.compatible_api_call(

2403: SAVEPOINT asset_util_pvt;
2404:
2405: l_stmt_num := 20;
2406: -- Standard call to check for call compatibility.
2407: IF NOT fnd_api.compatible_api_call(
2408: l_api_version
2409: ,p_api_version
2410: ,l_api_name
2411: ,g_pkg_name) THEN

Line 2412: RAISE fnd_api.g_exc_unexpected_error;

2408: l_api_version
2409: ,p_api_version
2410: ,l_api_name
2411: ,g_pkg_name) THEN
2412: RAISE fnd_api.g_exc_unexpected_error;
2413: END IF;
2414:
2415: l_stmt_num := 30;
2416: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2417: IF fnd_api.to_boolean(p_init_msg_list) THEN

2413: END IF;
2414:
2415: l_stmt_num := 30;
2416: -- Initialize message list if p_init_msg_list is set to TRUE.
2417: IF fnd_api.to_boolean(p_init_msg_list) THEN
2418: fnd_msg_pub.initialize;
2419: END IF;
2420:
2421: l_stmt_num := 40;

Line 2423: x_return_status := fnd_api.g_ret_sts_success;

2419: END IF;
2420:
2421: l_stmt_num := 40;
2422: -- Initialize API return status to success
2423: x_return_status := fnd_api.g_ret_sts_success;
2424:
2425: if P_INSTANCE_ID is null then
2426: l_organization_id := p_organization_id;
2427: select instance_id into l_instance_id

Line 2479: RAISE fnd_api.g_exc_error;

2475:
2476: if (l_hr_exists = 'Y') then
2477: fnd_message.set_name('EAM','EAM_HIERARCHY_EXISTS');
2478: fnd_msg_pub.add;
2479: RAISE fnd_api.g_exc_error;
2480: end if;
2481:
2482: -- ROUTES CHECK
2483:

Line 2504: RAISE fnd_api.g_exc_error;

2500:
2501: if (nvl(l_routes_exists,'N') = 'Y') then
2502: fnd_message.set_name('EAM','EAM_ROUTE_EXISTS');
2503: fnd_msg_pub.add;
2504: RAISE fnd_api.g_exc_error;
2505: end if;
2506:
2507: -- WORK REQUEST AND WORK ORDER CHECK
2508: begin

Line 2534: RAISE fnd_api.g_exc_error;

2530:
2531: if (nvl(l_wo_exists,'N') = 'Y') then
2532: fnd_message.set_name('EAM','EAM_WO_EXISTS');
2533: fnd_msg_pub.add;
2534: RAISE fnd_api.g_exc_error;
2535: end if;
2536:
2537: -- check open Service Reqests
2538: begin

Line 2559: RAISE fnd_api.g_exc_error;

2555:
2556: if (nvl(l_sr_exists,'N') = 'Y') then
2557: fnd_message.set_name('EAM','EAM_SR_EXISTS');
2558: fnd_msg_pub.add;
2559: RAISE fnd_api.g_exc_error;
2560: end if;
2561: eam_asset_number_pvt.update_asset(
2562: P_API_VERSION => 1.0
2563: ,p_commit => p_commit

Line 2575: WHEN fnd_api.g_exc_error THEN

2571: ,X_MSG_DATA => x_msg_data
2572: );
2573:
2574: EXCEPTION
2575: WHEN fnd_api.g_exc_error THEN
2576: ROLLBACK TO asset_util_pvt;
2577: x_return_status := fnd_api.g_ret_sts_error;
2578: fnd_msg_pub.count_and_get(
2579: p_encoded => fnd_api.g_false

Line 2577: x_return_status := fnd_api.g_ret_sts_error;

2573:
2574: EXCEPTION
2575: WHEN fnd_api.g_exc_error THEN
2576: ROLLBACK TO asset_util_pvt;
2577: x_return_status := fnd_api.g_ret_sts_error;
2578: fnd_msg_pub.count_and_get(
2579: p_encoded => fnd_api.g_false
2580: ,p_count => x_msg_count
2581: ,p_data => x_msg_data);

Line 2579: p_encoded => fnd_api.g_false

2575: WHEN fnd_api.g_exc_error THEN
2576: ROLLBACK TO asset_util_pvt;
2577: x_return_status := fnd_api.g_ret_sts_error;
2578: fnd_msg_pub.count_and_get(
2579: p_encoded => fnd_api.g_false
2580: ,p_count => x_msg_count
2581: ,p_data => x_msg_data);
2582: WHEN fnd_api.g_exc_unexpected_error THEN
2583: ROLLBACK TO asset_util_pvt;

Line 2582: WHEN fnd_api.g_exc_unexpected_error THEN

2578: fnd_msg_pub.count_and_get(
2579: p_encoded => fnd_api.g_false
2580: ,p_count => x_msg_count
2581: ,p_data => x_msg_data);
2582: WHEN fnd_api.g_exc_unexpected_error THEN
2583: ROLLBACK TO asset_util_pvt;
2584: x_return_status := fnd_api.g_ret_sts_unexp_error;
2585: fnd_msg_pub.count_and_get(
2586: p_encoded => fnd_api.g_false

Line 2584: x_return_status := fnd_api.g_ret_sts_unexp_error;

2580: ,p_count => x_msg_count
2581: ,p_data => x_msg_data);
2582: WHEN fnd_api.g_exc_unexpected_error THEN
2583: ROLLBACK TO asset_util_pvt;
2584: x_return_status := fnd_api.g_ret_sts_unexp_error;
2585: fnd_msg_pub.count_and_get(
2586: p_encoded => fnd_api.g_false
2587: ,p_count => x_msg_count
2588: ,p_data => x_msg_data);

Line 2586: p_encoded => fnd_api.g_false

2582: WHEN fnd_api.g_exc_unexpected_error THEN
2583: ROLLBACK TO asset_util_pvt;
2584: x_return_status := fnd_api.g_ret_sts_unexp_error;
2585: fnd_msg_pub.count_and_get(
2586: p_encoded => fnd_api.g_false
2587: ,p_count => x_msg_count
2588: ,p_data => x_msg_data);
2589:
2590: WHEN OTHERS THEN

Line 2592: x_return_status := fnd_api.g_ret_sts_unexp_error;

2588: ,p_data => x_msg_data);
2589:
2590: WHEN OTHERS THEN
2591: ROLLBACK TO asset_util_pvt;
2592: x_return_status := fnd_api.g_ret_sts_unexp_error;
2593:
2594: IF fnd_msg_pub.check_msg_level(
2595: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2596: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

Line 2600: p_encoded => fnd_api.g_false

2596: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
2597: END IF;
2598:
2599: fnd_msg_pub.count_and_get(
2600: p_encoded => fnd_api.g_false
2601: ,p_count => x_msg_count
2602: ,p_data => x_msg_data);
2603:
2604: end deactivate_assets;

Line 2642: l_msg_data_1 := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_FALSE); --set encoded to true

2638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,
2639: 'Message Count (from message Stack)= ' || l_msg_count_1);
2640: end if;
2641: end if;
2642: l_msg_data_1 := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_FALSE); --set encoded to true
2643: if (l_msg_count_1 is not null and l_msg_count_1 > 0) then
2644: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,
2646: 'Message #1 (from message stack) =' || l_msg_data_1);

Line 2649: l_msg_data_1 := fnd_msg_pub.get(fnd_msg_pub.G_NEXT, FND_API.G_FALSE); --set encoded to true

2645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,
2646: 'Message #1 (from message stack) =' || l_msg_data_1);
2647: end if;
2648: for i in 2..l_msg_count_1 LOOP
2649: l_msg_data_1 := fnd_msg_pub.get(fnd_msg_pub.G_NEXT, FND_API.G_FALSE); --set encoded to true
2650: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, p_module,
2652: 'Message #' || to_char(i) || ' (from message stack) =' || l_msg_data_1);
2653: end if;

Line 2720: , p_init_msg_lst => FND_API.G_TRUE

2716: END LOOP;
2717:
2718: INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES
2719: ( p_api_version_number => 1.0
2720: , p_init_msg_lst => FND_API.G_TRUE
2721: , x_return_status => l_return_status
2722: , x_msg_count => l_msg_count
2723: , x_msg_data => l_msg_data
2724: , p_organization_id => p_org_id

Line 2816: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

2812: ----------------------------------------------------------------------------
2813:
2814: PROCEDURE CREATE_ASSET(
2815: P_API_VERSION IN NUMBER
2816: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
2817: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
2818: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2819: ,X_EAM_WO_REC IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
2820: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 2817: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE

2813:
2814: PROCEDURE CREATE_ASSET(
2815: P_API_VERSION IN NUMBER
2816: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
2817: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
2818: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2819: ,X_EAM_WO_REC IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
2820: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
2821: ,X_MSG_COUNT OUT NOCOPY NUMBER

Line 2818: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2814: PROCEDURE CREATE_ASSET(
2815: P_API_VERSION IN NUMBER
2816: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
2817: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
2818: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2819: ,X_EAM_WO_REC IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
2820: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
2821: ,X_MSG_COUNT OUT NOCOPY NUMBER
2822: ,X_MSG_DATA OUT NOCOPY VARCHAR2

Line 2843: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

2839: -- Standard Start of API savepoint
2840: SAVEPOINT create_asset;
2841:
2842: -- Standard call to check for call compatibility.
2843: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2844: RAISE fnd_api.g_exc_unexpected_error;
2845: END IF;
2846:
2847: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2844: RAISE fnd_api.g_exc_unexpected_error;

2840: SAVEPOINT create_asset;
2841:
2842: -- Standard call to check for call compatibility.
2843: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2844: RAISE fnd_api.g_exc_unexpected_error;
2845: END IF;
2846:
2847: -- Initialize message list if p_init_msg_list is set to TRUE.
2848: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2848: IF fnd_api.to_boolean(p_init_msg_list) THEN

2844: RAISE fnd_api.g_exc_unexpected_error;
2845: END IF;
2846:
2847: -- Initialize message list if p_init_msg_list is set to TRUE.
2848: IF fnd_api.to_boolean(p_init_msg_list) THEN
2849: fnd_msg_pub.initialize;
2850: END IF;
2851:
2852: -- Initialize API return status to success

Line 2854: x_return_status := fnd_api.g_ret_sts_success;

2850: END IF;
2851:
2852: -- Initialize API return status to success
2853: l_stmt_num := 10;
2854: x_return_status := fnd_api.g_ret_sts_success;
2855:
2856: l_eam_wo_rec := x_eam_wo_rec;
2857:
2858:

Line 2880: RAISE fnd_api.g_exc_unexpected_error;

2876: ( 'EAM_COMMON_UTILITIES_PVT'
2877: , '.Create_Asset : Statement -'||to_char(l_stmt_num)
2878: );
2879: END IF;
2880: RAISE fnd_api.g_exc_unexpected_error;
2881:
2882: END;
2883:
2884: --This is a predefined rebuild on which a work order is being defined -

Line 2911: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then

2907: ,X_MSG_COUNT => l_x_asset_msg_count
2908: ,X_MSG_DATA => l_x_asset_msg_data
2909: );
2910:
2911: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
2912: l_stmt_num := 40;
2913: RAISE FND_API.G_EXC_ERROR ;
2914: end if;
2915:

Line 2913: RAISE FND_API.G_EXC_ERROR ;

2909: );
2910:
2911: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
2912: l_stmt_num := 40;
2913: RAISE FND_API.G_EXC_ERROR ;
2914: end if;
2915:
2916: else
2917:

Line 2939: RAISE fnd_api.g_exc_unexpected_error;

2935: ( 'EAM_COMMON_UTILITIES_PVT'
2936: , '.Create_Asset : Statement -'||to_char(l_stmt_num)
2937: );
2938: END IF;
2939: RAISE fnd_api.g_exc_unexpected_error;
2940:
2941: END;
2942: end if;
2943:

Line 2956: IF fnd_api.to_boolean(p_commit) THEN

2952: x_eam_wo_rec := l_eam_wo_rec;
2953:
2954: -- End of API body.
2955: -- Standard check of p_commit.
2956: IF fnd_api.to_boolean(p_commit) THEN
2957: COMMIT WORK;
2958: END IF;
2959:
2960: -- Standard call to get message count and if count is 1, get message info.

Line 2967: WHEN fnd_api.g_exc_error THEN

2963: ,p_data => x_msg_data);
2964:
2965:
2966: EXCEPTION
2967: WHEN fnd_api.g_exc_error THEN
2968: ROLLBACK TO create_asset;
2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get(
2971: p_count => x_msg_count

Line 2969: x_return_status := fnd_api.g_ret_sts_error;

2965:
2966: EXCEPTION
2967: WHEN fnd_api.g_exc_error THEN
2968: ROLLBACK TO create_asset;
2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get(
2971: p_count => x_msg_count
2972: ,p_data => x_msg_data);
2973: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2973: WHEN fnd_api.g_exc_unexpected_error THEN

2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get(
2971: p_count => x_msg_count
2972: ,p_data => x_msg_data);
2973: WHEN fnd_api.g_exc_unexpected_error THEN
2974: ROLLBACK TO create_asset;
2975: x_return_status := fnd_api.g_ret_sts_unexp_error;
2976: fnd_msg_pub.count_and_get(
2977: p_count => x_msg_count

Line 2975: x_return_status := fnd_api.g_ret_sts_unexp_error;

2971: p_count => x_msg_count
2972: ,p_data => x_msg_data);
2973: WHEN fnd_api.g_exc_unexpected_error THEN
2974: ROLLBACK TO create_asset;
2975: x_return_status := fnd_api.g_ret_sts_unexp_error;
2976: fnd_msg_pub.count_and_get(
2977: p_count => x_msg_count
2978: ,p_data => x_msg_data);
2979: WHEN OTHERS THEN

Line 2981: x_return_status := fnd_api.g_ret_sts_unexp_error;

2977: p_count => x_msg_count
2978: ,p_data => x_msg_data);
2979: WHEN OTHERS THEN
2980: ROLLBACK TO create_asset;
2981: x_return_status := fnd_api.g_ret_sts_unexp_error;
2982:
2983: IF fnd_msg_pub.check_msg_level(
2984: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2985: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

Line 3196: x_return_status := fnd_api.g_ret_sts_success;

3192: SAVEPOINT write_woru;
3193:
3194: -- Initialize API return status to success
3195: l_stmt_num := 10;
3196: x_return_status := fnd_api.g_ret_sts_success;
3197:
3198: -- API body
3199:
3200: l_stmt_num := 20;

Line 3277: WHEN fnd_api.g_exc_error THEN

3273:
3274:
3275: EXCEPTION
3276:
3277: WHEN fnd_api.g_exc_error THEN
3278: ROLLBACK TO adjust_woru;
3279: x_return_status := fnd_api.g_ret_sts_error;
3280:
3281: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3279: x_return_status := fnd_api.g_ret_sts_error;

3275: EXCEPTION
3276:
3277: WHEN fnd_api.g_exc_error THEN
3278: ROLLBACK TO adjust_woru;
3279: x_return_status := fnd_api.g_ret_sts_error;
3280:
3281: WHEN fnd_api.g_exc_unexpected_error THEN
3282: ROLLBACK TO adjust_woru;
3283: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3281: WHEN fnd_api.g_exc_unexpected_error THEN

3277: WHEN fnd_api.g_exc_error THEN
3278: ROLLBACK TO adjust_woru;
3279: x_return_status := fnd_api.g_ret_sts_error;
3280:
3281: WHEN fnd_api.g_exc_unexpected_error THEN
3282: ROLLBACK TO adjust_woru;
3283: x_return_status := fnd_api.g_ret_sts_unexp_error;
3284:
3285: WHEN OTHERS THEN

Line 3283: x_return_status := fnd_api.g_ret_sts_unexp_error;

3279: x_return_status := fnd_api.g_ret_sts_error;
3280:
3281: WHEN fnd_api.g_exc_unexpected_error THEN
3282: ROLLBACK TO adjust_woru;
3283: x_return_status := fnd_api.g_ret_sts_unexp_error;
3284:
3285: WHEN OTHERS THEN
3286: ROLLBACK TO adjust_woru;
3287: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3287: x_return_status := fnd_api.g_ret_sts_unexp_error;

3283: x_return_status := fnd_api.g_ret_sts_unexp_error;
3284:
3285: WHEN OTHERS THEN
3286: ROLLBACK TO adjust_woru;
3287: x_return_status := fnd_api.g_ret_sts_unexp_error;
3288:
3289:
3290:
3291:

Line 3298: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

3294:
3295:
3296: PROCEDURE Adjust_WORU (
3297: P_API_VERSION IN NUMBER
3298: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
3299: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
3300: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3301: ,P_WIP_ENTITY_ID IN NUMBER
3302: ,P_ORGANIZATION_ID IN NUMBER

Line 3299: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE

3295:
3296: PROCEDURE Adjust_WORU (
3297: P_API_VERSION IN NUMBER
3298: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
3299: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
3300: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3301: ,P_WIP_ENTITY_ID IN NUMBER
3302: ,P_ORGANIZATION_ID IN NUMBER
3303: ,P_OPERATION_SEQ_NUM IN NUMBER

Line 3300: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL

3296: PROCEDURE Adjust_WORU (
3297: P_API_VERSION IN NUMBER
3298: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
3299: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
3300: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3301: ,P_WIP_ENTITY_ID IN NUMBER
3302: ,P_ORGANIZATION_ID IN NUMBER
3303: ,P_OPERATION_SEQ_NUM IN NUMBER
3304: ,P_RESOURCE_SEQ_NUM IN NUMBER

Line 3348: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

3344: -- Standard Start of API savepoint
3345: SAVEPOINT adjust_woru;
3346:
3347: -- Standard call to check for call compatibility.
3348: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3349: RAISE fnd_api.g_exc_unexpected_error;
3350: END IF;
3351:
3352: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3349: RAISE fnd_api.g_exc_unexpected_error;

3345: SAVEPOINT adjust_woru;
3346:
3347: -- Standard call to check for call compatibility.
3348: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3349: RAISE fnd_api.g_exc_unexpected_error;
3350: END IF;
3351:
3352: -- Initialize message list if p_init_msg_list is set to TRUE.
3353: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3353: IF fnd_api.to_boolean(p_init_msg_list) THEN

3349: RAISE fnd_api.g_exc_unexpected_error;
3350: END IF;
3351:
3352: -- Initialize message list if p_init_msg_list is set to TRUE.
3353: IF fnd_api.to_boolean(p_init_msg_list) THEN
3354: fnd_msg_pub.initialize;
3355: END IF;
3356:
3357: -- Initialize API return status to success

Line 3359: x_return_status := fnd_api.g_ret_sts_success;

3355: END IF;
3356:
3357: -- Initialize API return status to success
3358: l_stmt_num := 10;
3359: x_return_status := fnd_api.g_ret_sts_success;
3360:
3361: -- API body
3362: -- Figure out if it is a move or resize
3363:

Line 3379: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3375: X_RETURN_STATUS => l_return_status,
3376: X_MSG_COUNT => l_msg_count,
3377: X_MSG_DATA => l_msg_data);
3378:
3379: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3380: RAISE FND_API.G_EXC_ERROR ;
3381: end if;
3382:
3383: else

Line 3380: RAISE FND_API.G_EXC_ERROR ;

3376: X_MSG_COUNT => l_msg_count,
3377: X_MSG_DATA => l_msg_data);
3378:
3379: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3380: RAISE FND_API.G_EXC_ERROR ;
3381: end if;
3382:
3383: else
3384: l_stmt_num := 30;

Line 3420: RAISE fnd_api.g_exc_unexpected_error;

3416: ( 'EAM_COMMON_UTILITIES_PVT'
3417: , '.Adjust_WORU : Statement -'||to_char(l_stmt_num)
3418: );
3419: END IF;
3420: RAISE fnd_api.g_exc_unexpected_error;
3421:
3422: END;
3423:
3424: l_stmt_num := 50;

Line 3541: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3537: X_RETURN_STATUS => l_return_status,
3538: X_MSG_COUNT => l_msg_count,
3539: X_MSG_DATA => l_msg_data);
3540:
3541: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3542: RAISE FND_API.G_EXC_ERROR ;
3543: end if;
3544:
3545: END LOOP;

Line 3542: RAISE FND_API.G_EXC_ERROR ;

3538: X_MSG_COUNT => l_msg_count,
3539: X_MSG_DATA => l_msg_data);
3540:
3541: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3542: RAISE FND_API.G_EXC_ERROR ;
3543: end if;
3544:
3545: END LOOP;
3546:

Line 3553: IF fnd_api.to_boolean(p_commit) THEN

3549:
3550:
3551: -- End of API body.
3552: -- Standard check of p_commit.
3553: IF fnd_api.to_boolean(p_commit) THEN
3554: COMMIT WORK;
3555: END IF;
3556:
3557: -- Standard call to get message count and if count is 1, get message info.

Line 3566: x_return_status := fnd_api.g_ret_sts_error;

3562:
3563: EXCEPTION
3564: WHEN SHRINK_WITH_ASSIGNMENTS THEN
3565: rollback to adjust_woru;
3566: x_return_status := fnd_api.g_ret_sts_error;
3567: fnd_msg_pub.count_and_get(
3568: p_count => x_msg_count
3569: ,p_data => x_msg_data);
3570:

Line 3571: WHEN fnd_api.g_exc_error THEN

3567: fnd_msg_pub.count_and_get(
3568: p_count => x_msg_count
3569: ,p_data => x_msg_data);
3570:
3571: WHEN fnd_api.g_exc_error THEN
3572: ROLLBACK TO adjust_woru;
3573: x_return_status := fnd_api.g_ret_sts_error;
3574: fnd_msg_pub.count_and_get(
3575: p_count => x_msg_count

Line 3573: x_return_status := fnd_api.g_ret_sts_error;

3569: ,p_data => x_msg_data);
3570:
3571: WHEN fnd_api.g_exc_error THEN
3572: ROLLBACK TO adjust_woru;
3573: x_return_status := fnd_api.g_ret_sts_error;
3574: fnd_msg_pub.count_and_get(
3575: p_count => x_msg_count
3576: ,p_data => x_msg_data);
3577: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3577: WHEN fnd_api.g_exc_unexpected_error THEN

3573: x_return_status := fnd_api.g_ret_sts_error;
3574: fnd_msg_pub.count_and_get(
3575: p_count => x_msg_count
3576: ,p_data => x_msg_data);
3577: WHEN fnd_api.g_exc_unexpected_error THEN
3578: ROLLBACK TO adjust_woru;
3579: x_return_status := fnd_api.g_ret_sts_unexp_error;
3580: fnd_msg_pub.count_and_get(
3581: p_count => x_msg_count

Line 3579: x_return_status := fnd_api.g_ret_sts_unexp_error;

3575: p_count => x_msg_count
3576: ,p_data => x_msg_data);
3577: WHEN fnd_api.g_exc_unexpected_error THEN
3578: ROLLBACK TO adjust_woru;
3579: x_return_status := fnd_api.g_ret_sts_unexp_error;
3580: fnd_msg_pub.count_and_get(
3581: p_count => x_msg_count
3582: ,p_data => x_msg_data);
3583: WHEN OTHERS THEN

Line 3585: x_return_status := fnd_api.g_ret_sts_unexp_error;

3581: p_count => x_msg_count
3582: ,p_data => x_msg_data);
3583: WHEN OTHERS THEN
3584: ROLLBACK TO adjust_woru;
3585: x_return_status := fnd_api.g_ret_sts_unexp_error;
3586:
3587: IF fnd_msg_pub.check_msg_level(
3588: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3589: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

Line 3729: x_return_status := fnd_api.g_ret_sts_success;

3725: l_return_value boolean;
3726:
3727: begin
3728: l_return_value := FALSE;
3729: x_return_status := fnd_api.g_ret_sts_success;
3730: l_equipment_gen_object_id := p_equipment_gen_object_id;
3731:
3732: if (p_pn_location_id is not null AND p_pn_location_id <> FND_API.G_MISS_NUM) then
3733: l_return_value := TRUE;

Line 3732: if (p_pn_location_id is not null AND p_pn_location_id <> FND_API.G_MISS_NUM) then

3728: l_return_value := FALSE;
3729: x_return_status := fnd_api.g_ret_sts_success;
3730: l_equipment_gen_object_id := p_equipment_gen_object_id;
3731:
3732: if (p_pn_location_id is not null AND p_pn_location_id <> FND_API.G_MISS_NUM) then
3733: l_return_value := TRUE;
3734: end if;
3735:
3736: if (p_network_asset_flag is not null AND p_network_asset_flag <> FND_API.G_MISS_CHAR AND p_network_asset_flag = 'Y' AND l_return_value <> TRUE) then

Line 3736: if (p_network_asset_flag is not null AND p_network_asset_flag <> FND_API.G_MISS_CHAR AND p_network_asset_flag = 'Y' AND l_return_value <> TRUE) then

3732: if (p_pn_location_id is not null AND p_pn_location_id <> FND_API.G_MISS_NUM) then
3733: l_return_value := TRUE;
3734: end if;
3735:
3736: if (p_network_asset_flag is not null AND p_network_asset_flag <> FND_API.G_MISS_CHAR AND p_network_asset_flag = 'Y' AND l_return_value <> TRUE) then
3737: l_return_value := TRUE;
3738: end if;
3739:
3740:

Line 3742: AND l_equipment_gen_object_id <> FND_API.G_MISS_NUM) then

3738: end if;
3739:
3740:
3741: if (l_return_value <> TRUE AND l_equipment_gen_object_id IS NOT NULL
3742: AND l_equipment_gen_object_id <> FND_API.G_MISS_NUM) then
3743: begin
3744: select msn.gen_object_id
3745: into l_gen_object_id
3746: from mtl_serial_numbers msn

Line 3756: x_return_status := fnd_api.g_ret_sts_unexp_error;

3752: l_return_value := TRUE;
3753: end if;
3754: exception
3755: when others then
3756: x_return_status := fnd_api.g_ret_sts_unexp_error;
3757: end;
3758: end if;
3759:
3760: if (l_return_value = TRUE) then

Line 3769: x_return_status := fnd_api.g_ret_sts_unexp_error;

3765: where serial_number = p_serial_number
3766: and inventory_item_id = p_inventory_item_id;
3767: exception
3768: when others then
3769: x_return_status := fnd_api.g_ret_sts_unexp_error;
3770: end;
3771: end if;
3772:
3773: begin

Line 3781: x_return_status := fnd_api.g_ret_sts_unexp_error;

3777: and inventory_item_id = p_inventory_item_id;
3778:
3779: exception
3780: when others then
3781: x_return_status := fnd_api.g_ret_sts_unexp_error;
3782: end;
3783:
3784:
3785: end update_logical_asset;