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_ASSET_ATTR_IMPORT_PVT 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: --
14: -- p_interface_header_id IN NUMBER Required,

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: --
14: -- p_interface_header_id IN NUMBER Required,
15: -- p_purge_option IN VARCHAR2 Optional Default = 'N'

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: --
14: -- p_interface_header_id IN NUMBER Required,
15: -- p_purge_option IN VARCHAR2 Optional Default = 'N'
16: --

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

34:
35: PROCEDURE import_asset_attr_values
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41: p_interface_header_id IN NUMBER,
42: p_import_mode IN NUMBER,

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

35: PROCEDURE import_asset_attr_values
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41: p_interface_header_id IN NUMBER,
42: p_import_mode IN NUMBER,
43: p_purge_option IN VARCHAR2 := fnd_api.g_false,

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

36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41: p_interface_header_id IN NUMBER,
42: p_import_mode IN NUMBER,
43: p_purge_option IN VARCHAR2 := fnd_api.g_false,
44: x_return_status OUT NOCOPY VARCHAR2,

Line 43: p_purge_option IN VARCHAR2 := fnd_api.g_false,

39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41: p_interface_header_id IN NUMBER,
42: p_import_mode IN NUMBER,
43: p_purge_option IN VARCHAR2 := fnd_api.g_false,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2
47: ) IS

Line 65: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;

61: l_application_id CONSTANT NUMBER := 401;
62: l_application_code CONSTANT VARCHAR2(3) := 'INV';
63: l_descriptive_flexfield_name CONSTANT VARCHAR2(30) := 'MTL_EAM_ASSET_ATTR_VALUES';
64:
65: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
66: l_commit VARCHAR2(1) := fnd_api.g_false;
67: l_validation_level NUMBER := fnd_api.g_valid_level_full;
68: l_rowid urowid;
69: l_association_id number;

Line 66: l_commit VARCHAR2(1) := fnd_api.g_false;

62: l_application_code CONSTANT VARCHAR2(3) := 'INV';
63: l_descriptive_flexfield_name CONSTANT VARCHAR2(30) := 'MTL_EAM_ASSET_ATTR_VALUES';
64:
65: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
66: l_commit VARCHAR2(1) := fnd_api.g_false;
67: l_validation_level NUMBER := fnd_api.g_valid_level_full;
68: l_rowid urowid;
69: l_association_id number;
70: l_inventory_item_id number;

Line 67: l_validation_level NUMBER := fnd_api.g_valid_level_full;

63: l_descriptive_flexfield_name CONSTANT VARCHAR2(30) := 'MTL_EAM_ASSET_ATTR_VALUES';
64:
65: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
66: l_commit VARCHAR2(1) := fnd_api.g_false;
67: l_validation_level NUMBER := fnd_api.g_valid_level_full;
68: l_rowid urowid;
69: l_association_id number;
70: l_inventory_item_id number;
71: l_serial_number varchar2(30);

