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_NUMBER_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_INVENTORY_ITEM_ID IN NUMBER

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_INVENTORY_ITEM_ID IN NUMBER
18: -- P_SERIAL_NUMBER IN VARCHAR2
19: -- P_START_DATE_ACTIVE IN DATE

Line 80: ELSIF (p_new_value = fnd_api.g_miss_char) THEN

76: result := p_new_value;
77: ELSE
78: IF (p_new_value is null) THEN
79: result := p_old_value;
80: ELSIF (p_new_value = fnd_api.g_miss_char) THEN
81: result := null;
82: ELSE
83: result := p_new_value;
84: END IF;

Line 98: ELSIF (p_new_value = fnd_api.g_miss_date) THEN

94: result := p_new_value;
95: ELSE
96: IF (p_new_value is null) THEN
97: result := p_old_value;
98: ELSIF (p_new_value = fnd_api.g_miss_date) THEN
99: result := null;
100: ELSE
101: result := p_new_value;
102: END IF;

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

106:
107:
108: PROCEDURE INSERT_ROW(
109: P_API_VERSION IN NUMBER,
110: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
111: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
112: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: P_INVENTORY_ITEM_ID NUMBER,
114: P_SERIAL_NUMBER VARCHAR2,

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

107:
108: PROCEDURE INSERT_ROW(
109: P_API_VERSION IN NUMBER,
110: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
111: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
112: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: P_INVENTORY_ITEM_ID NUMBER,
114: P_SERIAL_NUMBER VARCHAR2,
115: P_INSTANCE_NUMBER VARCHAR2,

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

108: PROCEDURE INSERT_ROW(
109: P_API_VERSION IN NUMBER,
110: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
111: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
112: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: P_INVENTORY_ITEM_ID NUMBER,
114: P_SERIAL_NUMBER VARCHAR2,
115: P_INSTANCE_NUMBER VARCHAR2,
116: P_INSTANCE_DESCRIPTION VARCHAR2,

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

209: -- Standard Start of API savepoint
210: SAVEPOINT insert_row;
211:
212: -- Standard call to check for call compatibility.
213: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
214: RAISE fnd_api.g_exc_unexpected_error;
215: END IF;
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 214: RAISE fnd_api.g_exc_unexpected_error;

210: SAVEPOINT insert_row;
211:
212: -- Standard call to check for call compatibility.
213: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
214: RAISE fnd_api.g_exc_unexpected_error;
215: END IF;
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 218: IF fnd_api.to_boolean(p_init_msg_list) THEN

214: RAISE fnd_api.g_exc_unexpected_error;
215: END IF;
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF fnd_api.to_boolean(p_init_msg_list) THEN
219: fnd_msg_pub.initialize;
220: END IF;
221:
222: -- Initialize API return status to success

Line 223: x_return_status := fnd_api.g_ret_sts_success;

219: fnd_msg_pub.initialize;
220: END IF;
221:
222: -- Initialize API return status to success
223: x_return_status := fnd_api.g_ret_sts_success;
224:
225: -- API body
226:
227: l_instance_rec.instance_number := p_instance_number;

Line 332: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;

328:
329:
330: if P_FA_SYNC_FLAG = 'Y' then
331: l_asset_assignment_tbl(1).fa_sync_flag := 'Y';
332: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;
333: else
334: l_asset_assignment_tbl(1).fa_sync_flag := 'N';
335: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;
336: end if;

Line 335: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;

331: l_asset_assignment_tbl(1).fa_sync_flag := 'Y';
332: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;
333: else
334: l_asset_assignment_tbl(1).fa_sync_flag := 'N';
335: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;
336: end if;
337:
338: select fb.book_type_code
339: into l_asset_assignment_tbl(1).fa_book_type_code

Line 367: ,p_commit => fnd_api.g_false

363:
364: csi_item_instance_pub.create_item_instance
365: (
366: p_api_version => 1.0
367: ,p_commit => fnd_api.g_false
368: ,p_init_msg_list => fnd_api.g_false
369: ,p_validation_level => fnd_api.g_valid_level_full
370: ,p_instance_rec => l_instance_rec
371: ,p_ext_attrib_values_tbl => l_ext_attrib_values_tbl

Line 368: ,p_init_msg_list => fnd_api.g_false

364: csi_item_instance_pub.create_item_instance
365: (
366: p_api_version => 1.0
367: ,p_commit => fnd_api.g_false
368: ,p_init_msg_list => fnd_api.g_false
369: ,p_validation_level => fnd_api.g_valid_level_full
370: ,p_instance_rec => l_instance_rec
371: ,p_ext_attrib_values_tbl => l_ext_attrib_values_tbl
372: ,p_party_tbl => l_party_tbl

Line 369: ,p_validation_level => fnd_api.g_valid_level_full

365: (
366: p_api_version => 1.0
367: ,p_commit => fnd_api.g_false
368: ,p_init_msg_list => fnd_api.g_false
369: ,p_validation_level => fnd_api.g_valid_level_full
370: ,p_instance_rec => l_instance_rec
371: ,p_ext_attrib_values_tbl => l_ext_attrib_values_tbl
372: ,p_party_tbl => l_party_tbl
373: ,p_account_tbl => l_account_tbl

Line 383: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

379: ,x_msg_count => x_msg_count
380: ,x_msg_data => x_msg_data
381: );
382:
383: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
384: l_msg_index := 1;
385: l_msg_count := x_msg_count;
386: WHILE l_msg_count > 0 LOOP
387: x_msg_data := FND_MSG_PUB.GET

Line 389: FND_API.G_FALSE );

385: l_msg_count := x_msg_count;
386: WHILE l_msg_count > 0 LOOP
387: x_msg_data := FND_MSG_PUB.GET
388: ( l_msg_index,
389: FND_API.G_FALSE );
390: -- csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
391: -- csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
392: l_msg_index := l_msg_index + 1;
393: l_msg_count := l_msg_count - 1;

Line 396: RAISE FND_API.G_EXC_ERROR;

392: l_msg_index := l_msg_index + 1;
393: l_msg_count := l_msg_count - 1;
394: END LOOP;
395:
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398:
399: x_object_id := l_instance_rec.instance_id;
400:

Line 409: IF fnd_api.to_boolean(p_commit) THEN

405: ,p_instance_id => l_instance_rec.instance_id
406: );
407:
408: -- Standard check of p_commit.
409: IF fnd_api.to_boolean(p_commit) THEN
410: COMMIT WORK;
411: END IF;
412:
413: -- Standard call to get message count and if count is 1, get message info.

Line 416: WHEN fnd_api.g_exc_error THEN

412:
413: -- Standard call to get message count and if count is 1, get message info.
414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: ROLLBACK TO insert_row;
418: x_return_status := fnd_api.g_ret_sts_error;
419: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
420: WHEN fnd_api.g_exc_unexpected_error THEN

Line 418: x_return_status := fnd_api.g_ret_sts_error;

414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: ROLLBACK TO insert_row;
418: x_return_status := fnd_api.g_ret_sts_error;
419: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
420: WHEN fnd_api.g_exc_unexpected_error THEN
421: ROLLBACK TO insert_row;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 420: WHEN fnd_api.g_exc_unexpected_error THEN

416: WHEN fnd_api.g_exc_error THEN
417: ROLLBACK TO insert_row;
418: x_return_status := fnd_api.g_ret_sts_error;
419: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
420: WHEN fnd_api.g_exc_unexpected_error THEN
421: ROLLBACK TO insert_row;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: /*fnd_msg_pub.count_and_get(
424: p_count => x_msg_count

Line 422: x_return_status := fnd_api.g_ret_sts_unexp_error;

418: x_return_status := fnd_api.g_ret_sts_error;
419: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
420: WHEN fnd_api.g_exc_unexpected_error THEN
421: ROLLBACK TO insert_row;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: /*fnd_msg_pub.count_and_get(
424: p_count => x_msg_count
425: ,p_data => x_msg_data);*/
426: WHEN OTHERS THEN

Line 428: x_return_status := fnd_api.g_ret_sts_unexp_error;

424: p_count => x_msg_count
425: ,p_data => x_msg_data);*/
426: WHEN OTHERS THEN
427: ROLLBACK TO insert_row;
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429:
430: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
431: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
432: END IF;

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

439:
440:
441: PROCEDURE UPDATE_ROW(
442: P_API_VERSION IN NUMBER,
443: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
444: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
445: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
446: p_instance_id IN NUMBER,
447: P_INSTANCE_DESCRIPTION VARCHAR2,

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

440:
441: PROCEDURE UPDATE_ROW(
442: P_API_VERSION IN NUMBER,
443: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
444: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
445: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
446: p_instance_id IN NUMBER,
447: P_INSTANCE_DESCRIPTION VARCHAR2,
448: P_CATEGORY_ID NUMBER,

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

441: PROCEDURE UPDATE_ROW(
442: P_API_VERSION IN NUMBER,
443: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
444: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
445: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
446: p_instance_id IN NUMBER,
447: P_INSTANCE_DESCRIPTION VARCHAR2,
448: P_CATEGORY_ID NUMBER,
449: P_PN_LOCATION_ID NUMBER,

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

535: -- Standard Start of API savepoint
536: SAVEPOINT update_row;
537:
538: -- Standard call to check for call compatibility.
539: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
540: RAISE fnd_api.g_exc_unexpected_error;
541: END IF;
542:
543: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 540: RAISE fnd_api.g_exc_unexpected_error;

536: SAVEPOINT update_row;
537:
538: -- Standard call to check for call compatibility.
539: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
540: RAISE fnd_api.g_exc_unexpected_error;
541: END IF;
542:
543: -- Initialize message list if p_init_msg_list is set to TRUE.
544: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 544: IF fnd_api.to_boolean(p_init_msg_list) THEN

540: RAISE fnd_api.g_exc_unexpected_error;
541: END IF;
542:
543: -- Initialize message list if p_init_msg_list is set to TRUE.
544: IF fnd_api.to_boolean(p_init_msg_list) THEN
545: fnd_msg_pub.initialize;
546: END IF;
547:
548: -- Initialize API return status to success

Line 549: x_return_status := fnd_api.g_ret_sts_success;

545: fnd_msg_pub.initialize;
546: END IF;
547:
548: -- Initialize API return status to success
549: x_return_status := fnd_api.g_ret_sts_success;
550:
551: -- API body
552:
553: --csi_gen_utility_pvt.put_line('EAM: Start of update_row, Active End date is : '||to_char(p_active_end_date,'dd-mon-yy hh24:mi:ss'));

Line 566: l_instance_rec.location_type_code := actual_value_char(p_from_public_api, p_location_type_code, FND_API.G_MISS_CHAR);

562:
563: l_instance_rec.object_version_number := l_object_version_number; --replace
564:
565:
566: l_instance_rec.location_type_code := actual_value_char(p_from_public_api, p_location_type_code, FND_API.G_MISS_CHAR);
567: l_instance_rec.location_id := actual_value_char(p_from_public_api, p_location_id,FND_API.G_MISS_NUM);
568: l_instance_rec.instance_description := actual_value_char(p_from_public_api, p_instance_description,FND_API.G_MISS_CHAR);
569:
570: l_instance_rec.instance_number := actual_value_char(p_from_public_api, p_instance_number,FND_API.G_MISS_CHAR);

Line 567: l_instance_rec.location_id := actual_value_char(p_from_public_api, p_location_id,FND_API.G_MISS_NUM);

563: l_instance_rec.object_version_number := l_object_version_number; --replace
564:
565:
566: l_instance_rec.location_type_code := actual_value_char(p_from_public_api, p_location_type_code, FND_API.G_MISS_CHAR);
567: l_instance_rec.location_id := actual_value_char(p_from_public_api, p_location_id,FND_API.G_MISS_NUM);
568: l_instance_rec.instance_description := actual_value_char(p_from_public_api, p_instance_description,FND_API.G_MISS_CHAR);
569:
570: l_instance_rec.instance_number := actual_value_char(p_from_public_api, p_instance_number,FND_API.G_MISS_CHAR);
571: l_instance_rec.context := actual_value_char(p_from_public_api, P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR);

Line 568: l_instance_rec.instance_description := actual_value_char(p_from_public_api, p_instance_description,FND_API.G_MISS_CHAR);

564:
565:
566: l_instance_rec.location_type_code := actual_value_char(p_from_public_api, p_location_type_code, FND_API.G_MISS_CHAR);
567: l_instance_rec.location_id := actual_value_char(p_from_public_api, p_location_id,FND_API.G_MISS_NUM);
568: l_instance_rec.instance_description := actual_value_char(p_from_public_api, p_instance_description,FND_API.G_MISS_CHAR);
569:
570: l_instance_rec.instance_number := actual_value_char(p_from_public_api, p_instance_number,FND_API.G_MISS_CHAR);
571: l_instance_rec.context := actual_value_char(p_from_public_api, P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR);
572: l_instance_rec.attribute1 := actual_value_char(p_from_public_api, P_ATTRIBUTE1,FND_API.G_MISS_CHAR);

Line 570: l_instance_rec.instance_number := actual_value_char(p_from_public_api, p_instance_number,FND_API.G_MISS_CHAR);

566: l_instance_rec.location_type_code := actual_value_char(p_from_public_api, p_location_type_code, FND_API.G_MISS_CHAR);
567: l_instance_rec.location_id := actual_value_char(p_from_public_api, p_location_id,FND_API.G_MISS_NUM);
568: l_instance_rec.instance_description := actual_value_char(p_from_public_api, p_instance_description,FND_API.G_MISS_CHAR);
569:
570: l_instance_rec.instance_number := actual_value_char(p_from_public_api, p_instance_number,FND_API.G_MISS_CHAR);
571: l_instance_rec.context := actual_value_char(p_from_public_api, P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR);
572: l_instance_rec.attribute1 := actual_value_char(p_from_public_api, P_ATTRIBUTE1,FND_API.G_MISS_CHAR);
573: l_instance_rec.attribute2 := actual_value_char(p_from_public_api, P_ATTRIBUTE2,FND_API.G_MISS_CHAR);
574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);

Line 571: l_instance_rec.context := actual_value_char(p_from_public_api, P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR);

567: l_instance_rec.location_id := actual_value_char(p_from_public_api, p_location_id,FND_API.G_MISS_NUM);
568: l_instance_rec.instance_description := actual_value_char(p_from_public_api, p_instance_description,FND_API.G_MISS_CHAR);
569:
570: l_instance_rec.instance_number := actual_value_char(p_from_public_api, p_instance_number,FND_API.G_MISS_CHAR);
571: l_instance_rec.context := actual_value_char(p_from_public_api, P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR);
572: l_instance_rec.attribute1 := actual_value_char(p_from_public_api, P_ATTRIBUTE1,FND_API.G_MISS_CHAR);
573: l_instance_rec.attribute2 := actual_value_char(p_from_public_api, P_ATTRIBUTE2,FND_API.G_MISS_CHAR);
574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);
575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);

Line 572: l_instance_rec.attribute1 := actual_value_char(p_from_public_api, P_ATTRIBUTE1,FND_API.G_MISS_CHAR);

568: l_instance_rec.instance_description := actual_value_char(p_from_public_api, p_instance_description,FND_API.G_MISS_CHAR);
569:
570: l_instance_rec.instance_number := actual_value_char(p_from_public_api, p_instance_number,FND_API.G_MISS_CHAR);
571: l_instance_rec.context := actual_value_char(p_from_public_api, P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR);
572: l_instance_rec.attribute1 := actual_value_char(p_from_public_api, P_ATTRIBUTE1,FND_API.G_MISS_CHAR);
573: l_instance_rec.attribute2 := actual_value_char(p_from_public_api, P_ATTRIBUTE2,FND_API.G_MISS_CHAR);
574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);
575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);
576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);

