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

Line 10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 11: -- p_commit IN VARCHAR2 Optional 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 Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- parameter1
14: -- parameter2
15: -- .

Line 12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

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

97:
98: PROCEDURE insert_row
99: (
100: p_api_version IN NUMBER
101: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
102: ,p_commit IN VARCHAR2 := fnd_api.g_false
103: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
104: ,p_external_linear_id IN NUMBER
105: ,p_external_linear_name IN VARCHAR2

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

98: PROCEDURE insert_row
99: (
100: p_api_version IN NUMBER
101: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
102: ,p_commit IN VARCHAR2 := fnd_api.g_false
103: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
104: ,p_external_linear_id IN NUMBER
105: ,p_external_linear_name IN VARCHAR2
106: ,p_external_source_name IN VARCHAR2

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

99: (
100: p_api_version IN NUMBER
101: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
102: ,p_commit IN VARCHAR2 := fnd_api.g_false
103: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
104: ,p_external_linear_id IN NUMBER
105: ,p_external_linear_name IN VARCHAR2
106: ,p_external_source_name IN VARCHAR2
107: ,p_external_linear_type IN VARCHAR2

Line 124: IF NOT fnd_api.compatible_api_call(

120: -- Standard Start of API savepoint
121: SAVEPOINT eam_linear_locations_pub;
122:
123: -- Standard call to check for call compatibility.
124: IF NOT fnd_api.compatible_api_call(
125: l_api_version
126: ,p_api_version
127: ,l_api_name
128: ,g_pkg_name) THEN

Line 129: RAISE fnd_api.g_exc_unexpected_error;

125: l_api_version
126: ,p_api_version
127: ,l_api_name
128: ,g_pkg_name) THEN
129: RAISE fnd_api.g_exc_unexpected_error;
130: END IF;
131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.
133: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 133: IF fnd_api.to_boolean(p_init_msg_list) THEN

129: RAISE fnd_api.g_exc_unexpected_error;
130: END IF;
131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.
133: IF fnd_api.to_boolean(p_init_msg_list) THEN
134: fnd_msg_pub.initialize;
135: END IF;
136:
137: -- Initialize API return status to success

Line 138: x_return_status := fnd_api.g_ret_sts_success;

134: fnd_msg_pub.initialize;
135: END IF;
136:
137: -- Initialize API return status to success
138: x_return_status := fnd_api.g_ret_sts_success;
139:
140: -- API body
141:
142: -- Validation of external_source_name

Line 151: RAISE fnd_api.g_exc_error;

147: IF (l_count = 0) THEN
148: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
149: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);
150: fnd_msg_pub.add;
151: RAISE fnd_api.g_exc_error;
152: END IF;
153:
154: -- Validation of external_linear_id
155: IF (p_external_linear_id IS NULL) THEN

Line 159: RAISE fnd_api.g_exc_error;

155: IF (p_external_linear_id IS NULL) THEN
156: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
157: fnd_message.set_token('NAME', 'p_external_linear_id : ' || p_external_linear_id);
158: fnd_msg_pub.add;
159: RAISE fnd_api.g_exc_error;
160: END IF;
161:
162: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
163: (SELECT 1 FROM eam_linear_locations WHERE external_linear_id = p_external_linear_id

Line 170: RAISE fnd_api.g_exc_error;

166:
167: IF (l_count > 0) THEN
168: fnd_message.set_name('EAM', 'EAM_EXT_LINEAR_ID_EXISTS');
169: fnd_msg_pub.add;
170: RAISE fnd_api.g_exc_error;
171: END IF;
172:
173: -- insert into eam_linear_locations table
174: INSERT INTO eam_linear_locations

Line 193: IF fnd_api.to_boolean(p_commit) THEN

189:
190: -- End of API body.
191:
192: -- Standard check of p_commit.
193: IF fnd_api.to_boolean(p_commit) THEN
194: COMMIT WORK;
195: END IF;
196:
197: -- Standard call to get message count and if count is 1, get message info.

Line 201: WHEN fnd_api.g_exc_error THEN

197: -- Standard call to get message count and if count is 1, get message info.
198: fnd_msg_pub.count_and_get(p_count => x_msg_count
199: ,p_data => x_msg_data);
200: EXCEPTION
201: WHEN fnd_api.g_exc_error THEN
202: ROLLBACK TO eam_linear_locations_pub;
203: x_return_status := fnd_api.g_ret_sts_error;
204: fnd_msg_pub.count_and_get(p_count => x_msg_count
205: ,p_data => x_msg_data);

Line 203: x_return_status := fnd_api.g_ret_sts_error;

199: ,p_data => x_msg_data);
200: EXCEPTION
201: WHEN fnd_api.g_exc_error THEN
202: ROLLBACK TO eam_linear_locations_pub;
203: x_return_status := fnd_api.g_ret_sts_error;
204: fnd_msg_pub.count_and_get(p_count => x_msg_count
205: ,p_data => x_msg_data);
206: WHEN fnd_api.g_exc_unexpected_error THEN
207: ROLLBACK TO eam_linear_locations_pub;

Line 206: WHEN fnd_api.g_exc_unexpected_error THEN

202: ROLLBACK TO eam_linear_locations_pub;
203: x_return_status := fnd_api.g_ret_sts_error;
204: fnd_msg_pub.count_and_get(p_count => x_msg_count
205: ,p_data => x_msg_data);
206: WHEN fnd_api.g_exc_unexpected_error THEN
207: ROLLBACK TO eam_linear_locations_pub;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: fnd_msg_pub.count_and_get(p_count => x_msg_count
210: ,p_data => x_msg_data);

Line 208: x_return_status := fnd_api.g_ret_sts_unexp_error;

204: fnd_msg_pub.count_and_get(p_count => x_msg_count
205: ,p_data => x_msg_data);
206: WHEN fnd_api.g_exc_unexpected_error THEN
207: ROLLBACK TO eam_linear_locations_pub;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: fnd_msg_pub.count_and_get(p_count => x_msg_count
210: ,p_data => x_msg_data);
211: WHEN OTHERS THEN
212: ROLLBACK TO eam_linear_locations_pub;

Line 213: x_return_status := fnd_api.g_ret_sts_unexp_error;

209: fnd_msg_pub.count_and_get(p_count => x_msg_count
210: ,p_data => x_msg_data);
211: WHEN OTHERS THEN
212: ROLLBACK TO eam_linear_locations_pub;
213: x_return_status := fnd_api.g_ret_sts_unexp_error;
214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
215: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
216: END IF;
217: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

221:
222: PROCEDURE update_row
223: (
224: p_api_version IN NUMBER
225: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
226: ,p_commit IN VARCHAR2 := fnd_api.g_false
227: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
228: ,p_external_linear_id IN NUMBER
229: ,p_external_linear_name IN VARCHAR2

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

222: PROCEDURE update_row
223: (
224: p_api_version IN NUMBER
225: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
226: ,p_commit IN VARCHAR2 := fnd_api.g_false
227: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
228: ,p_external_linear_id IN NUMBER
229: ,p_external_linear_name IN VARCHAR2
230: ,p_external_source_name IN VARCHAR2

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

223: (
224: p_api_version IN NUMBER
225: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
226: ,p_commit IN VARCHAR2 := fnd_api.g_false
227: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
228: ,p_external_linear_id IN NUMBER
229: ,p_external_linear_name IN VARCHAR2
230: ,p_external_source_name IN VARCHAR2
231: ,p_external_linear_type IN VARCHAR2

Line 248: IF NOT fnd_api.compatible_api_call(

244: -- Standard Start of API savepoint
245: SAVEPOINT eam_linear_locations_pub;
246:
247: -- Standard call to check for call compatibility.
248: IF NOT fnd_api.compatible_api_call(
249: l_api_version
250: ,p_api_version
251: ,l_api_name
252: ,g_pkg_name) THEN

Line 253: RAISE fnd_api.g_exc_unexpected_error;

249: l_api_version
250: ,p_api_version
251: ,l_api_name
252: ,g_pkg_name) THEN
253: RAISE fnd_api.g_exc_unexpected_error;
254: END IF;
255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 257: IF fnd_api.to_boolean(p_init_msg_list) THEN

253: RAISE fnd_api.g_exc_unexpected_error;
254: END IF;
255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF fnd_api.to_boolean(p_init_msg_list) THEN
258: fnd_msg_pub.initialize;
259: END IF;
260:
261: -- Initialize API return status to success

Line 262: x_return_status := fnd_api.g_ret_sts_success;

258: fnd_msg_pub.initialize;
259: END IF;
260:
261: -- Initialize API return status to success
262: x_return_status := fnd_api.g_ret_sts_success;
263:
264: -- API body
265:
266: -- Validation of eam_linear_id

Line 274: RAISE fnd_api.g_exc_error;

270: IF (l_count = 0) THEN
271: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
272: fnd_message.set_token('NAME', 'p_eam_linear_id : ' || p_eam_linear_id);
273: fnd_msg_pub.add;
274: RAISE fnd_api.g_exc_error;
275: END IF;
276:
277: -- Validation of external_source_name
278: SELECT count(*) INTO l_count FROM dual WHERE EXISTS

Line 286: RAISE fnd_api.g_exc_error;

282: IF (l_count = 0) THEN
283: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
284: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);
285: fnd_msg_pub.add;
286: RAISE fnd_api.g_exc_error;
287: END IF;
288:
289: -- Validation of external_linear_id
290: IF (p_external_linear_id IS NULL) THEN

Line 294: RAISE fnd_api.g_exc_error;

290: IF (p_external_linear_id IS NULL) THEN
291: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
292: fnd_message.set_token('NAME', 'p_external_linear_id : ' || p_external_linear_id);
293: fnd_msg_pub.add;
294: RAISE fnd_api.g_exc_error;
295: END IF;
296:
297: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
298: (SELECT 1 FROM eam_linear_locations WHERE external_linear_id = p_external_linear_id

Line 306: RAISE fnd_api.g_exc_error;

302:
303: IF (l_count > 0) THEN
304: fnd_message.set_name('EAM', 'EAM_EXT_LINEAR_ID_EXISTS');
305: fnd_msg_pub.add;
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309: -- Update the record in eam_linear_locations table
310: UPDATE eam_linear_locations SET

Line 321: IF fnd_api.to_boolean(p_commit) THEN

317:
318: -- End of API body.
319:
320: -- Standard check of p_commit.
321: IF fnd_api.to_boolean(p_commit) THEN
322: COMMIT WORK;
323: END IF;
324:
325: -- Standard call to get message count and if count is 1, get message info.

Line 329: WHEN fnd_api.g_exc_error THEN

325: -- Standard call to get message count and if count is 1, get message info.
326: fnd_msg_pub.count_and_get(p_count => x_msg_count
327: ,p_data => x_msg_data);
328: EXCEPTION
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO eam_linear_locations_pub;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count
333: ,p_data => x_msg_data);

Line 331: x_return_status := fnd_api.g_ret_sts_error;

327: ,p_data => x_msg_data);
328: EXCEPTION
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO eam_linear_locations_pub;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count
333: ,p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN
335: ROLLBACK TO eam_linear_locations_pub;

Line 334: WHEN fnd_api.g_exc_unexpected_error THEN

330: ROLLBACK TO eam_linear_locations_pub;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count
333: ,p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN
335: ROLLBACK TO eam_linear_locations_pub;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get(p_count => x_msg_count
338: ,p_data => x_msg_data);

Line 336: x_return_status := fnd_api.g_ret_sts_unexp_error;

332: fnd_msg_pub.count_and_get(p_count => x_msg_count
333: ,p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN
335: ROLLBACK TO eam_linear_locations_pub;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get(p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN OTHERS THEN
340: ROLLBACK TO eam_linear_locations_pub;

Line 341: x_return_status := fnd_api.g_ret_sts_unexp_error;

337: fnd_msg_pub.count_and_get(p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN OTHERS THEN
340: ROLLBACK TO eam_linear_locations_pub;
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
343: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
344: END IF;
345: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

349:
350: PROCEDURE get_eam_linear_id
351: (
352: p_api_version IN NUMBER
353: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
354: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
355: ,p_external_linear_id IN NUMBER
356: ,p_external_source_name IN VARCHAR2
357: ,p_external_linear_type IN VARCHAR2

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

350: PROCEDURE get_eam_linear_id
351: (
352: p_api_version IN NUMBER
353: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
354: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
355: ,p_external_linear_id IN NUMBER
356: ,p_external_source_name IN VARCHAR2
357: ,p_external_linear_type IN VARCHAR2
358: ,x_eam_linear_id OUT NOCOPY NUMBER

Line 374: IF NOT fnd_api.compatible_api_call(

370: -- Standard Start of API savepoint
371: SAVEPOINT eam_linear_locations_pub;
372:
373: -- Standard call to check for call compatibility.
374: IF NOT fnd_api.compatible_api_call(
375: l_api_version
376: ,p_api_version
377: ,l_api_name
378: ,g_pkg_name) THEN

Line 379: RAISE fnd_api.g_exc_unexpected_error;

375: l_api_version
376: ,p_api_version
377: ,l_api_name
378: ,g_pkg_name) THEN
379: RAISE fnd_api.g_exc_unexpected_error;
380: END IF;
381:
382: -- Initialize message list if p_init_msg_list is set to TRUE.
383: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 383: IF fnd_api.to_boolean(p_init_msg_list) THEN

379: RAISE fnd_api.g_exc_unexpected_error;
380: END IF;
381:
382: -- Initialize message list if p_init_msg_list is set to TRUE.
383: IF fnd_api.to_boolean(p_init_msg_list) THEN
384: fnd_msg_pub.initialize;
385: END IF;
386:
387: -- Initialize API return status to success

Line 388: x_return_status := fnd_api.g_ret_sts_success;

384: fnd_msg_pub.initialize;
385: END IF;
386:
387: -- Initialize API return status to success
388: x_return_status := fnd_api.g_ret_sts_success;
389:
390: -- API body
391:
392: -- Validation of external_source_name

Line 401: RAISE fnd_api.g_exc_error;

397: IF (l_count = 0) THEN
398: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
399: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);
400: fnd_msg_pub.add;
401: RAISE fnd_api.g_exc_error;
402: END IF;
403:
404:
405: BEGIN

Line 415: --RAISE fnd_api.g_exc_error;

411: WHEN NO_DATA_FOUND THEN
412: x_eam_linear_id := -1;
413: --fnd_message.set_name('EAM', 'EAM_INVALID_EXT_LINEAR_ID');
414: --fnd_msg_pub.add;
415: --RAISE fnd_api.g_exc_error;
416: END;
417:
418: -- Standard call to get message count and if count is 1, get message info.
419: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 422: WHEN fnd_api.g_exc_error THEN

418: -- Standard call to get message count and if count is 1, get message info.
419: fnd_msg_pub.count_and_get(p_count => x_msg_count
420: ,p_data => x_msg_data);
421: EXCEPTION
422: WHEN fnd_api.g_exc_error THEN
423: ROLLBACK TO eam_linear_locations_pub;
424: x_return_status := fnd_api.g_ret_sts_error;
425: fnd_msg_pub.count_and_get(p_count => x_msg_count
426: ,p_data => x_msg_data);

Line 424: x_return_status := fnd_api.g_ret_sts_error;

420: ,p_data => x_msg_data);
421: EXCEPTION
422: WHEN fnd_api.g_exc_error THEN
423: ROLLBACK TO eam_linear_locations_pub;
424: x_return_status := fnd_api.g_ret_sts_error;
425: fnd_msg_pub.count_and_get(p_count => x_msg_count
426: ,p_data => x_msg_data);
427: WHEN fnd_api.g_exc_unexpected_error THEN
428: ROLLBACK TO eam_linear_locations_pub;

Line 427: WHEN fnd_api.g_exc_unexpected_error THEN

423: ROLLBACK TO eam_linear_locations_pub;
424: x_return_status := fnd_api.g_ret_sts_error;
425: fnd_msg_pub.count_and_get(p_count => x_msg_count
426: ,p_data => x_msg_data);
427: WHEN fnd_api.g_exc_unexpected_error THEN
428: ROLLBACK TO eam_linear_locations_pub;
429: x_return_status := fnd_api.g_ret_sts_unexp_error;
430: fnd_msg_pub.count_and_get(p_count => x_msg_count
431: ,p_data => x_msg_data);

Line 429: x_return_status := fnd_api.g_ret_sts_unexp_error;

425: fnd_msg_pub.count_and_get(p_count => x_msg_count
426: ,p_data => x_msg_data);
427: WHEN fnd_api.g_exc_unexpected_error THEN
428: ROLLBACK TO eam_linear_locations_pub;
429: x_return_status := fnd_api.g_ret_sts_unexp_error;
430: fnd_msg_pub.count_and_get(p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN OTHERS THEN
433: ROLLBACK TO eam_linear_locations_pub;

Line 434: x_return_status := fnd_api.g_ret_sts_unexp_error;

430: fnd_msg_pub.count_and_get(p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN OTHERS THEN
433: ROLLBACK TO eam_linear_locations_pub;
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
436: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
437: END IF;
438: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

440: END get_eam_linear_id;
441:
442: procedure create_asset(
443: p_api_version IN NUMBER
444: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
445: ,p_commit IN VARCHAR2 := fnd_api.g_false
446: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
447: ,p_external_linear_id IN NUMBER
448: ,p_external_linear_name IN VARCHAR2

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

441:
442: procedure create_asset(
443: p_api_version IN NUMBER
444: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
445: ,p_commit IN VARCHAR2 := fnd_api.g_false
446: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
447: ,p_external_linear_id IN NUMBER
448: ,p_external_linear_name IN VARCHAR2
449: ,p_external_source_name IN VARCHAR2

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

442: procedure create_asset(
443: p_api_version IN NUMBER
444: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
445: ,p_commit IN VARCHAR2 := fnd_api.g_false
446: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
447: ,p_external_linear_id IN NUMBER
448: ,p_external_linear_name IN VARCHAR2
449: ,p_external_source_name IN VARCHAR2
450: ,p_external_linear_type IN VARCHAR2

Line 494: RAISE fnd_api.g_exc_unexpected_error;

490: resp_id => l_resp_id,
491: resp_appl_id => l_resp_appl_id
492: );
493: else
494: RAISE fnd_api.g_exc_unexpected_error;
495: end if;
496:
497: -- Standard call to check for call compatibility.
498: IF NOT fnd_api.compatible_api_call(

Line 498: IF NOT fnd_api.compatible_api_call(

494: RAISE fnd_api.g_exc_unexpected_error;
495: end if;
496:
497: -- Standard call to check for call compatibility.
498: IF NOT fnd_api.compatible_api_call(
499: l_api_version
500: ,p_api_version
501: ,l_api_name
502: ,g_pkg_name) THEN

Line 503: RAISE fnd_api.g_exc_unexpected_error;

499: l_api_version
500: ,p_api_version
501: ,l_api_name
502: ,g_pkg_name) THEN
503: RAISE fnd_api.g_exc_unexpected_error;
504: END IF;
505:
506: -- Initialize message list if p_init_msg_list is set to TRUE.
507: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 507: IF fnd_api.to_boolean(p_init_msg_list) THEN

503: RAISE fnd_api.g_exc_unexpected_error;
504: END IF;
505:
506: -- Initialize message list if p_init_msg_list is set to TRUE.
507: IF fnd_api.to_boolean(p_init_msg_list) THEN
508: fnd_msg_pub.initialize;
509: END IF;
510:
511: -- Initialize API return status to success

Line 512: x_return_status := fnd_api.g_ret_sts_success;

508: fnd_msg_pub.initialize;
509: END IF;
510:
511: -- Initialize API return status to success
512: x_return_status := fnd_api.g_ret_sts_success;
513:
514: -- API body
515: --first check if asset already exists in EAM
516: eam_linear_locations_pub.get_eam_linear_id(

Line 576: IF FND_API.To_Boolean( p_commit ) THEN

572:
573:
574: -- End API body
575: -- Standard check of p_commit.
576: IF FND_API.To_Boolean( p_commit ) THEN
577: COMMIT WORK;
578: END IF;
579: -- Standard call to get message count and if count is 1, get message info.
580: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 583: WHEN fnd_api.g_exc_error THEN

579: -- Standard call to get message count and if count is 1, get message info.
580: fnd_msg_pub.count_and_get(p_count => x_msg_count
581: ,p_data => x_msg_data);
582: EXCEPTION
583: WHEN fnd_api.g_exc_error THEN
584: ROLLBACK TO eam_linear_locations_pub;
585: x_return_status := fnd_api.g_ret_sts_error;
586: fnd_msg_pub.count_and_get(p_count => x_msg_count
587: ,p_data => x_msg_data);

Line 585: x_return_status := fnd_api.g_ret_sts_error;

581: ,p_data => x_msg_data);
582: EXCEPTION
583: WHEN fnd_api.g_exc_error THEN
584: ROLLBACK TO eam_linear_locations_pub;
585: x_return_status := fnd_api.g_ret_sts_error;
586: fnd_msg_pub.count_and_get(p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN fnd_api.g_exc_unexpected_error THEN
589: ROLLBACK TO eam_linear_locations_pub;

Line 588: WHEN fnd_api.g_exc_unexpected_error THEN

584: ROLLBACK TO eam_linear_locations_pub;
585: x_return_status := fnd_api.g_ret_sts_error;
586: fnd_msg_pub.count_and_get(p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN fnd_api.g_exc_unexpected_error THEN
589: ROLLBACK TO eam_linear_locations_pub;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: fnd_msg_pub.count_and_get(p_count => x_msg_count
592: ,p_data => x_msg_data);

Line 590: x_return_status := fnd_api.g_ret_sts_unexp_error;

586: fnd_msg_pub.count_and_get(p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN fnd_api.g_exc_unexpected_error THEN
589: ROLLBACK TO eam_linear_locations_pub;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: fnd_msg_pub.count_and_get(p_count => x_msg_count
592: ,p_data => x_msg_data);
593: WHEN OTHERS THEN
594: ROLLBACK TO eam_linear_locations_pub;

Line 595: x_return_status := fnd_api.g_ret_sts_unexp_error;

591: fnd_msg_pub.count_and_get(p_count => x_msg_count
592: ,p_data => x_msg_data);
593: WHEN OTHERS THEN
594: ROLLBACK TO eam_linear_locations_pub;
595: x_return_status := fnd_api.g_ret_sts_unexp_error;
596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
597: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
598: END IF;
599: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

601: END create_asset;
602:
603: procedure create_work_request(
604: p_api_version IN NUMBER
605: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
606: ,p_commit IN VARCHAR2 := fnd_api.g_false
607: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
608: ,p_external_linear_id IN NUMBER
609: ,p_external_linear_name IN VARCHAR2

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

602:
603: procedure create_work_request(
604: p_api_version IN NUMBER
605: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
606: ,p_commit IN VARCHAR2 := fnd_api.g_false
607: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
608: ,p_external_linear_id IN NUMBER
609: ,p_external_linear_name IN VARCHAR2
610: ,p_external_source_name IN VARCHAR2

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

603: procedure create_work_request(
604: p_api_version IN NUMBER
605: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
606: ,p_commit IN VARCHAR2 := fnd_api.g_false
607: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
608: ,p_external_linear_id IN NUMBER
609: ,p_external_linear_name IN VARCHAR2
610: ,p_external_source_name IN VARCHAR2
611: ,p_external_linear_type IN VARCHAR2

Line 655: RAISE fnd_api.g_exc_unexpected_error;

651: resp_id => l_resp_id,
652: resp_appl_id => l_resp_appl_id
653: );
654: else
655: RAISE fnd_api.g_exc_unexpected_error;
656: end if;
657:
658: -- Standard call to check for call compatibility.
659: IF NOT fnd_api.compatible_api_call(

Line 659: IF NOT fnd_api.compatible_api_call(

655: RAISE fnd_api.g_exc_unexpected_error;
656: end if;
657:
658: -- Standard call to check for call compatibility.
659: IF NOT fnd_api.compatible_api_call(
660: l_api_version
661: ,p_api_version
662: ,l_api_name
663: ,g_pkg_name) THEN

Line 664: RAISE fnd_api.g_exc_unexpected_error;

660: l_api_version
661: ,p_api_version
662: ,l_api_name
663: ,g_pkg_name) THEN
664: RAISE fnd_api.g_exc_unexpected_error;
665: END IF;
666:
667: -- Initialize message list if p_init_msg_list is set to TRUE.
668: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 668: IF fnd_api.to_boolean(p_init_msg_list) THEN

664: RAISE fnd_api.g_exc_unexpected_error;
665: END IF;
666:
667: -- Initialize message list if p_init_msg_list is set to TRUE.
668: IF fnd_api.to_boolean(p_init_msg_list) THEN
669: fnd_msg_pub.initialize;
670: END IF;
671:
672: -- Initialize API return status to success

Line 673: x_return_status := fnd_api.g_ret_sts_success;

669: fnd_msg_pub.initialize;
670: END IF;
671:
672: -- Initialize API return status to success
673: x_return_status := fnd_api.g_ret_sts_success;
674:
675: -- API body
676:
677: eam_linear_locations_pub.get_eam_linear_id(

Line 727: IF FND_API.To_Boolean( p_commit ) THEN

723:
724:
725: --END API body
726: -- Standard check of p_commit.
727: IF FND_API.To_Boolean( p_commit ) THEN
728: COMMIT WORK;
729: END IF;
730: -- Standard call to get message count and if count is 1, get message info.
731: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 734: WHEN fnd_api.g_exc_error THEN

730: -- Standard call to get message count and if count is 1, get message info.
731: fnd_msg_pub.count_and_get(p_count => x_msg_count
732: ,p_data => x_msg_data);
733: EXCEPTION
734: WHEN fnd_api.g_exc_error THEN
735: ROLLBACK TO eam_linear_locations_pub;
736: x_return_status := fnd_api.g_ret_sts_error;
737: fnd_msg_pub.count_and_get(p_count => x_msg_count
738: ,p_data => x_msg_data);

Line 736: x_return_status := fnd_api.g_ret_sts_error;

732: ,p_data => x_msg_data);
733: EXCEPTION
734: WHEN fnd_api.g_exc_error THEN
735: ROLLBACK TO eam_linear_locations_pub;
736: x_return_status := fnd_api.g_ret_sts_error;
737: fnd_msg_pub.count_and_get(p_count => x_msg_count
738: ,p_data => x_msg_data);
739: WHEN fnd_api.g_exc_unexpected_error THEN
740: ROLLBACK TO eam_linear_locations_pub;

Line 739: WHEN fnd_api.g_exc_unexpected_error THEN

735: ROLLBACK TO eam_linear_locations_pub;
736: x_return_status := fnd_api.g_ret_sts_error;
737: fnd_msg_pub.count_and_get(p_count => x_msg_count
738: ,p_data => x_msg_data);
739: WHEN fnd_api.g_exc_unexpected_error THEN
740: ROLLBACK TO eam_linear_locations_pub;
741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742: fnd_msg_pub.count_and_get(p_count => x_msg_count
743: ,p_data => x_msg_data);

Line 741: x_return_status := fnd_api.g_ret_sts_unexp_error;

737: fnd_msg_pub.count_and_get(p_count => x_msg_count
738: ,p_data => x_msg_data);
739: WHEN fnd_api.g_exc_unexpected_error THEN
740: ROLLBACK TO eam_linear_locations_pub;
741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742: fnd_msg_pub.count_and_get(p_count => x_msg_count
743: ,p_data => x_msg_data);
744: WHEN OTHERS THEN
745: ROLLBACK TO eam_linear_locations_pub;

Line 746: x_return_status := fnd_api.g_ret_sts_unexp_error;

742: fnd_msg_pub.count_and_get(p_count => x_msg_count
743: ,p_data => x_msg_data);
744: WHEN OTHERS THEN
745: ROLLBACK TO eam_linear_locations_pub;
746: x_return_status := fnd_api.g_ret_sts_unexp_error;
747: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
748: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
749: END IF;
750: fnd_msg_pub.count_and_get(p_count => x_msg_count

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

762:
763: PROCEDURE CREATE_EAM_WO
764: ( p_bo_identifier IN VARCHAR2 := 'EAM'
765: , p_api_version IN NUMBER := 1.0
766: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
767: , p_commit IN VARCHAR2 := fnd_api.g_false
768: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
769: , p_external_source_name IN VARCHAR2
770: , p_external_linear_type IN VARCHAR2 := 'ASSET'

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

763: PROCEDURE CREATE_EAM_WO
764: ( p_bo_identifier IN VARCHAR2 := 'EAM'
765: , p_api_version IN NUMBER := 1.0
766: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
767: , p_commit IN VARCHAR2 := fnd_api.g_false
768: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
769: , p_external_source_name IN VARCHAR2
770: , p_external_linear_type IN VARCHAR2 := 'ASSET'
771: , p_external_linear_name IN VARCHAR2

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

764: ( p_bo_identifier IN VARCHAR2 := 'EAM'
765: , p_api_version IN NUMBER := 1.0
766: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
767: , p_commit IN VARCHAR2 := fnd_api.g_false
768: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
769: , p_external_source_name IN VARCHAR2
770: , p_external_linear_type IN VARCHAR2 := 'ASSET'
771: , p_external_linear_name IN VARCHAR2
772: , p_external_linear_id IN NUMBER

Line 810: , p_debug IN VARCHAR2 := fnd_api.g_false

806: , x_eam_op_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
807: , x_eam_request_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_request_tbl_type
808: , x_return_status OUT NOCOPY VARCHAR2
809: , x_msg_count OUT NOCOPY NUMBER
810: , p_debug IN VARCHAR2 := fnd_api.g_false
811: , p_output_dir IN VARCHAR2 := NULL
812: , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
813: , p_debug_file_mode IN VARCHAR2 := 'w'
814: )

Line 902: RAISE fnd_api.g_exc_unexpected_error;

898: resp_id => l_resp_id,
899: resp_appl_id => l_resp_appl_id
900: );
901: else
902: RAISE fnd_api.g_exc_unexpected_error;
903: end if;
904:
905: -- Standard call to check for call compatibility.
906: IF NOT fnd_api.compatible_api_call(

Line 906: IF NOT fnd_api.compatible_api_call(

902: RAISE fnd_api.g_exc_unexpected_error;
903: end if;
904:
905: -- Standard call to check for call compatibility.
906: IF NOT fnd_api.compatible_api_call(
907: l_api_version
908: ,p_api_version
909: ,l_api_name
910: ,g_pkg_name) THEN

Line 911: RAISE fnd_api.g_exc_unexpected_error;

907: l_api_version
908: ,p_api_version
909: ,l_api_name
910: ,g_pkg_name) THEN
911: RAISE fnd_api.g_exc_unexpected_error;
912: END IF;
913:
914: -- Initialize message list if p_init_msg_list is set to TRUE.
915: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 915: IF fnd_api.to_boolean(p_init_msg_list) THEN

911: RAISE fnd_api.g_exc_unexpected_error;
912: END IF;
913:
914: -- Initialize message list if p_init_msg_list is set to TRUE.
915: IF fnd_api.to_boolean(p_init_msg_list) THEN
916: fnd_msg_pub.initialize;
917: END IF;
918:
919: -- Initialize API return status to success

Line 920: x_return_status := fnd_api.g_ret_sts_success;

916: fnd_msg_pub.initialize;
917: END IF;
918:
919: -- Initialize API return status to success
920: x_return_status := fnd_api.g_ret_sts_success;
921:
922: -- API body
923:
924: l_bo_identifier := p_bo_identifier;

Line 1016: if p_debug = fnd_api.g_false then l_debug := 'N';

1012:
1013: end if;
1014:
1015:
1016: if p_debug = fnd_api.g_false then l_debug := 'N';
1017: else l_debug := 'Y';end if;
1018: if p_commit = fnd_api.g_false then l_commit := 'N';
1019: else l_commit := 'Y';end if;
1020:

Line 1018: if p_commit = fnd_api.g_false then l_commit := 'N';

1014:
1015:
1016: if p_debug = fnd_api.g_false then l_debug := 'N';
1017: else l_debug := 'Y';end if;
1018: if p_commit = fnd_api.g_false then l_commit := 'N';
1019: else l_commit := 'Y';end if;
1020:
1021: EAM_PROCESS_WO_PUB.PROCESS_WO
1022: ( p_bo_identifier => l_bo_identifier

Line 1024: , p_init_msg_list => fnd_api.to_boolean(l_init_msg_list)

1020:
1021: EAM_PROCESS_WO_PUB.PROCESS_WO
1022: ( p_bo_identifier => l_bo_identifier
1023: , p_api_version_number => l_api_version_number
1024: , p_init_msg_list => fnd_api.to_boolean(l_init_msg_list)
1025: , p_commit => l_commit
1026: , p_eam_wo_rec => l_eam_wo_rec
1027: , p_eam_op_tbl => l_eam_op_tbl
1028: , p_eam_op_network_tbl => l_eam_op_network_tbl

Line 1090: IF FND_API.To_Boolean( p_commit ) THEN

1086:
1087:
1088: --END API body
1089: -- Standard check of p_commit.
1090: IF FND_API.To_Boolean( p_commit ) THEN
1091: COMMIT WORK;
1092: END IF;
1093: -- Standard call to get message count and if count is 1, get message info.
1094: fnd_msg_pub.count_and_get(p_count => x_msg_count

Line 1097: WHEN fnd_api.g_exc_error THEN

1093: -- Standard call to get message count and if count is 1, get message info.
1094: fnd_msg_pub.count_and_get(p_count => x_msg_count
1095: ,p_data => x_msg_data);
1096: EXCEPTION
1097: WHEN fnd_api.g_exc_error THEN
1098: ROLLBACK TO create_eam_wo;
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: fnd_msg_pub.count_and_get(p_count => x_msg_count
1101: ,p_data => x_msg_data);

Line 1099: x_return_status := fnd_api.g_ret_sts_error;

1095: ,p_data => x_msg_data);
1096: EXCEPTION
1097: WHEN fnd_api.g_exc_error THEN
1098: ROLLBACK TO create_eam_wo;
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: fnd_msg_pub.count_and_get(p_count => x_msg_count
1101: ,p_data => x_msg_data);
1102: WHEN fnd_api.g_exc_unexpected_error THEN
1103: ROLLBACK TO create_eam_wo;

Line 1102: WHEN fnd_api.g_exc_unexpected_error THEN

1098: ROLLBACK TO create_eam_wo;
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: fnd_msg_pub.count_and_get(p_count => x_msg_count
1101: ,p_data => x_msg_data);
1102: WHEN fnd_api.g_exc_unexpected_error THEN
1103: ROLLBACK TO create_eam_wo;
1104: x_return_status := fnd_api.g_ret_sts_unexp_error;
1105: fnd_msg_pub.count_and_get(p_count => x_msg_count
1106: ,p_data => x_msg_data);

Line 1104: x_return_status := fnd_api.g_ret_sts_unexp_error;

1100: fnd_msg_pub.count_and_get(p_count => x_msg_count
1101: ,p_data => x_msg_data);
1102: WHEN fnd_api.g_exc_unexpected_error THEN
1103: ROLLBACK TO create_eam_wo;
1104: x_return_status := fnd_api.g_ret_sts_unexp_error;
1105: fnd_msg_pub.count_and_get(p_count => x_msg_count
1106: ,p_data => x_msg_data);
1107: WHEN OTHERS THEN
1108: ROLLBACK TO create_eam_wo;

Line 1109: x_return_status := fnd_api.g_ret_sts_unexp_error;

1105: fnd_msg_pub.count_and_get(p_count => x_msg_count
1106: ,p_data => x_msg_data);
1107: WHEN OTHERS THEN
1108: ROLLBACK TO create_eam_wo;
1109: x_return_status := fnd_api.g_ret_sts_unexp_error;
1110: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1111: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1112: END IF;
1113: fnd_msg_pub.count_and_get(p_count => x_msg_count