Line 190: IF NOT fnd_api.compatible_api_call(

186: -- Standard Start of API savepoint
187: SAVEPOINT import_asset_attr_values_pvt;
188:
189: -- Standard call to check for call compatibility.
190: IF NOT fnd_api.compatible_api_call(
191: l_api_version
192: ,p_api_version
193: ,l_api_name
194: ,g_pkg_name) THEN

Line 195: RAISE fnd_api.g_exc_unexpected_error;

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

Line 199: IF fnd_api.to_boolean(p_init_msg_list) THEN

195: RAISE fnd_api.g_exc_unexpected_error;
196: END IF;
197:
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: -- Initialize API return status to success

Line 204: x_return_status := fnd_api.g_ret_sts_success;

200: fnd_msg_pub.initialize;
201: END IF;
202:
203: -- Initialize API return status to success
204: x_return_status := fnd_api.g_ret_sts_success;
205:
206:
207:
208: -- 2002-01-02: chrng: To fix bug 2167188, check that derived columns are NULL.

Line 444: l_c_attribute(1) := fnd_api.g_miss_char;

440: END LOOP;
441:
442: /* Bug 3371507
443: IF(p_import_mode = 1) THEN
444: l_c_attribute(1) := fnd_api.g_miss_char;
445: l_c_attribute(2) := fnd_api.g_miss_char;
446: l_c_attribute(3) := fnd_api.g_miss_char;
447: l_c_attribute(4) := fnd_api.g_miss_char;
448: l_c_attribute(5) := fnd_api.g_miss_char;

Line 445: l_c_attribute(2) := fnd_api.g_miss_char;

441:
442: /* Bug 3371507
443: IF(p_import_mode = 1) THEN
444: l_c_attribute(1) := fnd_api.g_miss_char;
445: l_c_attribute(2) := fnd_api.g_miss_char;
446: l_c_attribute(3) := fnd_api.g_miss_char;
447: l_c_attribute(4) := fnd_api.g_miss_char;
448: l_c_attribute(5) := fnd_api.g_miss_char;
449: l_c_attribute(6) := fnd_api.g_miss_char;

Line 446: l_c_attribute(3) := fnd_api.g_miss_char;

442: /* Bug 3371507
443: IF(p_import_mode = 1) THEN
444: l_c_attribute(1) := fnd_api.g_miss_char;
445: l_c_attribute(2) := fnd_api.g_miss_char;
446: l_c_attribute(3) := fnd_api.g_miss_char;
447: l_c_attribute(4) := fnd_api.g_miss_char;
448: l_c_attribute(5) := fnd_api.g_miss_char;
449: l_c_attribute(6) := fnd_api.g_miss_char;
450: l_c_attribute(7) := fnd_api.g_miss_char;

Line 447: l_c_attribute(4) := fnd_api.g_miss_char;

443: IF(p_import_mode = 1) THEN
444: l_c_attribute(1) := fnd_api.g_miss_char;
445: l_c_attribute(2) := fnd_api.g_miss_char;
446: l_c_attribute(3) := fnd_api.g_miss_char;
447: l_c_attribute(4) := fnd_api.g_miss_char;
448: l_c_attribute(5) := fnd_api.g_miss_char;
449: l_c_attribute(6) := fnd_api.g_miss_char;
450: l_c_attribute(7) := fnd_api.g_miss_char;
451: l_c_attribute(8) := fnd_api.g_miss_char;

Line 448: l_c_attribute(5) := fnd_api.g_miss_char;

444: l_c_attribute(1) := fnd_api.g_miss_char;
445: l_c_attribute(2) := fnd_api.g_miss_char;
446: l_c_attribute(3) := fnd_api.g_miss_char;
447: l_c_attribute(4) := fnd_api.g_miss_char;
448: l_c_attribute(5) := fnd_api.g_miss_char;
449: l_c_attribute(6) := fnd_api.g_miss_char;
450: l_c_attribute(7) := fnd_api.g_miss_char;
451: l_c_attribute(8) := fnd_api.g_miss_char;
452: l_c_attribute(9) := fnd_api.g_miss_char;

Line 449: l_c_attribute(6) := fnd_api.g_miss_char;

445: l_c_attribute(2) := fnd_api.g_miss_char;
446: l_c_attribute(3) := fnd_api.g_miss_char;
447: l_c_attribute(4) := fnd_api.g_miss_char;
448: l_c_attribute(5) := fnd_api.g_miss_char;
449: l_c_attribute(6) := fnd_api.g_miss_char;
450: l_c_attribute(7) := fnd_api.g_miss_char;
451: l_c_attribute(8) := fnd_api.g_miss_char;
452: l_c_attribute(9) := fnd_api.g_miss_char;
453: l_c_attribute(10) := fnd_api.g_miss_char;

Line 450: l_c_attribute(7) := fnd_api.g_miss_char;

446: l_c_attribute(3) := fnd_api.g_miss_char;
447: l_c_attribute(4) := fnd_api.g_miss_char;
448: l_c_attribute(5) := fnd_api.g_miss_char;
449: l_c_attribute(6) := fnd_api.g_miss_char;
450: l_c_attribute(7) := fnd_api.g_miss_char;
451: l_c_attribute(8) := fnd_api.g_miss_char;
452: l_c_attribute(9) := fnd_api.g_miss_char;
453: l_c_attribute(10) := fnd_api.g_miss_char;
454: l_c_attribute(11) := fnd_api.g_miss_char;

Line 451: l_c_attribute(8) := fnd_api.g_miss_char;

447: l_c_attribute(4) := fnd_api.g_miss_char;
448: l_c_attribute(5) := fnd_api.g_miss_char;
449: l_c_attribute(6) := fnd_api.g_miss_char;
450: l_c_attribute(7) := fnd_api.g_miss_char;
451: l_c_attribute(8) := fnd_api.g_miss_char;
452: l_c_attribute(9) := fnd_api.g_miss_char;
453: l_c_attribute(10) := fnd_api.g_miss_char;
454: l_c_attribute(11) := fnd_api.g_miss_char;
455: l_c_attribute(12) := fnd_api.g_miss_char;

Line 452: l_c_attribute(9) := fnd_api.g_miss_char;

448: l_c_attribute(5) := fnd_api.g_miss_char;
449: l_c_attribute(6) := fnd_api.g_miss_char;
450: l_c_attribute(7) := fnd_api.g_miss_char;
451: l_c_attribute(8) := fnd_api.g_miss_char;
452: l_c_attribute(9) := fnd_api.g_miss_char;
453: l_c_attribute(10) := fnd_api.g_miss_char;
454: l_c_attribute(11) := fnd_api.g_miss_char;
455: l_c_attribute(12) := fnd_api.g_miss_char;
456: l_c_attribute(13) := fnd_api.g_miss_char;

Line 453: l_c_attribute(10) := fnd_api.g_miss_char;

449: l_c_attribute(6) := fnd_api.g_miss_char;
450: l_c_attribute(7) := fnd_api.g_miss_char;
451: l_c_attribute(8) := fnd_api.g_miss_char;
452: l_c_attribute(9) := fnd_api.g_miss_char;
453: l_c_attribute(10) := fnd_api.g_miss_char;
454: l_c_attribute(11) := fnd_api.g_miss_char;
455: l_c_attribute(12) := fnd_api.g_miss_char;
456: l_c_attribute(13) := fnd_api.g_miss_char;
457: l_c_attribute(14) := fnd_api.g_miss_char;

Line 454: l_c_attribute(11) := fnd_api.g_miss_char;

450: l_c_attribute(7) := fnd_api.g_miss_char;
451: l_c_attribute(8) := fnd_api.g_miss_char;
452: l_c_attribute(9) := fnd_api.g_miss_char;
453: l_c_attribute(10) := fnd_api.g_miss_char;
454: l_c_attribute(11) := fnd_api.g_miss_char;
455: l_c_attribute(12) := fnd_api.g_miss_char;
456: l_c_attribute(13) := fnd_api.g_miss_char;
457: l_c_attribute(14) := fnd_api.g_miss_char;
458: l_c_attribute(15) := fnd_api.g_miss_char;

Line 455: l_c_attribute(12) := fnd_api.g_miss_char;

451: l_c_attribute(8) := fnd_api.g_miss_char;
452: l_c_attribute(9) := fnd_api.g_miss_char;
453: l_c_attribute(10) := fnd_api.g_miss_char;
454: l_c_attribute(11) := fnd_api.g_miss_char;
455: l_c_attribute(12) := fnd_api.g_miss_char;
456: l_c_attribute(13) := fnd_api.g_miss_char;
457: l_c_attribute(14) := fnd_api.g_miss_char;
458: l_c_attribute(15) := fnd_api.g_miss_char;
459: l_c_attribute(16) := fnd_api.g_miss_char;

Line 456: l_c_attribute(13) := fnd_api.g_miss_char;

452: l_c_attribute(9) := fnd_api.g_miss_char;
453: l_c_attribute(10) := fnd_api.g_miss_char;
454: l_c_attribute(11) := fnd_api.g_miss_char;
455: l_c_attribute(12) := fnd_api.g_miss_char;
456: l_c_attribute(13) := fnd_api.g_miss_char;
457: l_c_attribute(14) := fnd_api.g_miss_char;
458: l_c_attribute(15) := fnd_api.g_miss_char;
459: l_c_attribute(16) := fnd_api.g_miss_char;
460: l_c_attribute(17) := fnd_api.g_miss_char;

Line 457: l_c_attribute(14) := fnd_api.g_miss_char;

453: l_c_attribute(10) := fnd_api.g_miss_char;
454: l_c_attribute(11) := fnd_api.g_miss_char;
455: l_c_attribute(12) := fnd_api.g_miss_char;
456: l_c_attribute(13) := fnd_api.g_miss_char;
457: l_c_attribute(14) := fnd_api.g_miss_char;
458: l_c_attribute(15) := fnd_api.g_miss_char;
459: l_c_attribute(16) := fnd_api.g_miss_char;
460: l_c_attribute(17) := fnd_api.g_miss_char;
461: l_c_attribute(18) := fnd_api.g_miss_char;

Line 458: l_c_attribute(15) := fnd_api.g_miss_char;

454: l_c_attribute(11) := fnd_api.g_miss_char;
455: l_c_attribute(12) := fnd_api.g_miss_char;
456: l_c_attribute(13) := fnd_api.g_miss_char;
457: l_c_attribute(14) := fnd_api.g_miss_char;
458: l_c_attribute(15) := fnd_api.g_miss_char;
459: l_c_attribute(16) := fnd_api.g_miss_char;
460: l_c_attribute(17) := fnd_api.g_miss_char;
461: l_c_attribute(18) := fnd_api.g_miss_char;
462: l_c_attribute(19) := fnd_api.g_miss_char;

Line 459: l_c_attribute(16) := fnd_api.g_miss_char;

455: l_c_attribute(12) := fnd_api.g_miss_char;
456: l_c_attribute(13) := fnd_api.g_miss_char;
457: l_c_attribute(14) := fnd_api.g_miss_char;
458: l_c_attribute(15) := fnd_api.g_miss_char;
459: l_c_attribute(16) := fnd_api.g_miss_char;
460: l_c_attribute(17) := fnd_api.g_miss_char;
461: l_c_attribute(18) := fnd_api.g_miss_char;
462: l_c_attribute(19) := fnd_api.g_miss_char;
463: l_c_attribute(20) := fnd_api.g_miss_char;

Line 460: l_c_attribute(17) := fnd_api.g_miss_char;

456: l_c_attribute(13) := fnd_api.g_miss_char;
457: l_c_attribute(14) := fnd_api.g_miss_char;
458: l_c_attribute(15) := fnd_api.g_miss_char;
459: l_c_attribute(16) := fnd_api.g_miss_char;
460: l_c_attribute(17) := fnd_api.g_miss_char;
461: l_c_attribute(18) := fnd_api.g_miss_char;
462: l_c_attribute(19) := fnd_api.g_miss_char;
463: l_c_attribute(20) := fnd_api.g_miss_char;
464: l_d_attribute(1) := fnd_api.g_miss_date;

Line 461: l_c_attribute(18) := fnd_api.g_miss_char;

457: l_c_attribute(14) := fnd_api.g_miss_char;
458: l_c_attribute(15) := fnd_api.g_miss_char;
459: l_c_attribute(16) := fnd_api.g_miss_char;
460: l_c_attribute(17) := fnd_api.g_miss_char;
461: l_c_attribute(18) := fnd_api.g_miss_char;
462: l_c_attribute(19) := fnd_api.g_miss_char;
463: l_c_attribute(20) := fnd_api.g_miss_char;
464: l_d_attribute(1) := fnd_api.g_miss_date;
465: l_d_attribute(2) := fnd_api.g_miss_date;

Line 462: l_c_attribute(19) := fnd_api.g_miss_char;

458: l_c_attribute(15) := fnd_api.g_miss_char;
459: l_c_attribute(16) := fnd_api.g_miss_char;
460: l_c_attribute(17) := fnd_api.g_miss_char;
461: l_c_attribute(18) := fnd_api.g_miss_char;
462: l_c_attribute(19) := fnd_api.g_miss_char;
463: l_c_attribute(20) := fnd_api.g_miss_char;
464: l_d_attribute(1) := fnd_api.g_miss_date;
465: l_d_attribute(2) := fnd_api.g_miss_date;
466: l_d_attribute(3) := fnd_api.g_miss_date;

Line 463: l_c_attribute(20) := fnd_api.g_miss_char;

459: l_c_attribute(16) := fnd_api.g_miss_char;
460: l_c_attribute(17) := fnd_api.g_miss_char;
461: l_c_attribute(18) := fnd_api.g_miss_char;
462: l_c_attribute(19) := fnd_api.g_miss_char;
463: l_c_attribute(20) := fnd_api.g_miss_char;
464: l_d_attribute(1) := fnd_api.g_miss_date;
465: l_d_attribute(2) := fnd_api.g_miss_date;
466: l_d_attribute(3) := fnd_api.g_miss_date;
467: l_d_attribute(4) := fnd_api.g_miss_date;

Line 464: l_d_attribute(1) := fnd_api.g_miss_date;

460: l_c_attribute(17) := fnd_api.g_miss_char;
461: l_c_attribute(18) := fnd_api.g_miss_char;
462: l_c_attribute(19) := fnd_api.g_miss_char;
463: l_c_attribute(20) := fnd_api.g_miss_char;
464: l_d_attribute(1) := fnd_api.g_miss_date;
465: l_d_attribute(2) := fnd_api.g_miss_date;
466: l_d_attribute(3) := fnd_api.g_miss_date;
467: l_d_attribute(4) := fnd_api.g_miss_date;
468: l_d_attribute(5) := fnd_api.g_miss_date;

Line 465: l_d_attribute(2) := fnd_api.g_miss_date;

461: l_c_attribute(18) := fnd_api.g_miss_char;
462: l_c_attribute(19) := fnd_api.g_miss_char;
463: l_c_attribute(20) := fnd_api.g_miss_char;
464: l_d_attribute(1) := fnd_api.g_miss_date;
465: l_d_attribute(2) := fnd_api.g_miss_date;
466: l_d_attribute(3) := fnd_api.g_miss_date;
467: l_d_attribute(4) := fnd_api.g_miss_date;
468: l_d_attribute(5) := fnd_api.g_miss_date;
469: l_d_attribute(6) := fnd_api.g_miss_date;

Line 466: l_d_attribute(3) := fnd_api.g_miss_date;

462: l_c_attribute(19) := fnd_api.g_miss_char;
463: l_c_attribute(20) := fnd_api.g_miss_char;
464: l_d_attribute(1) := fnd_api.g_miss_date;
465: l_d_attribute(2) := fnd_api.g_miss_date;
466: l_d_attribute(3) := fnd_api.g_miss_date;
467: l_d_attribute(4) := fnd_api.g_miss_date;
468: l_d_attribute(5) := fnd_api.g_miss_date;
469: l_d_attribute(6) := fnd_api.g_miss_date;
470: l_d_attribute(7) := fnd_api.g_miss_date;

Line 467: l_d_attribute(4) := fnd_api.g_miss_date;

463: l_c_attribute(20) := fnd_api.g_miss_char;
464: l_d_attribute(1) := fnd_api.g_miss_date;
465: l_d_attribute(2) := fnd_api.g_miss_date;
466: l_d_attribute(3) := fnd_api.g_miss_date;
467: l_d_attribute(4) := fnd_api.g_miss_date;
468: l_d_attribute(5) := fnd_api.g_miss_date;
469: l_d_attribute(6) := fnd_api.g_miss_date;
470: l_d_attribute(7) := fnd_api.g_miss_date;
471: l_d_attribute(8) := fnd_api.g_miss_date;

Line 468: l_d_attribute(5) := fnd_api.g_miss_date;

464: l_d_attribute(1) := fnd_api.g_miss_date;
465: l_d_attribute(2) := fnd_api.g_miss_date;
466: l_d_attribute(3) := fnd_api.g_miss_date;
467: l_d_attribute(4) := fnd_api.g_miss_date;
468: l_d_attribute(5) := fnd_api.g_miss_date;
469: l_d_attribute(6) := fnd_api.g_miss_date;
470: l_d_attribute(7) := fnd_api.g_miss_date;
471: l_d_attribute(8) := fnd_api.g_miss_date;
472: l_d_attribute(9) := fnd_api.g_miss_date;

Line 469: l_d_attribute(6) := fnd_api.g_miss_date;

465: l_d_attribute(2) := fnd_api.g_miss_date;
466: l_d_attribute(3) := fnd_api.g_miss_date;
467: l_d_attribute(4) := fnd_api.g_miss_date;
468: l_d_attribute(5) := fnd_api.g_miss_date;
469: l_d_attribute(6) := fnd_api.g_miss_date;
470: l_d_attribute(7) := fnd_api.g_miss_date;
471: l_d_attribute(8) := fnd_api.g_miss_date;
472: l_d_attribute(9) := fnd_api.g_miss_date;
473: l_d_attribute(10) := fnd_api.g_miss_date;

Line 470: l_d_attribute(7) := fnd_api.g_miss_date;

466: l_d_attribute(3) := fnd_api.g_miss_date;
467: l_d_attribute(4) := fnd_api.g_miss_date;
468: l_d_attribute(5) := fnd_api.g_miss_date;
469: l_d_attribute(6) := fnd_api.g_miss_date;
470: l_d_attribute(7) := fnd_api.g_miss_date;
471: l_d_attribute(8) := fnd_api.g_miss_date;
472: l_d_attribute(9) := fnd_api.g_miss_date;
473: l_d_attribute(10) := fnd_api.g_miss_date;
474: l_n_attribute(1) := fnd_api.g_miss_num;

Line 471: l_d_attribute(8) := fnd_api.g_miss_date;

467: l_d_attribute(4) := fnd_api.g_miss_date;
468: l_d_attribute(5) := fnd_api.g_miss_date;
469: l_d_attribute(6) := fnd_api.g_miss_date;
470: l_d_attribute(7) := fnd_api.g_miss_date;
471: l_d_attribute(8) := fnd_api.g_miss_date;
472: l_d_attribute(9) := fnd_api.g_miss_date;
473: l_d_attribute(10) := fnd_api.g_miss_date;
474: l_n_attribute(1) := fnd_api.g_miss_num;
475: l_n_attribute(2) := fnd_api.g_miss_num;

Line 472: l_d_attribute(9) := fnd_api.g_miss_date;

468: l_d_attribute(5) := fnd_api.g_miss_date;
469: l_d_attribute(6) := fnd_api.g_miss_date;
470: l_d_attribute(7) := fnd_api.g_miss_date;
471: l_d_attribute(8) := fnd_api.g_miss_date;
472: l_d_attribute(9) := fnd_api.g_miss_date;
473: l_d_attribute(10) := fnd_api.g_miss_date;
474: l_n_attribute(1) := fnd_api.g_miss_num;
475: l_n_attribute(2) := fnd_api.g_miss_num;
476: l_n_attribute(3) := fnd_api.g_miss_num;

Line 473: l_d_attribute(10) := fnd_api.g_miss_date;

469: l_d_attribute(6) := fnd_api.g_miss_date;
470: l_d_attribute(7) := fnd_api.g_miss_date;
471: l_d_attribute(8) := fnd_api.g_miss_date;
472: l_d_attribute(9) := fnd_api.g_miss_date;
473: l_d_attribute(10) := fnd_api.g_miss_date;
474: l_n_attribute(1) := fnd_api.g_miss_num;
475: l_n_attribute(2) := fnd_api.g_miss_num;
476: l_n_attribute(3) := fnd_api.g_miss_num;
477: l_n_attribute(4) := fnd_api.g_miss_num;

Line 474: l_n_attribute(1) := fnd_api.g_miss_num;

470: l_d_attribute(7) := fnd_api.g_miss_date;
471: l_d_attribute(8) := fnd_api.g_miss_date;
472: l_d_attribute(9) := fnd_api.g_miss_date;
473: l_d_attribute(10) := fnd_api.g_miss_date;
474: l_n_attribute(1) := fnd_api.g_miss_num;
475: l_n_attribute(2) := fnd_api.g_miss_num;
476: l_n_attribute(3) := fnd_api.g_miss_num;
477: l_n_attribute(4) := fnd_api.g_miss_num;
478: l_n_attribute(5) := fnd_api.g_miss_num;

Line 475: l_n_attribute(2) := fnd_api.g_miss_num;

471: l_d_attribute(8) := fnd_api.g_miss_date;
472: l_d_attribute(9) := fnd_api.g_miss_date;
473: l_d_attribute(10) := fnd_api.g_miss_date;
474: l_n_attribute(1) := fnd_api.g_miss_num;
475: l_n_attribute(2) := fnd_api.g_miss_num;
476: l_n_attribute(3) := fnd_api.g_miss_num;
477: l_n_attribute(4) := fnd_api.g_miss_num;
478: l_n_attribute(5) := fnd_api.g_miss_num;
479: l_n_attribute(6) := fnd_api.g_miss_num;

Line 476: l_n_attribute(3) := fnd_api.g_miss_num;

472: l_d_attribute(9) := fnd_api.g_miss_date;
473: l_d_attribute(10) := fnd_api.g_miss_date;
474: l_n_attribute(1) := fnd_api.g_miss_num;
475: l_n_attribute(2) := fnd_api.g_miss_num;
476: l_n_attribute(3) := fnd_api.g_miss_num;
477: l_n_attribute(4) := fnd_api.g_miss_num;
478: l_n_attribute(5) := fnd_api.g_miss_num;
479: l_n_attribute(6) := fnd_api.g_miss_num;
480: l_n_attribute(7) := fnd_api.g_miss_num;

Line 477: l_n_attribute(4) := fnd_api.g_miss_num;

473: l_d_attribute(10) := fnd_api.g_miss_date;
474: l_n_attribute(1) := fnd_api.g_miss_num;
475: l_n_attribute(2) := fnd_api.g_miss_num;
476: l_n_attribute(3) := fnd_api.g_miss_num;
477: l_n_attribute(4) := fnd_api.g_miss_num;
478: l_n_attribute(5) := fnd_api.g_miss_num;
479: l_n_attribute(6) := fnd_api.g_miss_num;
480: l_n_attribute(7) := fnd_api.g_miss_num;
481: l_n_attribute(8) := fnd_api.g_miss_num;

Line 478: l_n_attribute(5) := fnd_api.g_miss_num;

474: l_n_attribute(1) := fnd_api.g_miss_num;
475: l_n_attribute(2) := fnd_api.g_miss_num;
476: l_n_attribute(3) := fnd_api.g_miss_num;
477: l_n_attribute(4) := fnd_api.g_miss_num;
478: l_n_attribute(5) := fnd_api.g_miss_num;
479: l_n_attribute(6) := fnd_api.g_miss_num;
480: l_n_attribute(7) := fnd_api.g_miss_num;
481: l_n_attribute(8) := fnd_api.g_miss_num;
482: l_n_attribute(9) := fnd_api.g_miss_num;

Line 479: l_n_attribute(6) := fnd_api.g_miss_num;

475: l_n_attribute(2) := fnd_api.g_miss_num;
476: l_n_attribute(3) := fnd_api.g_miss_num;
477: l_n_attribute(4) := fnd_api.g_miss_num;
478: l_n_attribute(5) := fnd_api.g_miss_num;
479: l_n_attribute(6) := fnd_api.g_miss_num;
480: l_n_attribute(7) := fnd_api.g_miss_num;
481: l_n_attribute(8) := fnd_api.g_miss_num;
482: l_n_attribute(9) := fnd_api.g_miss_num;
483: l_n_attribute(10) := fnd_api.g_miss_num;

Line 480: l_n_attribute(7) := fnd_api.g_miss_num;

476: l_n_attribute(3) := fnd_api.g_miss_num;
477: l_n_attribute(4) := fnd_api.g_miss_num;
478: l_n_attribute(5) := fnd_api.g_miss_num;
479: l_n_attribute(6) := fnd_api.g_miss_num;
480: l_n_attribute(7) := fnd_api.g_miss_num;
481: l_n_attribute(8) := fnd_api.g_miss_num;
482: l_n_attribute(9) := fnd_api.g_miss_num;
483: l_n_attribute(10) := fnd_api.g_miss_num;
484: END IF;

Line 481: l_n_attribute(8) := fnd_api.g_miss_num;

477: l_n_attribute(4) := fnd_api.g_miss_num;
478: l_n_attribute(5) := fnd_api.g_miss_num;
479: l_n_attribute(6) := fnd_api.g_miss_num;
480: l_n_attribute(7) := fnd_api.g_miss_num;
481: l_n_attribute(8) := fnd_api.g_miss_num;
482: l_n_attribute(9) := fnd_api.g_miss_num;
483: l_n_attribute(10) := fnd_api.g_miss_num;
484: END IF;
485: */

Line 482: l_n_attribute(9) := fnd_api.g_miss_num;

478: l_n_attribute(5) := fnd_api.g_miss_num;
479: l_n_attribute(6) := fnd_api.g_miss_num;
480: l_n_attribute(7) := fnd_api.g_miss_num;
481: l_n_attribute(8) := fnd_api.g_miss_num;
482: l_n_attribute(9) := fnd_api.g_miss_num;
483: l_n_attribute(10) := fnd_api.g_miss_num;
484: END IF;
485: */
486:

Line 483: l_n_attribute(10) := fnd_api.g_miss_num;

479: l_n_attribute(6) := fnd_api.g_miss_num;
480: l_n_attribute(7) := fnd_api.g_miss_num;
481: l_n_attribute(8) := fnd_api.g_miss_num;
482: l_n_attribute(9) := fnd_api.g_miss_num;
483: l_n_attribute(10) := fnd_api.g_miss_num;
484: END IF;
485: */
486:
487: -- Initialize the server side flex validation API with context value

Line 770: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN

766: END IF;
767:
768:
769:
770: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN
771: RAISE NO_DATA_FOUND;
772: END IF;
773:
774: end if;

Line 839: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN

835: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'EAM_ASSET_ATTR_PVT.Update_Row return status=' || l_return_status);
836: END IF;
837:
838:
839: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN
840: RAISE NO_DATA_FOUND;
841: END IF;
842:
843: END IF;