Line 573: l_instance_rec.attribute2 := actual_value_char(p_from_public_api, P_ATTRIBUTE2,FND_API.G_MISS_CHAR);

569:
570: l_instance_rec.instance_number := actual_value_char(p_from_public_api, p_instance_number,FND_API.G_MISS_CHAR);
571: l_instance_rec.context := actual_value_char(p_from_public_api, P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR);
572: l_instance_rec.attribute1 := actual_value_char(p_from_public_api, P_ATTRIBUTE1,FND_API.G_MISS_CHAR);
573: l_instance_rec.attribute2 := actual_value_char(p_from_public_api, P_ATTRIBUTE2,FND_API.G_MISS_CHAR);
574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);
575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);
576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);
577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);

Line 574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);

570: l_instance_rec.instance_number := actual_value_char(p_from_public_api, p_instance_number,FND_API.G_MISS_CHAR);
571: l_instance_rec.context := actual_value_char(p_from_public_api, P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR);
572: l_instance_rec.attribute1 := actual_value_char(p_from_public_api, P_ATTRIBUTE1,FND_API.G_MISS_CHAR);
573: l_instance_rec.attribute2 := actual_value_char(p_from_public_api, P_ATTRIBUTE2,FND_API.G_MISS_CHAR);
574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);
575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);
576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);
577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);
578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);

