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_NETWORK_ASSETS_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: -- P_ROWID IN OUT VARCHAR2 REQUIRED
17: -- P_NETWORK_ASSOCIATION_ID IN OUT NUMBER REQUIRED

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: -- P_ROWID IN OUT VARCHAR2 REQUIRED
17: -- P_NETWORK_ASSOCIATION_ID IN OUT NUMBER REQUIRED
18: -- P_ORGANIZATION_ID IN NUMBER REQUIRED
19: -- P_NETWORK_OBJECT_TYPE IN NUMBER REQUIRED

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

63:
64:
65: PROCEDURE INSERT_ROW(
66: P_API_VERSION IN NUMBER,
67: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
68: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
69: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_ROWID IN OUT NOCOPY VARCHAR2,
71: P_NETWORK_ASSOCIATION_ID IN OUT NOCOPY NUMBER,

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

64:
65: PROCEDURE INSERT_ROW(
66: P_API_VERSION IN NUMBER,
67: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
68: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
69: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_ROWID IN OUT NOCOPY VARCHAR2,
71: P_NETWORK_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
72: P_ORGANIZATION_ID NUMBER,

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

65: PROCEDURE INSERT_ROW(
66: P_API_VERSION IN NUMBER,
67: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
68: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
69: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70: P_ROWID IN OUT NOCOPY VARCHAR2,
71: P_NETWORK_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
72: P_ORGANIZATION_ID NUMBER,
73: P_NETWORK_OBJECT_TYPE NUMBER,

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

121: -- Standard Start of API savepoint
122: SAVEPOINT insert_row;
123:
124: -- Standard call to check for call compatibility.
125: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
126: RAISE fnd_api.g_exc_unexpected_error;
127: END IF;
128:
129: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 126: RAISE fnd_api.g_exc_unexpected_error;

122: SAVEPOINT insert_row;
123:
124: -- Standard call to check for call compatibility.
125: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
126: RAISE fnd_api.g_exc_unexpected_error;
127: END IF;
128:
129: -- Initialize message list if p_init_msg_list is set to TRUE.
130: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 130: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 135: x_return_status := fnd_api.g_ret_sts_success;

131: fnd_msg_pub.initialize;
132: END IF;
133:
134: -- Initialize API return status to success
135: x_return_status := fnd_api.g_ret_sts_success;
136:
137: -- API body
138:
139: INSERT INTO MTL_EAM_NETWORK_ASSETS(

Line 227: IF fnd_api.to_boolean(p_commit) THEN

223: CLOSE C;
224:
225: -- End of API body.
226: -- Standard check of p_commit.
227: IF fnd_api.to_boolean(p_commit) THEN
228: COMMIT WORK;
229: END IF;
230:
231: -- Standard call to get message count and if count is 1, get message info.

Line 234: WHEN fnd_api.g_exc_error THEN

230:
231: -- Standard call to get message count and if count is 1, get message info.
232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
233: EXCEPTION
234: WHEN fnd_api.g_exc_error THEN
235: ROLLBACK TO insert_row;
236: x_return_status := fnd_api.g_ret_sts_error;
237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
238: WHEN fnd_api.g_exc_unexpected_error THEN

Line 236: x_return_status := fnd_api.g_ret_sts_error;

232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
233: EXCEPTION
234: WHEN fnd_api.g_exc_error THEN
235: ROLLBACK TO insert_row;
236: x_return_status := fnd_api.g_ret_sts_error;
237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
238: WHEN fnd_api.g_exc_unexpected_error THEN
239: ROLLBACK TO insert_row;
240: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 238: WHEN fnd_api.g_exc_unexpected_error THEN

234: WHEN fnd_api.g_exc_error THEN
235: ROLLBACK TO insert_row;
236: x_return_status := fnd_api.g_ret_sts_error;
237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
238: WHEN fnd_api.g_exc_unexpected_error THEN
239: ROLLBACK TO insert_row;
240: x_return_status := fnd_api.g_ret_sts_unexp_error;
241: fnd_msg_pub.count_and_get(
242: p_count => x_msg_count

Line 240: x_return_status := fnd_api.g_ret_sts_unexp_error;

236: x_return_status := fnd_api.g_ret_sts_error;
237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
238: WHEN fnd_api.g_exc_unexpected_error THEN
239: ROLLBACK TO insert_row;
240: x_return_status := fnd_api.g_ret_sts_unexp_error;
241: fnd_msg_pub.count_and_get(
242: p_count => x_msg_count
243: ,p_data => x_msg_data);
244: WHEN OTHERS THEN

Line 246: x_return_status := fnd_api.g_ret_sts_unexp_error;

242: p_count => x_msg_count
243: ,p_data => x_msg_data);
244: WHEN OTHERS THEN
245: ROLLBACK TO insert_row;
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247:
248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
249: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
250: END IF;

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

254: END Insert_Row;
255:
256: PROCEDURE LOCK_ROW(
257: P_API_VERSION IN NUMBER,
258: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
259: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
260: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: P_ROWID VARCHAR2,
262: P_NETWORK_ASSOCIATION_ID NUMBER,

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

255:
256: PROCEDURE LOCK_ROW(
257: P_API_VERSION IN NUMBER,
258: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
259: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
260: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: P_ROWID VARCHAR2,
262: P_NETWORK_ASSOCIATION_ID NUMBER,
263: P_ORGANIZATION_ID NUMBER,

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

256: PROCEDURE LOCK_ROW(
257: P_API_VERSION IN NUMBER,
258: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
259: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
260: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: P_ROWID VARCHAR2,
262: P_NETWORK_ASSOCIATION_ID NUMBER,
263: P_ORGANIZATION_ID NUMBER,
264: P_NETWORK_OBJECT_TYPE NUMBER,

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

311: -- Standard Start of API savepoint
312: SAVEPOINT lock_row;
313:
314: -- Standard call to check for call compatibility.
315: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
316: RAISE fnd_api.g_exc_unexpected_error;
317: END IF;
318:
319: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 316: RAISE fnd_api.g_exc_unexpected_error;

312: SAVEPOINT lock_row;
313:
314: -- Standard call to check for call compatibility.
315: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
316: RAISE fnd_api.g_exc_unexpected_error;
317: END IF;
318:
319: -- Initialize message list if p_init_msg_list is set to TRUE.
320: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 320: IF fnd_api.to_boolean(p_init_msg_list) THEN

316: RAISE fnd_api.g_exc_unexpected_error;
317: END IF;
318:
319: -- Initialize message list if p_init_msg_list is set to TRUE.
320: IF fnd_api.to_boolean(p_init_msg_list) THEN
321: fnd_msg_pub.initialize;
322: END IF;
323:
324: -- Initialize API return status to success

Line 325: x_return_status := fnd_api.g_ret_sts_success;

321: fnd_msg_pub.initialize;
322: END IF;
323:
324: -- Initialize API return status to success
325: x_return_status := fnd_api.g_ret_sts_success;
326:
327: -- API body
328:
329: OPEN C;

Line 425: IF fnd_api.to_boolean(p_commit) THEN

421: end if;
422:
423: -- End of API body.
424: -- Standard check of p_commit.
425: IF fnd_api.to_boolean(p_commit) THEN
426: COMMIT WORK;
427: END IF;
428:
429: -- Standard call to get message count and if count is 1, get message info.

Line 432: WHEN fnd_api.g_exc_error THEN

428:
429: -- Standard call to get message count and if count is 1, get message info.
430: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
431: EXCEPTION
432: WHEN fnd_api.g_exc_error THEN
433: ROLLBACK TO lock_row;
434: x_return_status := fnd_api.g_ret_sts_error;
435: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
436: WHEN fnd_api.g_exc_unexpected_error THEN

Line 434: x_return_status := fnd_api.g_ret_sts_error;

430: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
431: EXCEPTION
432: WHEN fnd_api.g_exc_error THEN
433: ROLLBACK TO lock_row;
434: x_return_status := fnd_api.g_ret_sts_error;
435: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
436: WHEN fnd_api.g_exc_unexpected_error THEN
437: ROLLBACK TO lock_row;
438: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 436: WHEN fnd_api.g_exc_unexpected_error THEN

432: WHEN fnd_api.g_exc_error THEN
433: ROLLBACK TO lock_row;
434: x_return_status := fnd_api.g_ret_sts_error;
435: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
436: WHEN fnd_api.g_exc_unexpected_error THEN
437: ROLLBACK TO lock_row;
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439: fnd_msg_pub.count_and_get(
440: p_count => x_msg_count

Line 438: x_return_status := fnd_api.g_ret_sts_unexp_error;

434: x_return_status := fnd_api.g_ret_sts_error;
435: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
436: WHEN fnd_api.g_exc_unexpected_error THEN
437: ROLLBACK TO lock_row;
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439: fnd_msg_pub.count_and_get(
440: p_count => x_msg_count
441: ,p_data => x_msg_data);
442: WHEN OTHERS THEN

Line 444: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

452: END Lock_Row;
453:
454: PROCEDURE UPDATE_ROW(
455: P_API_VERSION IN NUMBER,
456: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
457: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
458: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
459: P_ROWID VARCHAR2,
460: P_NETWORK_ASSOCIATION_ID NUMBER,

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

453:
454: PROCEDURE UPDATE_ROW(
455: P_API_VERSION IN NUMBER,
456: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
457: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
458: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
459: P_ROWID VARCHAR2,
460: P_NETWORK_ASSOCIATION_ID NUMBER,
461: P_ORGANIZATION_ID NUMBER,

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

454: PROCEDURE UPDATE_ROW(
455: P_API_VERSION IN NUMBER,
456: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
457: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
458: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
459: P_ROWID VARCHAR2,
460: P_NETWORK_ASSOCIATION_ID NUMBER,
461: P_ORGANIZATION_ID NUMBER,
462: P_NETWORK_OBJECT_TYPE NUMBER,

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

503: -- Standard Start of API savepoint
504: SAVEPOINT update_row;
505:
506: -- Standard call to check for call compatibility.
507: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
508: RAISE fnd_api.g_exc_unexpected_error;
509: END IF;
510:
511: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 508: RAISE fnd_api.g_exc_unexpected_error;

504: SAVEPOINT update_row;
505:
506: -- Standard call to check for call compatibility.
507: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
508: RAISE fnd_api.g_exc_unexpected_error;
509: END IF;
510:
511: -- Initialize message list if p_init_msg_list is set to TRUE.
512: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 512: IF fnd_api.to_boolean(p_init_msg_list) THEN

508: RAISE fnd_api.g_exc_unexpected_error;
509: END IF;
510:
511: -- Initialize message list if p_init_msg_list is set to TRUE.
512: IF fnd_api.to_boolean(p_init_msg_list) THEN
513: fnd_msg_pub.initialize;
514: END IF;
515:
516: -- Initialize API return status to success

Line 517: x_return_status := fnd_api.g_ret_sts_success;

513: fnd_msg_pub.initialize;
514: END IF;
515:
516: -- Initialize API return status to success
517: x_return_status := fnd_api.g_ret_sts_success;
518:
519: -- API body
520:
521: UPDATE MTL_EAM_NETWORK_ASSETS

Line 561: IF fnd_api.to_boolean(p_commit) THEN

557: end if;
558:
559: -- End of API body.
560: -- Standard check of p_commit.
561: IF fnd_api.to_boolean(p_commit) THEN
562: COMMIT WORK;
563: END IF;
564:
565: -- Standard call to get message count and if count is 1, get message info.

Line 568: WHEN fnd_api.g_exc_error THEN

564:
565: -- Standard call to get message count and if count is 1, get message info.
566: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
567: EXCEPTION
568: WHEN fnd_api.g_exc_error THEN
569: ROLLBACK TO update_row;
570: x_return_status := fnd_api.g_ret_sts_error;
571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
572: WHEN fnd_api.g_exc_unexpected_error THEN

Line 570: x_return_status := fnd_api.g_ret_sts_error;

566: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
567: EXCEPTION
568: WHEN fnd_api.g_exc_error THEN
569: ROLLBACK TO update_row;
570: x_return_status := fnd_api.g_ret_sts_error;
571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
572: WHEN fnd_api.g_exc_unexpected_error THEN
573: ROLLBACK TO update_row;
574: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 572: WHEN fnd_api.g_exc_unexpected_error THEN

568: WHEN fnd_api.g_exc_error THEN
569: ROLLBACK TO update_row;
570: x_return_status := fnd_api.g_ret_sts_error;
571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
572: WHEN fnd_api.g_exc_unexpected_error THEN
573: ROLLBACK TO update_row;
574: x_return_status := fnd_api.g_ret_sts_unexp_error;
575: fnd_msg_pub.count_and_get(
576: p_count => x_msg_count

Line 574: x_return_status := fnd_api.g_ret_sts_unexp_error;

570: x_return_status := fnd_api.g_ret_sts_error;
571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
572: WHEN fnd_api.g_exc_unexpected_error THEN
573: ROLLBACK TO update_row;
574: x_return_status := fnd_api.g_ret_sts_unexp_error;
575: fnd_msg_pub.count_and_get(
576: p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN OTHERS THEN

Line 580: x_return_status := fnd_api.g_ret_sts_unexp_error;

576: p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN OTHERS THEN
579: ROLLBACK TO update_row;
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581:
582: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
583: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
584: END IF;