Line 939: IF fnd_api.to_boolean(p_commit) THEN

935:
936:
937: -- End of API body.
938: -- Standard check of p_commit.
939: IF fnd_api.to_boolean(p_commit) THEN
940: COMMIT WORK;
941: END IF;
942:
943: -- Standard call to get message count and if count is 1, get message info.

Line 945: p_encoded => fnd_api.g_false

941: END IF;
942:
943: -- Standard call to get message count and if count is 1, get message info.
944: fnd_msg_pub.count_and_get(
945: p_encoded => fnd_api.g_false
946: ,p_count => x_msg_count
947: ,p_data => x_msg_data);
948:
949: IF (l_plog) THEN

Line 979: x_return_status := fnd_api.g_ret_sts_error;

975: -- AND meavi.attribute_category = attr_group.attribute_category
976: AND meavi.process_status = 'E'
977: AND meavi.error_number IS NOT NULL);
978:
979: x_return_status := fnd_api.g_ret_sts_error;
980: fnd_msg_pub.count_and_get(
981: p_encoded => fnd_api.g_false
982: ,p_count => x_msg_count
983: ,p_data => x_msg_data);

Line 981: p_encoded => fnd_api.g_false

977: AND meavi.error_number IS NOT NULL);
978:
979: x_return_status := fnd_api.g_ret_sts_error;
980: fnd_msg_pub.count_and_get(
981: p_encoded => fnd_api.g_false
982: ,p_count => x_msg_count
983: ,p_data => x_msg_data);
984:
985: IF (l_exlog) THEN