Line 575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);

571: l_instance_rec.context := actual_value_char(p_from_public_api, P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR);
572: l_instance_rec.attribute1 := actual_value_char(p_from_public_api, P_ATTRIBUTE1,FND_API.G_MISS_CHAR);
573: l_instance_rec.attribute2 := actual_value_char(p_from_public_api, P_ATTRIBUTE2,FND_API.G_MISS_CHAR);
574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);
575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);
576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);
577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);
578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);
579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);

Line 576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);

572: l_instance_rec.attribute1 := actual_value_char(p_from_public_api, P_ATTRIBUTE1,FND_API.G_MISS_CHAR);
573: l_instance_rec.attribute2 := actual_value_char(p_from_public_api, P_ATTRIBUTE2,FND_API.G_MISS_CHAR);
574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);
575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);
576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);
577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);
578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);
579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);
580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);

Line 577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);

573: l_instance_rec.attribute2 := actual_value_char(p_from_public_api, P_ATTRIBUTE2,FND_API.G_MISS_CHAR);
574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);
575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);
576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);
577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);
578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);
579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);
580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);
581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);

Line 578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);

574: l_instance_rec.attribute3 := actual_value_char(p_from_public_api, P_ATTRIBUTE3,FND_API.G_MISS_CHAR);
575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);
576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);
577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);
578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);
579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);
580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);
581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);
582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);

Line 579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);

575: l_instance_rec.attribute4 := actual_value_char(p_from_public_api, P_ATTRIBUTE4,FND_API.G_MISS_CHAR);
576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);
577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);
578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);
579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);
580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);
581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);
582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);
583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);

Line 580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);

576: l_instance_rec.attribute5 := actual_value_char(p_from_public_api, P_ATTRIBUTE5,FND_API.G_MISS_CHAR);
577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);
578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);
579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);
580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);
581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);
582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);
583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);
584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);

Line 581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);

577: l_instance_rec.attribute6 := actual_value_char(p_from_public_api, P_ATTRIBUTE6,FND_API.G_MISS_CHAR);
578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);
579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);
580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);
581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);
582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);
583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);
584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);
585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);

Line 582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);

578: l_instance_rec.attribute7 := actual_value_char(p_from_public_api, P_ATTRIBUTE7,FND_API.G_MISS_CHAR);
579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);
580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);
581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);
582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);
583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);
584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);
585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);
586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);

Line 583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);

579: l_instance_rec.attribute8 := actual_value_char(p_from_public_api, P_ATTRIBUTE8,FND_API.G_MISS_CHAR);
580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);
581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);
582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);
583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);
584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);
585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);
586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);
587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);

Line 584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);

580: l_instance_rec.attribute9 := actual_value_char(p_from_public_api, P_ATTRIBUTE9,FND_API.G_MISS_CHAR);
581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);
582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);
583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);
584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);
585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);
586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);
587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);
588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);

Line 585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);

581: l_instance_rec.attribute10 := actual_value_char(p_from_public_api, P_ATTRIBUTE10,FND_API.G_MISS_CHAR);
582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);
583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);
584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);
585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);
586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);
587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);
588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);
589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);

Line 586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);

582: l_instance_rec.attribute11 := actual_value_char(p_from_public_api, P_ATTRIBUTE11,FND_API.G_MISS_CHAR);
583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);
584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);
585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);
586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);
587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);
588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);
589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);
590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);

Line 587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);

583: l_instance_rec.attribute12 := actual_value_char(p_from_public_api, P_ATTRIBUTE12,FND_API.G_MISS_CHAR);
584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);
585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);
586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);
587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);
588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);
589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);
590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);
591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);

Line 588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);

584: l_instance_rec.attribute13 := actual_value_char(p_from_public_api, P_ATTRIBUTE13,FND_API.G_MISS_CHAR);
585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);
586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);
587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);
588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);
589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);
590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);
591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);
592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);

Line 589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);

585: l_instance_rec.attribute14 := actual_value_char(p_from_public_api, P_ATTRIBUTE14,FND_API.G_MISS_CHAR);
586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);
587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);
588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);
589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);
590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);
591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);
592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);
593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);

Line 590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);

586: l_instance_rec.attribute15 := actual_value_char(p_from_public_api, P_ATTRIBUTE15,FND_API.G_MISS_CHAR);
587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);
588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);
589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);
590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);
591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);
592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);
593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);
594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);

Line 591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);

587: l_instance_rec.attribute16 := actual_value_char(p_from_public_api, P_ATTRIBUTE16,FND_API.G_MISS_CHAR);
588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);
589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);
590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);
591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);
592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);
593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);
594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);
595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);

Line 592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);

588: l_instance_rec.attribute17 := actual_value_char(p_from_public_api, P_ATTRIBUTE17,FND_API.G_MISS_CHAR);
589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);
590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);
591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);
592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);
593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);
594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);
595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);
596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);

Line 593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);

589: l_instance_rec.attribute18 := actual_value_char(p_from_public_api, P_ATTRIBUTE18,FND_API.G_MISS_CHAR);
590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);
591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);
592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);
593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);
594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);
595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);
596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);
597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);

Line 594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);

590: l_instance_rec.attribute19 := actual_value_char(p_from_public_api, P_ATTRIBUTE19,FND_API.G_MISS_CHAR);
591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);
592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);
593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);
594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);
595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);
596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);
597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);
598: l_instance_rec.attribute27 := actual_value_char(p_from_public_api, P_ATTRIBUTE27,FND_API.G_MISS_CHAR);

Line 595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);

591: l_instance_rec.attribute20 := actual_value_char(p_from_public_api, P_ATTRIBUTE20,FND_API.G_MISS_CHAR);
592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);
593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);
594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);
595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);
596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);
597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);
598: l_instance_rec.attribute27 := actual_value_char(p_from_public_api, P_ATTRIBUTE27,FND_API.G_MISS_CHAR);
599: l_instance_rec.attribute28 := actual_value_char(p_from_public_api, P_ATTRIBUTE28,FND_API.G_MISS_CHAR);

Line 596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);

592: l_instance_rec.attribute21 := actual_value_char(p_from_public_api, P_ATTRIBUTE21,FND_API.G_MISS_CHAR);
593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);
594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);
595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);
596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);
597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);
598: l_instance_rec.attribute27 := actual_value_char(p_from_public_api, P_ATTRIBUTE27,FND_API.G_MISS_CHAR);
599: l_instance_rec.attribute28 := actual_value_char(p_from_public_api, P_ATTRIBUTE28,FND_API.G_MISS_CHAR);
600: l_instance_rec.attribute29 := actual_value_char(p_from_public_api, P_ATTRIBUTE29,FND_API.G_MISS_CHAR);

Line 597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);

593: l_instance_rec.attribute22 := actual_value_char(p_from_public_api, P_ATTRIBUTE22,FND_API.G_MISS_CHAR);
594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);
595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);
596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);
597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);
598: l_instance_rec.attribute27 := actual_value_char(p_from_public_api, P_ATTRIBUTE27,FND_API.G_MISS_CHAR);
599: l_instance_rec.attribute28 := actual_value_char(p_from_public_api, P_ATTRIBUTE28,FND_API.G_MISS_CHAR);
600: l_instance_rec.attribute29 := actual_value_char(p_from_public_api, P_ATTRIBUTE29,FND_API.G_MISS_CHAR);
601: l_instance_rec.attribute30 := actual_value_char(p_from_public_api, P_ATTRIBUTE30,FND_API.G_MISS_CHAR);

Line 598: l_instance_rec.attribute27 := actual_value_char(p_from_public_api, P_ATTRIBUTE27,FND_API.G_MISS_CHAR);

594: l_instance_rec.attribute23 := actual_value_char(p_from_public_api, P_ATTRIBUTE23,FND_API.G_MISS_CHAR);
595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);
596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);
597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);
598: l_instance_rec.attribute27 := actual_value_char(p_from_public_api, P_ATTRIBUTE27,FND_API.G_MISS_CHAR);
599: l_instance_rec.attribute28 := actual_value_char(p_from_public_api, P_ATTRIBUTE28,FND_API.G_MISS_CHAR);
600: l_instance_rec.attribute29 := actual_value_char(p_from_public_api, P_ATTRIBUTE29,FND_API.G_MISS_CHAR);
601: l_instance_rec.attribute30 := actual_value_char(p_from_public_api, P_ATTRIBUTE30,FND_API.G_MISS_CHAR);
602:

Line 599: l_instance_rec.attribute28 := actual_value_char(p_from_public_api, P_ATTRIBUTE28,FND_API.G_MISS_CHAR);

595: l_instance_rec.attribute24 := actual_value_char(p_from_public_api, P_ATTRIBUTE24,FND_API.G_MISS_CHAR);
596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);
597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);
598: l_instance_rec.attribute27 := actual_value_char(p_from_public_api, P_ATTRIBUTE27,FND_API.G_MISS_CHAR);
599: l_instance_rec.attribute28 := actual_value_char(p_from_public_api, P_ATTRIBUTE28,FND_API.G_MISS_CHAR);
600: l_instance_rec.attribute29 := actual_value_char(p_from_public_api, P_ATTRIBUTE29,FND_API.G_MISS_CHAR);
601: l_instance_rec.attribute30 := actual_value_char(p_from_public_api, P_ATTRIBUTE30,FND_API.G_MISS_CHAR);
602:
603: l_instance_rec.maintainable_flag := actual_value_char(p_from_public_api, p_maintainable_flag,FND_API.G_MISS_CHAR);

Line 600: l_instance_rec.attribute29 := actual_value_char(p_from_public_api, P_ATTRIBUTE29,FND_API.G_MISS_CHAR);

596: l_instance_rec.attribute25 := actual_value_char(p_from_public_api, P_ATTRIBUTE25,FND_API.G_MISS_CHAR);
597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);
598: l_instance_rec.attribute27 := actual_value_char(p_from_public_api, P_ATTRIBUTE27,FND_API.G_MISS_CHAR);
599: l_instance_rec.attribute28 := actual_value_char(p_from_public_api, P_ATTRIBUTE28,FND_API.G_MISS_CHAR);
600: l_instance_rec.attribute29 := actual_value_char(p_from_public_api, P_ATTRIBUTE29,FND_API.G_MISS_CHAR);
601: l_instance_rec.attribute30 := actual_value_char(p_from_public_api, P_ATTRIBUTE30,FND_API.G_MISS_CHAR);
602:
603: l_instance_rec.maintainable_flag := actual_value_char(p_from_public_api, p_maintainable_flag,FND_API.G_MISS_CHAR);
604: l_instance_rec.network_asset_flag := actual_value_char(p_from_public_api, p_network_asset_flag,FND_API.G_MISS_CHAR);

Line 601: l_instance_rec.attribute30 := actual_value_char(p_from_public_api, P_ATTRIBUTE30,FND_API.G_MISS_CHAR);

597: l_instance_rec.attribute26 := actual_value_char(p_from_public_api, P_ATTRIBUTE26,FND_API.G_MISS_CHAR);
598: l_instance_rec.attribute27 := actual_value_char(p_from_public_api, P_ATTRIBUTE27,FND_API.G_MISS_CHAR);
599: l_instance_rec.attribute28 := actual_value_char(p_from_public_api, P_ATTRIBUTE28,FND_API.G_MISS_CHAR);
600: l_instance_rec.attribute29 := actual_value_char(p_from_public_api, P_ATTRIBUTE29,FND_API.G_MISS_CHAR);
601: l_instance_rec.attribute30 := actual_value_char(p_from_public_api, P_ATTRIBUTE30,FND_API.G_MISS_CHAR);
602:
603: l_instance_rec.maintainable_flag := actual_value_char(p_from_public_api, p_maintainable_flag,FND_API.G_MISS_CHAR);
604: l_instance_rec.network_asset_flag := actual_value_char(p_from_public_api, p_network_asset_flag,FND_API.G_MISS_CHAR);
605: l_instance_rec.pn_location_id := actual_value_char(p_from_public_api, p_pn_location_id,FND_API.G_MISS_NUM);

Line 603: l_instance_rec.maintainable_flag := actual_value_char(p_from_public_api, p_maintainable_flag,FND_API.G_MISS_CHAR);

599: l_instance_rec.attribute28 := actual_value_char(p_from_public_api, P_ATTRIBUTE28,FND_API.G_MISS_CHAR);
600: l_instance_rec.attribute29 := actual_value_char(p_from_public_api, P_ATTRIBUTE29,FND_API.G_MISS_CHAR);
601: l_instance_rec.attribute30 := actual_value_char(p_from_public_api, P_ATTRIBUTE30,FND_API.G_MISS_CHAR);
602:
603: l_instance_rec.maintainable_flag := actual_value_char(p_from_public_api, p_maintainable_flag,FND_API.G_MISS_CHAR);
604: l_instance_rec.network_asset_flag := actual_value_char(p_from_public_api, p_network_asset_flag,FND_API.G_MISS_CHAR);
605: l_instance_rec.pn_location_id := actual_value_char(p_from_public_api, p_pn_location_id,FND_API.G_MISS_NUM);
606: l_instance_rec.asset_criticality_code := actual_value_char(p_from_public_api, p_asset_criticality_code,FND_API.G_MISS_CHAR);
607: l_instance_rec.category_id := actual_value_char(p_from_public_api, p_category_id,FND_API.G_MISS_NUM);

Line 604: l_instance_rec.network_asset_flag := actual_value_char(p_from_public_api, p_network_asset_flag,FND_API.G_MISS_CHAR);

600: l_instance_rec.attribute29 := actual_value_char(p_from_public_api, P_ATTRIBUTE29,FND_API.G_MISS_CHAR);
601: l_instance_rec.attribute30 := actual_value_char(p_from_public_api, P_ATTRIBUTE30,FND_API.G_MISS_CHAR);
602:
603: l_instance_rec.maintainable_flag := actual_value_char(p_from_public_api, p_maintainable_flag,FND_API.G_MISS_CHAR);
604: l_instance_rec.network_asset_flag := actual_value_char(p_from_public_api, p_network_asset_flag,FND_API.G_MISS_CHAR);
605: l_instance_rec.pn_location_id := actual_value_char(p_from_public_api, p_pn_location_id,FND_API.G_MISS_NUM);
606: l_instance_rec.asset_criticality_code := actual_value_char(p_from_public_api, p_asset_criticality_code,FND_API.G_MISS_CHAR);
607: l_instance_rec.category_id := actual_value_char(p_from_public_api, p_category_id,FND_API.G_MISS_NUM);
608:

Line 605: l_instance_rec.pn_location_id := actual_value_char(p_from_public_api, p_pn_location_id,FND_API.G_MISS_NUM);

601: l_instance_rec.attribute30 := actual_value_char(p_from_public_api, P_ATTRIBUTE30,FND_API.G_MISS_CHAR);
602:
603: l_instance_rec.maintainable_flag := actual_value_char(p_from_public_api, p_maintainable_flag,FND_API.G_MISS_CHAR);
604: l_instance_rec.network_asset_flag := actual_value_char(p_from_public_api, p_network_asset_flag,FND_API.G_MISS_CHAR);
605: l_instance_rec.pn_location_id := actual_value_char(p_from_public_api, p_pn_location_id,FND_API.G_MISS_NUM);
606: l_instance_rec.asset_criticality_code := actual_value_char(p_from_public_api, p_asset_criticality_code,FND_API.G_MISS_CHAR);
607: l_instance_rec.category_id := actual_value_char(p_from_public_api, p_category_id,FND_API.G_MISS_NUM);
608:
609: l_instance_rec.equipment_gen_object_id := actual_value_char(p_from_public_api, p_equipment_gen_object_id,FND_API.G_MISS_NUM);

Line 606: l_instance_rec.asset_criticality_code := actual_value_char(p_from_public_api, p_asset_criticality_code,FND_API.G_MISS_CHAR);

602:
603: l_instance_rec.maintainable_flag := actual_value_char(p_from_public_api, p_maintainable_flag,FND_API.G_MISS_CHAR);
604: l_instance_rec.network_asset_flag := actual_value_char(p_from_public_api, p_network_asset_flag,FND_API.G_MISS_CHAR);
605: l_instance_rec.pn_location_id := actual_value_char(p_from_public_api, p_pn_location_id,FND_API.G_MISS_NUM);
606: l_instance_rec.asset_criticality_code := actual_value_char(p_from_public_api, p_asset_criticality_code,FND_API.G_MISS_CHAR);
607: l_instance_rec.category_id := actual_value_char(p_from_public_api, p_category_id,FND_API.G_MISS_NUM);
608:
609: l_instance_rec.equipment_gen_object_id := actual_value_char(p_from_public_api, p_equipment_gen_object_id,FND_API.G_MISS_NUM);
610: l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);