Line 989: WHEN fnd_api.g_exc_error THEN

985: IF (l_exlog) THEN
986: -- bug 2834438
987: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION attr_import_failed.');
988: END IF;
989: WHEN fnd_api.g_exc_error THEN
990: -- ROLLBACK TO import_asset_attr_values_pvt;
991: x_return_status := fnd_api.g_ret_sts_error;
992: fnd_msg_pub.count_and_get(
993: p_encoded => fnd_api.g_false

Line 991: x_return_status := fnd_api.g_ret_sts_error;

987: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION attr_import_failed.');
988: END IF;
989: WHEN fnd_api.g_exc_error THEN
990: -- ROLLBACK TO import_asset_attr_values_pvt;
991: x_return_status := fnd_api.g_ret_sts_error;
992: fnd_msg_pub.count_and_get(
993: p_encoded => fnd_api.g_false
994: ,p_count => x_msg_count
995: ,p_data => x_msg_data);

Line 993: p_encoded => fnd_api.g_false

989: WHEN fnd_api.g_exc_error THEN
990: -- ROLLBACK TO import_asset_attr_values_pvt;
991: x_return_status := fnd_api.g_ret_sts_error;
992: fnd_msg_pub.count_and_get(
993: p_encoded => fnd_api.g_false
994: ,p_count => x_msg_count
995: ,p_data => x_msg_data);
996:
997: IF (l_exlog) THEN

Line 999: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION fnd_api.g_exc_error.');

995: ,p_data => x_msg_data);
996:
997: IF (l_exlog) THEN
998: -- bug 2834438
999: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION fnd_api.g_exc_error.');
1000: END IF;
1001:
1002: WHEN fnd_api.g_exc_unexpected_error THEN
1003: -- ROLLBACK TO import_asset_attr_values_pvt;