Line 607: l_instance_rec.category_id := actual_value_char(p_from_public_api, p_category_id,FND_API.G_MISS_NUM);

603: l_instance_rec.maintainable_flag := actual_value_char(p_from_public_api, p_maintainable_flag,FND_API.G_MISS_CHAR);
604: l_instance_rec.network_asset_flag := actual_value_char(p_from_public_api, p_network_asset_flag,FND_API.G_MISS_CHAR);
605: l_instance_rec.pn_location_id := actual_value_char(p_from_public_api, p_pn_location_id,FND_API.G_MISS_NUM);
606: l_instance_rec.asset_criticality_code := actual_value_char(p_from_public_api, p_asset_criticality_code,FND_API.G_MISS_CHAR);
607: l_instance_rec.category_id := actual_value_char(p_from_public_api, p_category_id,FND_API.G_MISS_NUM);
608:
609: l_instance_rec.equipment_gen_object_id := actual_value_char(p_from_public_api, p_equipment_gen_object_id,FND_API.G_MISS_NUM);
610: l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);
611: --p_instance_rec.start_date_active := actual_value_date(p_from_public_api, p_start_date_active,FND_API.G_MISS_DATE);

Line 609: l_instance_rec.equipment_gen_object_id := actual_value_char(p_from_public_api, p_equipment_gen_object_id,FND_API.G_MISS_NUM);

605: l_instance_rec.pn_location_id := actual_value_char(p_from_public_api, p_pn_location_id,FND_API.G_MISS_NUM);
606: l_instance_rec.asset_criticality_code := actual_value_char(p_from_public_api, p_asset_criticality_code,FND_API.G_MISS_CHAR);
607: l_instance_rec.category_id := actual_value_char(p_from_public_api, p_category_id,FND_API.G_MISS_NUM);
608:
609: l_instance_rec.equipment_gen_object_id := actual_value_char(p_from_public_api, p_equipment_gen_object_id,FND_API.G_MISS_NUM);
610: l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);
611: --p_instance_rec.start_date_active := actual_value_date(p_from_public_api, p_start_date_active,FND_API.G_MISS_DATE);
612:
613: if p_reactivate_asset = 'Y' then

Line 610: l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);

606: l_instance_rec.asset_criticality_code := actual_value_char(p_from_public_api, p_asset_criticality_code,FND_API.G_MISS_CHAR);
607: l_instance_rec.category_id := actual_value_char(p_from_public_api, p_category_id,FND_API.G_MISS_NUM);
608:
609: l_instance_rec.equipment_gen_object_id := actual_value_char(p_from_public_api, p_equipment_gen_object_id,FND_API.G_MISS_NUM);
610: l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);
611: --p_instance_rec.start_date_active := actual_value_date(p_from_public_api, p_start_date_active,FND_API.G_MISS_DATE);
612:
613: if p_reactivate_asset = 'Y' then
614: l_instance_rec.active_end_date := null;

Line 611: --p_instance_rec.start_date_active := actual_value_date(p_from_public_api, p_start_date_active,FND_API.G_MISS_DATE);

607: l_instance_rec.category_id := actual_value_char(p_from_public_api, p_category_id,FND_API.G_MISS_NUM);
608:
609: l_instance_rec.equipment_gen_object_id := actual_value_char(p_from_public_api, p_equipment_gen_object_id,FND_API.G_MISS_NUM);
610: l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);
611: --p_instance_rec.start_date_active := actual_value_date(p_from_public_api, p_start_date_active,FND_API.G_MISS_DATE);
612:
613: if p_reactivate_asset = 'Y' then
614: l_instance_rec.active_end_date := null;
615: else

Line 616: l_instance_rec.active_end_date := actual_value_date(p_from_public_api, p_active_end_date,FND_API.G_MISS_DATE);

612:
613: if p_reactivate_asset = 'Y' then
614: l_instance_rec.active_end_date := null;
615: else
616: l_instance_rec.active_end_date := actual_value_date(p_from_public_api, p_active_end_date,FND_API.G_MISS_DATE);
617: end if;
618:
619: --csi_gen_utility_pvt.put_line('EAM: After conversion, end date : '||to_char(l_instance_rec.active_end_date,'dd-mon-yy hh24:mi:ss'));
620:

Line 621: --l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);

617: end if;
618:
619: --csi_gen_utility_pvt.put_line('EAM: After conversion, end date : '||to_char(l_instance_rec.active_end_date,'dd-mon-yy hh24:mi:ss'));
620:
621: --l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);
622: l_instance_rec.operational_log_flag := actual_value_char(p_from_public_api, p_operational_log_flag,FND_API.G_MISS_CHAR);
623: l_instance_rec.checkin_status := actual_value_char(p_from_public_api, p_checkin_status,FND_API.G_MISS_NUM);
624: l_instance_rec.supplier_warranty_exp_date := actual_value_date(p_from_public_api, p_supplier_warranty_exp_date,FND_API.G_MISS_DATE);
625:

Line 622: l_instance_rec.operational_log_flag := actual_value_char(p_from_public_api, p_operational_log_flag,FND_API.G_MISS_CHAR);

618:
619: --csi_gen_utility_pvt.put_line('EAM: After conversion, end date : '||to_char(l_instance_rec.active_end_date,'dd-mon-yy hh24:mi:ss'));
620:
621: --l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);
622: l_instance_rec.operational_log_flag := actual_value_char(p_from_public_api, p_operational_log_flag,FND_API.G_MISS_CHAR);
623: l_instance_rec.checkin_status := actual_value_char(p_from_public_api, p_checkin_status,FND_API.G_MISS_NUM);
624: l_instance_rec.supplier_warranty_exp_date := actual_value_date(p_from_public_api, p_supplier_warranty_exp_date,FND_API.G_MISS_DATE);
625:
626: l_txn_rec.transaction_id := NULL;

Line 623: l_instance_rec.checkin_status := actual_value_char(p_from_public_api, p_checkin_status,FND_API.G_MISS_NUM);

619: --csi_gen_utility_pvt.put_line('EAM: After conversion, end date : '||to_char(l_instance_rec.active_end_date,'dd-mon-yy hh24:mi:ss'));
620:
621: --l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);
622: l_instance_rec.operational_log_flag := actual_value_char(p_from_public_api, p_operational_log_flag,FND_API.G_MISS_CHAR);
623: l_instance_rec.checkin_status := actual_value_char(p_from_public_api, p_checkin_status,FND_API.G_MISS_NUM);
624: l_instance_rec.supplier_warranty_exp_date := actual_value_date(p_from_public_api, p_supplier_warranty_exp_date,FND_API.G_MISS_DATE);
625:
626: l_txn_rec.transaction_id := NULL;
627: l_txn_rec.transaction_date := sysdate;

Line 624: l_instance_rec.supplier_warranty_exp_date := actual_value_date(p_from_public_api, p_supplier_warranty_exp_date,FND_API.G_MISS_DATE);

620:
621: --l_instance_rec.linear_location_id := actual_value_char(p_from_public_api, p_linear_location_id,FND_API.G_MISS_NUM);
622: l_instance_rec.operational_log_flag := actual_value_char(p_from_public_api, p_operational_log_flag,FND_API.G_MISS_CHAR);
623: l_instance_rec.checkin_status := actual_value_char(p_from_public_api, p_checkin_status,FND_API.G_MISS_NUM);
624: l_instance_rec.supplier_warranty_exp_date := actual_value_date(p_from_public_api, p_supplier_warranty_exp_date,FND_API.G_MISS_DATE);
625:
626: l_txn_rec.transaction_id := NULL;
627: l_txn_rec.transaction_date := sysdate;
628: l_txn_rec.source_transaction_date := sysdate;

Line 653: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;

649: end;
650:
651: if P_FA_SYNC_FLAG = 'Y' then
652: l_asset_assignment_tbl(1).fa_sync_flag := 'Y';
653: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;
654: else
655: l_asset_assignment_tbl(1).fa_sync_flag := 'N';
656: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;
657: end if;

Line 656: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;

652: l_asset_assignment_tbl(1).fa_sync_flag := 'Y';
653: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;
654: else
655: l_asset_assignment_tbl(1).fa_sync_flag := 'N';
656: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;
657: end if;
658:
659: select fb.book_type_code
660: into l_asset_assignment_tbl(1).fa_book_type_code

Line 704: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;

700: end;
701:
702: if P_FA_SYNC_FLAG = 'Y' then
703: l_asset_assignment_tbl(1).fa_sync_flag := 'Y';
704: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;
705: else
706: l_asset_assignment_tbl(1).fa_sync_flag := 'N';
707: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;
708: end if;

Line 707: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;

703: l_asset_assignment_tbl(1).fa_sync_flag := 'Y';
704: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;
705: else
706: l_asset_assignment_tbl(1).fa_sync_flag := 'N';
707: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;
708: end if;
709:
710: select fb.book_type_code
711: into l_asset_assignment_tbl(1).fa_book_type_code

Line 737: if (P_LOCATION_TYPE_CODE is not NULL AND P_LOCATION_TYPE_CODE <> FND_API.G_MISS_CHAR) then

733: l_asset_assignment_tbl(1).active_end_date := sysdate;
734:
735: end if; --end if for disassociate fa flag
736:
737: if (P_LOCATION_TYPE_CODE is not NULL AND P_LOCATION_TYPE_CODE <> FND_API.G_MISS_CHAR) then
738:
739:
740: if (p_location_type_code <> 'INVENTORY') then
741:

Line 750: RAISE FND_API.G_EXC_ERROR;

746:
747: if (l_old_location_type_code = 'INVENTORY') then
748: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_LOCATION_UPDATE');
749: FND_MSG_PUB.Add;
750: RAISE FND_API.G_EXC_ERROR;
751: end if;
752: end if;
753: end if;
754:

Line 778: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

774: );
775: x_return_status := l_x_return_status;
776: x_msg_count := l_x_msg_count;
777: x_msg_data := l_x_msg_data;
778: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
779: l_msg_index := 1;
780: l_msg_count := x_msg_count;
781: WHILE l_msg_count > 0 LOOP
782: x_msg_data := FND_MSG_PUB.GET

Line 784: FND_API.G_FALSE );

780: l_msg_count := x_msg_count;
781: WHILE l_msg_count > 0 LOOP
782: x_msg_data := FND_MSG_PUB.GET
783: ( l_msg_index,
784: FND_API.G_FALSE );
785: -- csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
786: -- csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
787: l_msg_index := l_msg_index + 1;
788: l_msg_count := l_msg_count - 1;

Line 790: RAISE FND_API.G_EXC_ERROR;

786: -- csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
787: l_msg_index := l_msg_index + 1;
788: l_msg_count := l_msg_count - 1;
789: END LOOP;
790: RAISE FND_API.G_EXC_ERROR;
791: END IF;
792:
793: /* Bug # 5339642 : Call Text index procedure for inserting the row in EAT */
794: eam_text_util.process_asset_update_event

Line 802: IF fnd_api.to_boolean(p_commit) THEN

798: );
799:
800: -- End of API body.
801: -- Standard check of p_commit.
802: IF fnd_api.to_boolean(p_commit) THEN
803: COMMIT WORK;
804: END IF;
805:
806: -- Standard call to get message count and if count is 1, get message info.

Line 809: WHEN fnd_api.g_exc_error THEN

805:
806: -- Standard call to get message count and if count is 1, get message info.
807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
808: EXCEPTION
809: WHEN fnd_api.g_exc_error THEN
810: ROLLBACK TO update_row;
811: x_return_status := fnd_api.g_ret_sts_error;
812: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
813: WHEN fnd_api.g_exc_unexpected_error THEN

Line 811: x_return_status := fnd_api.g_ret_sts_error;

807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
808: EXCEPTION
809: WHEN fnd_api.g_exc_error THEN
810: ROLLBACK TO update_row;
811: x_return_status := fnd_api.g_ret_sts_error;
812: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
813: WHEN fnd_api.g_exc_unexpected_error THEN
814: ROLLBACK TO update_row;
815: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 813: WHEN fnd_api.g_exc_unexpected_error THEN

809: WHEN fnd_api.g_exc_error THEN
810: ROLLBACK TO update_row;
811: x_return_status := fnd_api.g_ret_sts_error;
812: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
813: WHEN fnd_api.g_exc_unexpected_error THEN
814: ROLLBACK TO update_row;
815: x_return_status := fnd_api.g_ret_sts_unexp_error;
816: /*fnd_msg_pub.count_and_get(
817: p_count => x_msg_count

Line 815: x_return_status := fnd_api.g_ret_sts_unexp_error;

811: x_return_status := fnd_api.g_ret_sts_error;
812: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
813: WHEN fnd_api.g_exc_unexpected_error THEN
814: ROLLBACK TO update_row;
815: x_return_status := fnd_api.g_ret_sts_unexp_error;
816: /*fnd_msg_pub.count_and_get(
817: p_count => x_msg_count
818: ,p_data => x_msg_data);*/
819: WHEN OTHERS THEN

Line 821: x_return_status := fnd_api.g_ret_sts_unexp_error;

817: p_count => x_msg_count
818: ,p_data => x_msg_data);*/
819: WHEN OTHERS THEN
820: ROLLBACK TO update_row;
821: x_return_status := fnd_api.g_ret_sts_unexp_error;
822:
823: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
824: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
825: END IF;

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