Line 1002: WHEN fnd_api.g_exc_unexpected_error THEN

998: -- bug 2834438
999: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION fnd_api.g_exc_error.');
1000: END IF;
1001:
1002: WHEN fnd_api.g_exc_unexpected_error THEN
1003: -- ROLLBACK TO import_asset_attr_values_pvt;
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;
1005: fnd_msg_pub.count_and_get(
1006: p_encoded => fnd_api.g_false

Line 1004: x_return_status := fnd_api.g_ret_sts_unexp_error;

1000: END IF;
1001:
1002: WHEN fnd_api.g_exc_unexpected_error THEN
1003: -- ROLLBACK TO import_asset_attr_values_pvt;
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;
1005: fnd_msg_pub.count_and_get(
1006: p_encoded => fnd_api.g_false
1007: ,p_count => x_msg_count
1008: ,p_data => x_msg_data);

Line 1006: p_encoded => fnd_api.g_false

1002: WHEN fnd_api.g_exc_unexpected_error THEN
1003: -- ROLLBACK TO import_asset_attr_values_pvt;
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;
1005: fnd_msg_pub.count_and_get(
1006: p_encoded => fnd_api.g_false
1007: ,p_count => x_msg_count
1008: ,p_data => x_msg_data);
1009:
1010: IF (l_exlog) THEN

Line 1012: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION fnd_api.g_exc_unexpected_error.');

1008: ,p_data => x_msg_data);
1009:
1010: IF (l_exlog) THEN
1011: -- bug 2834438
1012: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION fnd_api.g_exc_unexpected_error.');
1013: END IF;
1014:
1015: WHEN OTHERS THEN
1016: -- ROLLBACK TO import_asset_attr_values_pvt;

Line 1017: x_return_status := fnd_api.g_ret_sts_unexp_error;

1013: END IF;
1014:
1015: WHEN OTHERS THEN
1016: -- ROLLBACK TO import_asset_attr_values_pvt;
1017: x_return_status := fnd_api.g_ret_sts_unexp_error;
1018:
1019: IF fnd_msg_pub.check_msg_level(
1020: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1021: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

Line 1025: p_encoded => fnd_api.g_false

1021: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1022: END IF;
1023:
1024: fnd_msg_pub.count_and_get(
1025: p_encoded => fnd_api.g_false
1026: ,p_count => x_msg_count
1027: ,p_data => x_msg_data);
1028:
1029: IF (l_exlog) THEN