830:
831: PROCEDURE LOCK_ROW(
832:
833: P_API_VERSION IN NUMBER,
834: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
835: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
836: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
837: P_ROWID VARCHAR2,
838: P_INSTANCE_ID IN NUMBER,

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

831: PROCEDURE LOCK_ROW(
832:
833: P_API_VERSION IN NUMBER,
834: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
835: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
836: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
837: P_ROWID VARCHAR2,
838: P_INSTANCE_ID IN NUMBER,
839: P_INSTANCE_NUMBER VARCHAR2 DEFAULT NULL,

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

832:
833: P_API_VERSION IN NUMBER,
834: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
835: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
836: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
837: P_ROWID VARCHAR2,
838: P_INSTANCE_ID IN NUMBER,
839: P_INSTANCE_NUMBER VARCHAR2 DEFAULT NULL,
840: P_INSTANCE_DESCRIPTION VARCHAR2,

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

1067: end lock_row;
1068:
1069: PROCEDURE CREATE_ASSET(
1070: P_API_VERSION IN NUMBER
1071: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1072: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1073: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1074: ,P_INVENTORY_ITEM_ID NUMBER
1075: ,P_SERIAL_NUMBER VARCHAR2

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

1068:
1069: PROCEDURE CREATE_ASSET(
1070: P_API_VERSION IN NUMBER
1071: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1072: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1073: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1074: ,P_INVENTORY_ITEM_ID NUMBER
1075: ,P_SERIAL_NUMBER VARCHAR2
1076: ,P_INSTANCE_NUMBER VARCHAR2

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

1069: PROCEDURE CREATE_ASSET(
1070: P_API_VERSION IN NUMBER
1071: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1072: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1073: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1074: ,P_INVENTORY_ITEM_ID NUMBER
1075: ,P_SERIAL_NUMBER VARCHAR2
1076: ,P_INSTANCE_NUMBER VARCHAR2
1077: ,P_INSTANCE_DESCRIPTION VARCHAR2

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

1156: -- Standard Start of API savepoint
1157: SAVEPOINT create_asset;
1158:
1159: -- Standard call to check for call compatibility.
1160: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;
1163:
1164: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1161: RAISE fnd_api.g_exc_unexpected_error;

1157: SAVEPOINT create_asset;
1158:
1159: -- Standard call to check for call compatibility.
1160: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;
1163:
1164: -- Initialize message list if p_init_msg_list is set to TRUE.
1165: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1165: IF fnd_api.to_boolean(p_init_msg_list) THEN

1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;
1163:
1164: -- Initialize message list if p_init_msg_list is set to TRUE.
1165: IF fnd_api.to_boolean(p_init_msg_list) THEN
1166: fnd_msg_pub.initialize;
1167: END IF;
1168:
1169: -- Initialize API return status to success

Line 1170: x_return_status := fnd_api.g_ret_sts_success;

1166: fnd_msg_pub.initialize;
1167: END IF;
1168:
1169: -- Initialize API return status to success
1170: x_return_status := fnd_api.g_ret_sts_success;
1171:
1172: -- API body
1173: begin
1174: select 1

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

1259: );
1260: x_return_status := l_x_asset_return_status;
1261: x_msg_count := l_x_asset_msg_count;
1262: x_msg_data := l_x_asset_msg_data;
1263: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
1264: RAISE FND_API.G_EXC_ERROR ;
1265: else
1266: if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1267: EAM_MAINT_ATTRIBUTES_PUB.create_maint_attributes(

Line 1264: RAISE FND_API.G_EXC_ERROR ;

1260: x_return_status := l_x_asset_return_status;
1261: x_msg_count := l_x_asset_msg_count;
1262: x_msg_data := l_x_asset_msg_data;
1263: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
1264: RAISE FND_API.G_EXC_ERROR ;
1265: else
1266: if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1267: EAM_MAINT_ATTRIBUTES_PUB.create_maint_attributes(
1268: p_api_version => p_api_version

Line 1289: IF fnd_api.to_boolean(p_commit) THEN

1285: x_object_id := l_instance_id;
1286:
1287: -- End of API body.
1288: -- Standard check of p_commit.
1289: IF fnd_api.to_boolean(p_commit) THEN
1290: COMMIT WORK;
1291: END IF;
1292:
1293: -- Standard call to get message count and if count is 1, get message info.

Line 1300: WHEN fnd_api.g_exc_error THEN

1296: ,p_data => x_msg_data);
1297:
1298:
1299: EXCEPTION
1300: WHEN fnd_api.g_exc_error THEN
1301: ROLLBACK TO create_asset;
1302: x_return_status := fnd_api.g_ret_sts_error;
1303: /*fnd_msg_pub.count_and_get(
1304: p_count => x_msg_count

Line 1302: x_return_status := fnd_api.g_ret_sts_error;

1298:
1299: EXCEPTION
1300: WHEN fnd_api.g_exc_error THEN
1301: ROLLBACK TO create_asset;
1302: x_return_status := fnd_api.g_ret_sts_error;
1303: /*fnd_msg_pub.count_and_get(
1304: p_count => x_msg_count
1305: ,p_data => x_msg_data);*/
1306: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1306: WHEN fnd_api.g_exc_unexpected_error THEN

1302: x_return_status := fnd_api.g_ret_sts_error;
1303: /*fnd_msg_pub.count_and_get(
1304: p_count => x_msg_count
1305: ,p_data => x_msg_data);*/
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO create_asset;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309: /*fnd_msg_pub.count_and_get(
1310: p_count => x_msg_count

Line 1308: x_return_status := fnd_api.g_ret_sts_unexp_error;

1304: p_count => x_msg_count
1305: ,p_data => x_msg_data);*/
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO create_asset;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309: /*fnd_msg_pub.count_and_get(
1310: p_count => x_msg_count
1311: ,p_data => x_msg_data);*/
1312: WHEN OTHERS THEN

Line 1314: x_return_status := fnd_api.g_ret_sts_unexp_error;

1310: p_count => x_msg_count
1311: ,p_data => x_msg_data);*/
1312: WHEN OTHERS THEN
1313: ROLLBACK TO create_asset;
1314: x_return_status := fnd_api.g_ret_sts_unexp_error;
1315:
1316: IF fnd_msg_pub.check_msg_level(
1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

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

1325: end create_asset;
1326:
1327: procedure update_asset(
1328: P_API_VERSION IN NUMBER
1329: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1330: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1331: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1332: ,p_instance_id IN NUMBER
1333: ,P_INSTANCE_DESCRIPTION VARCHAR2

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

1326:
1327: procedure update_asset(
1328: P_API_VERSION IN NUMBER
1329: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1330: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1331: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1332: ,p_instance_id IN NUMBER
1333: ,P_INSTANCE_DESCRIPTION VARCHAR2
1334: ,P_INVENTORY_ITEM_ID NUMBER

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

1327: procedure update_asset(
1328: P_API_VERSION IN NUMBER
1329: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1330: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1331: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1332: ,p_instance_id IN NUMBER
1333: ,P_INSTANCE_DESCRIPTION VARCHAR2
1334: ,P_INVENTORY_ITEM_ID NUMBER
1335: ,P_SERIAL_NUMBER VARCHAR2

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

1421: -- Standard Start of API savepoint
1422: SAVEPOINT update_asset;
1423:
1424: -- Standard call to check for call compatibility.
1425: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1426: RAISE fnd_api.g_exc_unexpected_error;
1427: END IF;
1428:
1429: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1426: RAISE fnd_api.g_exc_unexpected_error;

1422: SAVEPOINT update_asset;
1423:
1424: -- Standard call to check for call compatibility.
1425: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1426: RAISE fnd_api.g_exc_unexpected_error;
1427: END IF;
1428:
1429: -- Initialize message list if p_init_msg_list is set to TRUE.
1430: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1430: IF fnd_api.to_boolean(p_init_msg_list) THEN

1426: RAISE fnd_api.g_exc_unexpected_error;
1427: END IF;
1428:
1429: -- Initialize message list if p_init_msg_list is set to TRUE.
1430: IF fnd_api.to_boolean(p_init_msg_list) THEN
1431: fnd_msg_pub.initialize;
1432: END IF;
1433:
1434: -- Initialize API return status to success

Line 1435: x_return_status := fnd_api.g_ret_sts_success;

1431: fnd_msg_pub.initialize;
1432: END IF;
1433:
1434: -- Initialize API return status to success
1435: x_return_status := fnd_api.g_ret_sts_success;
1436:
1437: -- API body
1438: begin
1439: select 1,current_status

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

1593: x_return_status := l_x_asset_return_status;
1594: x_msg_count := l_x_asset_msg_count;
1595: x_msg_data := l_x_asset_msg_data;
1596:
1597: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
1598: RAISE FND_API.G_EXC_ERROR ;
1599: else
1600: --if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1601:

Line 1598: RAISE FND_API.G_EXC_ERROR ;

1594: x_msg_count := l_x_asset_msg_count;
1595: x_msg_data := l_x_asset_msg_data;
1596:
1597: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
1598: RAISE FND_API.G_EXC_ERROR ;
1599: else
1600: --if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1601:
1602: /* bug 5177526 : Need to pass maint org id */

Line 1608: l_owning_department_id := nvl(p_owning_department_id,FND_API.G_MISS_NUM);

1604: FROM mtl_parameters
1605: WHERE organization_id = p_organization_id;
1606:
1607: if (p_from_public_api = 'N') then
1608: l_owning_department_id := nvl(p_owning_department_id,FND_API.G_MISS_NUM);
1609: l_accounting_class_code := nvl(p_accounting_class_code,FND_API.G_MISS_CHAR);
1610: l_area_id := nvl(p_area_id,FND_API.G_MISS_NUM);
1611: else
1612: l_owning_department_id := p_owning_department_id;

Line 1609: l_accounting_class_code := nvl(p_accounting_class_code,FND_API.G_MISS_CHAR);

1605: WHERE organization_id = p_organization_id;
1606:
1607: if (p_from_public_api = 'N') then
1608: l_owning_department_id := nvl(p_owning_department_id,FND_API.G_MISS_NUM);
1609: l_accounting_class_code := nvl(p_accounting_class_code,FND_API.G_MISS_CHAR);
1610: l_area_id := nvl(p_area_id,FND_API.G_MISS_NUM);
1611: else
1612: l_owning_department_id := p_owning_department_id;
1613: l_accounting_class_code := p_accounting_class_code;

Line 1610: l_area_id := nvl(p_area_id,FND_API.G_MISS_NUM);

1606:
1607: if (p_from_public_api = 'N') then
1608: l_owning_department_id := nvl(p_owning_department_id,FND_API.G_MISS_NUM);
1609: l_accounting_class_code := nvl(p_accounting_class_code,FND_API.G_MISS_CHAR);
1610: l_area_id := nvl(p_area_id,FND_API.G_MISS_NUM);
1611: else
1612: l_owning_department_id := p_owning_department_id;
1613: l_accounting_class_code := p_accounting_class_code;
1614: l_area_id := p_area_id;

Line 1634: if (l_x_maint_return_status = FND_API.G_RET_STS_SUCCESS) then

1630: x_msg_count := l_x_maint_msg_count;
1631: x_msg_data := l_x_maint_msg_data;
1632:
1633: /*bug 10093296-update owning department for activity associations... start*/
1634: if (l_x_maint_return_status = FND_API.G_RET_STS_SUCCESS) then
1635: for association in associations loop
1636: EAM_ORG_MAINT_DEFAULTS_PVT.update_insert_row(
1637: p_api_version => p_api_version
1638: ,p_object_type => 60

Line 1657: IF fnd_api.to_boolean(p_commit) THEN

1653: end if;
1654:
1655: -- End of API body.
1656: -- Standard check of p_commit.
1657: IF fnd_api.to_boolean(p_commit) THEN
1658: COMMIT WORK;
1659: END IF;
1660:
1661:

Line 1669: WHEN fnd_api.g_exc_error THEN

1665: ,p_data => x_msg_data);
1666:
1667:
1668: EXCEPTION
1669: WHEN fnd_api.g_exc_error THEN
1670: ROLLBACK TO update_asset;
1671: x_return_status := fnd_api.g_ret_sts_error;
1672: /*fnd_msg_pub.count_and_get(
1673: p_count => x_msg_count

Line 1671: x_return_status := fnd_api.g_ret_sts_error;

1667:
1668: EXCEPTION
1669: WHEN fnd_api.g_exc_error THEN
1670: ROLLBACK TO update_asset;
1671: x_return_status := fnd_api.g_ret_sts_error;
1672: /*fnd_msg_pub.count_and_get(
1673: p_count => x_msg_count
1674: ,p_data => x_msg_data);*/
1675: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1675: WHEN fnd_api.g_exc_unexpected_error THEN

1671: x_return_status := fnd_api.g_ret_sts_error;
1672: /*fnd_msg_pub.count_and_get(
1673: p_count => x_msg_count
1674: ,p_data => x_msg_data);*/
1675: WHEN fnd_api.g_exc_unexpected_error THEN
1676: ROLLBACK TO update_asset;
1677: x_return_status := fnd_api.g_ret_sts_unexp_error;
1678: /*fnd_msg_pub.count_and_get(
1679: p_count => x_msg_count

Line 1677: x_return_status := fnd_api.g_ret_sts_unexp_error;

1673: p_count => x_msg_count
1674: ,p_data => x_msg_data);*/
1675: WHEN fnd_api.g_exc_unexpected_error THEN
1676: ROLLBACK TO update_asset;
1677: x_return_status := fnd_api.g_ret_sts_unexp_error;
1678: /*fnd_msg_pub.count_and_get(
1679: p_count => x_msg_count
1680: ,p_data => x_msg_data);*/
1681: WHEN OTHERS THEN

Line 1683: x_return_status := fnd_api.g_ret_sts_unexp_error;

1679: p_count => x_msg_count
1680: ,p_data => x_msg_data);*/
1681: WHEN OTHERS THEN
1682: ROLLBACK TO update_asset;
1683: x_return_status := fnd_api.g_ret_sts_unexp_error;
1684:
1685: IF fnd_msg_pub.check_msg_level(
1686: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1687: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

Line 1699: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1695: end update_asset;
1696:
1697: PROCEDURE SERIAL_CHECK
1698: ( p_api_version IN NUMBER,
1699: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1700: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1701: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1702: x_return_status OUT NOCOPY VARCHAR2,
1703: x_msg_count OUT NOCOPY NUMBER,

Line 1700: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1696:
1697: PROCEDURE SERIAL_CHECK
1698: ( p_api_version IN NUMBER,
1699: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1700: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1701: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1702: x_return_status OUT NOCOPY VARCHAR2,
1703: x_msg_count OUT NOCOPY NUMBER,
1704: x_msg_data OUT NOCOPY VARCHAR2,

Line 1701: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1697: PROCEDURE SERIAL_CHECK
1698: ( p_api_version IN NUMBER,
1699: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1700: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1701: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1702: x_return_status OUT NOCOPY VARCHAR2,
1703: x_msg_count OUT NOCOPY NUMBER,
1704: x_msg_data OUT NOCOPY VARCHAR2,
1705: x_errorcode OUT NOCOPY NUMBER,

Line 1722: IF NOT fnd_api.compatible_api_call(

1718: -- Standard Start of API savepoint
1719: SAVEPOINT serial_check;
1720:
1721: -- Standard call to check for call compatibility.
1722: IF NOT fnd_api.compatible_api_call(
1723: l_api_version
1724: ,p_api_version
1725: ,l_api_name
1726: ,g_pkg_name) THEN

Line 1727: RAISE fnd_api.g_exc_unexpected_error;

1723: l_api_version
1724: ,p_api_version
1725: ,l_api_name
1726: ,g_pkg_name) THEN
1727: RAISE fnd_api.g_exc_unexpected_error;
1728: END IF;
1729:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.
1731: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1731: IF fnd_api.to_boolean(p_init_msg_list) THEN

1727: RAISE fnd_api.g_exc_unexpected_error;
1728: END IF;
1729:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.
1731: IF fnd_api.to_boolean(p_init_msg_list) THEN
1732: fnd_msg_pub.initialize;
1733: END IF;
1734:
1735: -- Initialize API return status to success

Line 1736: x_return_status := fnd_api.g_ret_sts_success;

1732: fnd_msg_pub.initialize;
1733: END IF;
1734:
1735: -- Initialize API return status to success
1736: x_return_status := fnd_api.g_ret_sts_success;
1737:
1738: -- API body
1739:
1740: -- added to fix bug 2446341

Line 1760: /*IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1756: p_serial_number_type => l_serial_number_type,
1757: p_serial_number => p_Serial_number);
1758:
1759:
1760: /*IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1761: RAISE FND_API.G_EXC_ERROR ;
1762: END IF;
1763: */
1764:

Line 1761: RAISE FND_API.G_EXC_ERROR ;

1757: p_serial_number => p_Serial_number);
1758:
1759:
1760: /*IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1761: RAISE FND_API.G_EXC_ERROR ;
1762: END IF;
1763: */
1764:
1765: -- check if serial number exists within asset group

Line 1772: x_return_status := FND_API.G_RET_STS_ERROR;

1768: where inventory_item_id = p_inventory_item_id
1769: and serial_number = p_serial_number;
1770:
1771: if l_count > 0 then
1772: x_return_status := FND_API.G_RET_STS_ERROR;
1773: x_ser_num_in_item_id := TRUE;
1774: else
1775: x_ser_num_in_item_id := FALSE;
1776: end if;

Line 1782: IF fnd_api.to_boolean(p_commit) THEN

1778:
1779:
1780: -- End of API body.
1781: -- Standard check of p_commit.
1782: IF fnd_api.to_boolean(p_commit) THEN
1783: COMMIT WORK;
1784: END IF;
1785:
1786: -- Standard call to get message count and if count is 1, get message info.

Line 1793: WHEN fnd_api.g_exc_error THEN

1789: ,p_data => x_msg_data);
1790:
1791:
1792: EXCEPTION
1793: WHEN fnd_api.g_exc_error THEN
1794: ROLLBACK TO serial_check;
1795: x_return_status := fnd_api.g_ret_sts_error;
1796: fnd_msg_pub.count_and_get(
1797: p_count => x_msg_count

Line 1795: x_return_status := fnd_api.g_ret_sts_error;

1791:
1792: EXCEPTION
1793: WHEN fnd_api.g_exc_error THEN
1794: ROLLBACK TO serial_check;
1795: x_return_status := fnd_api.g_ret_sts_error;
1796: fnd_msg_pub.count_and_get(
1797: p_count => x_msg_count
1798: ,p_data => x_msg_data);
1799: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1799: WHEN fnd_api.g_exc_unexpected_error THEN

1795: x_return_status := fnd_api.g_ret_sts_error;
1796: fnd_msg_pub.count_and_get(
1797: p_count => x_msg_count
1798: ,p_data => x_msg_data);
1799: WHEN fnd_api.g_exc_unexpected_error THEN
1800: ROLLBACK TO serial_check;
1801: x_return_status := fnd_api.g_ret_sts_unexp_error;
1802: fnd_msg_pub.count_and_get(
1803: p_count => x_msg_count

Line 1801: x_return_status := fnd_api.g_ret_sts_unexp_error;

1797: p_count => x_msg_count
1798: ,p_data => x_msg_data);
1799: WHEN fnd_api.g_exc_unexpected_error THEN
1800: ROLLBACK TO serial_check;
1801: x_return_status := fnd_api.g_ret_sts_unexp_error;
1802: fnd_msg_pub.count_and_get(
1803: p_count => x_msg_count
1804: ,p_data => x_msg_data);
1805: WHEN OTHERS THEN

Line 1807: x_return_status := fnd_api.g_ret_sts_unexp_error;

1803: p_count => x_msg_count
1804: ,p_data => x_msg_data);
1805: WHEN OTHERS THEN
1806: ROLLBACK TO serial_check;
1807: x_return_status := fnd_api.g_ret_sts_unexp_error;
1808:
1809: IF fnd_msg_pub.check_msg_level(
1810: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1811: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);