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 650: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;

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

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

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

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

694: end;
695:
696: if P_FA_SYNC_FLAG = 'Y' then
697: l_asset_assignment_tbl(1).fa_sync_flag := 'Y';
698: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;
699: else
700: l_asset_assignment_tbl(1).fa_sync_flag := 'N';
701: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;
702: end if;

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

697: l_asset_assignment_tbl(1).fa_sync_flag := 'Y';
698: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_TRUE;
699: else
700: l_asset_assignment_tbl(1).fa_sync_flag := 'N';
701: l_asset_assignment_tbl(1).fa_sync_validation_reqd := FND_API.G_FALSE;
702: end if;
703:
704: select fb.book_type_code
705: into l_asset_assignment_tbl(1).fa_book_type_code

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

727: l_asset_assignment_tbl(1).active_end_date := sysdate;
728:
729: end if; --end if for disassociate fa flag
730:
731: if (P_LOCATION_TYPE_CODE is not NULL AND P_LOCATION_TYPE_CODE <> FND_API.G_MISS_CHAR) then
732:
733:
734: if (p_location_type_code <> 'INVENTORY') then
735:

Line 744: RAISE FND_API.G_EXC_ERROR;

740:
741: if (l_old_location_type_code = 'INVENTORY') then
742: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_LOCATION_UPDATE');
743: FND_MSG_PUB.Add;
744: RAISE FND_API.G_EXC_ERROR;
745: end if;
746: end if;
747: end if;
748:

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

768: );
769: x_return_status := l_x_return_status;
770: x_msg_count := l_x_msg_count;
771: x_msg_data := l_x_msg_data;
772: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
773: l_msg_index := 1;
774: l_msg_count := x_msg_count;
775: WHILE l_msg_count > 0 LOOP
776: x_msg_data := FND_MSG_PUB.GET

Line 778: FND_API.G_FALSE );

774: l_msg_count := x_msg_count;
775: WHILE l_msg_count > 0 LOOP
776: x_msg_data := FND_MSG_PUB.GET
777: ( l_msg_index,
778: FND_API.G_FALSE );
779: -- csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
780: -- csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
781: l_msg_index := l_msg_index + 1;
782: l_msg_count := l_msg_count - 1;

Line 784: RAISE FND_API.G_EXC_ERROR;

780: -- csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
781: l_msg_index := l_msg_index + 1;
782: l_msg_count := l_msg_count - 1;
783: END LOOP;
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;
786:
787: /* Bug # 5339642 : Call Text index procedure for inserting the row in EAT */
788: eam_text_util.process_asset_update_event

Line 796: IF fnd_api.to_boolean(p_commit) THEN

792: );
793:
794: -- End of API body.
795: -- Standard check of p_commit.
796: IF fnd_api.to_boolean(p_commit) THEN
797: COMMIT WORK;
798: END IF;
799:
800: -- Standard call to get message count and if count is 1, get message info.

Line 803: WHEN fnd_api.g_exc_error THEN

799:
800: -- Standard call to get message count and if count is 1, get message info.
801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
802: EXCEPTION
803: WHEN fnd_api.g_exc_error THEN
804: ROLLBACK TO update_row;
805: x_return_status := fnd_api.g_ret_sts_error;
806: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
807: WHEN fnd_api.g_exc_unexpected_error THEN

Line 805: x_return_status := fnd_api.g_ret_sts_error;

801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
802: EXCEPTION
803: WHEN fnd_api.g_exc_error THEN
804: ROLLBACK TO update_row;
805: x_return_status := fnd_api.g_ret_sts_error;
806: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
807: WHEN fnd_api.g_exc_unexpected_error THEN
808: ROLLBACK TO update_row;
809: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 807: WHEN fnd_api.g_exc_unexpected_error THEN

803: WHEN fnd_api.g_exc_error THEN
804: ROLLBACK TO update_row;
805: x_return_status := fnd_api.g_ret_sts_error;
806: /*fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);*/
807: WHEN fnd_api.g_exc_unexpected_error THEN
808: ROLLBACK TO update_row;
809: x_return_status := fnd_api.g_ret_sts_unexp_error;
810: /*fnd_msg_pub.count_and_get(
811: p_count => x_msg_count

Line 809: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 815: x_return_status := fnd_api.g_ret_sts_unexp_error;

811: p_count => x_msg_count
812: ,p_data => x_msg_data);*/
813: WHEN OTHERS THEN
814: ROLLBACK TO update_row;
815: x_return_status := fnd_api.g_ret_sts_unexp_error;
816:
817: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
818: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
819: END IF;

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

824:
825: PROCEDURE LOCK_ROW(
826:
827: P_API_VERSION IN NUMBER,
828: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
829: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
830: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
831: P_ROWID VARCHAR2,
832: P_INSTANCE_ID IN NUMBER,

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

825: PROCEDURE LOCK_ROW(
826:
827: P_API_VERSION IN NUMBER,
828: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
829: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
830: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
831: P_ROWID VARCHAR2,
832: P_INSTANCE_ID IN NUMBER,
833: P_INSTANCE_NUMBER VARCHAR2 DEFAULT NULL,

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

826:
827: P_API_VERSION IN NUMBER,
828: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
829: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
830: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
831: P_ROWID VARCHAR2,
832: P_INSTANCE_ID IN NUMBER,
833: P_INSTANCE_NUMBER VARCHAR2 DEFAULT NULL,
834: P_INSTANCE_DESCRIPTION VARCHAR2,

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

1061: end lock_row;
1062:
1063: PROCEDURE CREATE_ASSET(
1064: P_API_VERSION IN NUMBER
1065: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1066: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1067: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1068: ,P_INVENTORY_ITEM_ID NUMBER
1069: ,P_SERIAL_NUMBER VARCHAR2

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

1062:
1063: PROCEDURE CREATE_ASSET(
1064: P_API_VERSION IN NUMBER
1065: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1066: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1067: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1068: ,P_INVENTORY_ITEM_ID NUMBER
1069: ,P_SERIAL_NUMBER VARCHAR2
1070: ,P_INSTANCE_NUMBER VARCHAR2

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

1063: PROCEDURE CREATE_ASSET(
1064: P_API_VERSION IN NUMBER
1065: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1066: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1067: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1068: ,P_INVENTORY_ITEM_ID NUMBER
1069: ,P_SERIAL_NUMBER VARCHAR2
1070: ,P_INSTANCE_NUMBER VARCHAR2
1071: ,P_INSTANCE_DESCRIPTION VARCHAR2

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

1150: -- Standard Start of API savepoint
1151: SAVEPOINT create_asset;
1152:
1153: -- Standard call to check for call compatibility.
1154: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1155: RAISE fnd_api.g_exc_unexpected_error;
1156: END IF;
1157:
1158: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1155: RAISE fnd_api.g_exc_unexpected_error;

1151: SAVEPOINT create_asset;
1152:
1153: -- Standard call to check for call compatibility.
1154: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1155: RAISE fnd_api.g_exc_unexpected_error;
1156: END IF;
1157:
1158: -- Initialize message list if p_init_msg_list is set to TRUE.
1159: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1159: IF fnd_api.to_boolean(p_init_msg_list) THEN

1155: RAISE fnd_api.g_exc_unexpected_error;
1156: END IF;
1157:
1158: -- Initialize message list if p_init_msg_list is set to TRUE.
1159: IF fnd_api.to_boolean(p_init_msg_list) THEN
1160: fnd_msg_pub.initialize;
1161: END IF;
1162:
1163: -- Initialize API return status to success

Line 1164: x_return_status := fnd_api.g_ret_sts_success;

1160: fnd_msg_pub.initialize;
1161: END IF;
1162:
1163: -- Initialize API return status to success
1164: x_return_status := fnd_api.g_ret_sts_success;
1165:
1166: -- API body
1167: begin
1168: select 1

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

1253: );
1254: x_return_status := l_x_asset_return_status;
1255: x_msg_count := l_x_asset_msg_count;
1256: x_msg_data := l_x_asset_msg_data;
1257: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
1258: RAISE FND_API.G_EXC_ERROR ;
1259: else
1260: if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1261: EAM_MAINT_ATTRIBUTES_PUB.create_maint_attributes(

Line 1258: RAISE FND_API.G_EXC_ERROR ;

1254: x_return_status := l_x_asset_return_status;
1255: x_msg_count := l_x_asset_msg_count;
1256: x_msg_data := l_x_asset_msg_data;
1257: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
1258: RAISE FND_API.G_EXC_ERROR ;
1259: else
1260: if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1261: EAM_MAINT_ATTRIBUTES_PUB.create_maint_attributes(
1262: p_api_version => p_api_version

Line 1283: IF fnd_api.to_boolean(p_commit) THEN

1279: x_object_id := l_instance_id;
1280:
1281: -- End of API body.
1282: -- Standard check of p_commit.
1283: IF fnd_api.to_boolean(p_commit) THEN
1284: COMMIT WORK;
1285: END IF;
1286:
1287: -- Standard call to get message count and if count is 1, get message info.

Line 1294: WHEN fnd_api.g_exc_error THEN

1290: ,p_data => x_msg_data);
1291:
1292:
1293: EXCEPTION
1294: WHEN fnd_api.g_exc_error THEN
1295: ROLLBACK TO create_asset;
1296: x_return_status := fnd_api.g_ret_sts_error;
1297: /*fnd_msg_pub.count_and_get(
1298: p_count => x_msg_count

Line 1296: x_return_status := fnd_api.g_ret_sts_error;

1292:
1293: EXCEPTION
1294: WHEN fnd_api.g_exc_error THEN
1295: ROLLBACK TO create_asset;
1296: x_return_status := fnd_api.g_ret_sts_error;
1297: /*fnd_msg_pub.count_and_get(
1298: p_count => x_msg_count
1299: ,p_data => x_msg_data);*/
1300: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1300: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 1302: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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 OTHERS THEN
1307: ROLLBACK TO create_asset;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309:
1310: IF fnd_msg_pub.check_msg_level(
1311: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1312: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

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

1319: end create_asset;
1320:
1321: procedure update_asset(
1322: P_API_VERSION IN NUMBER
1323: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1324: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1325: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1326: ,p_instance_id IN NUMBER
1327: ,P_INSTANCE_DESCRIPTION VARCHAR2

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

1320:
1321: procedure update_asset(
1322: P_API_VERSION IN NUMBER
1323: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1324: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1325: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1326: ,p_instance_id IN NUMBER
1327: ,P_INSTANCE_DESCRIPTION VARCHAR2
1328: ,P_INVENTORY_ITEM_ID NUMBER

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

1321: procedure update_asset(
1322: P_API_VERSION IN NUMBER
1323: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
1324: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
1325: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1326: ,p_instance_id IN NUMBER
1327: ,P_INSTANCE_DESCRIPTION VARCHAR2
1328: ,P_INVENTORY_ITEM_ID NUMBER
1329: ,P_SERIAL_NUMBER VARCHAR2

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

1413: -- Standard Start of API savepoint
1414: SAVEPOINT update_asset;
1415:
1416: -- Standard call to check for call compatibility.
1417: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1418: RAISE fnd_api.g_exc_unexpected_error;
1419: END IF;
1420:
1421: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1418: RAISE fnd_api.g_exc_unexpected_error;

1414: SAVEPOINT update_asset;
1415:
1416: -- Standard call to check for call compatibility.
1417: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1418: RAISE fnd_api.g_exc_unexpected_error;
1419: END IF;
1420:
1421: -- Initialize message list if p_init_msg_list is set to TRUE.
1422: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1422: IF fnd_api.to_boolean(p_init_msg_list) THEN

1418: RAISE fnd_api.g_exc_unexpected_error;
1419: END IF;
1420:
1421: -- Initialize message list if p_init_msg_list is set to TRUE.
1422: IF fnd_api.to_boolean(p_init_msg_list) THEN
1423: fnd_msg_pub.initialize;
1424: END IF;
1425:
1426: -- Initialize API return status to success

Line 1427: x_return_status := fnd_api.g_ret_sts_success;

1423: fnd_msg_pub.initialize;
1424: END IF;
1425:
1426: -- Initialize API return status to success
1427: x_return_status := fnd_api.g_ret_sts_success;
1428:
1429: -- API body
1430: begin
1431: select 1,current_status

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

1585: x_return_status := l_x_asset_return_status;
1586: x_msg_count := l_x_asset_msg_count;
1587: x_msg_data := l_x_asset_msg_data;
1588:
1589: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
1590: RAISE FND_API.G_EXC_ERROR ;
1591: else
1592: --if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1593:

Line 1590: RAISE FND_API.G_EXC_ERROR ;

1586: x_msg_count := l_x_asset_msg_count;
1587: x_msg_data := l_x_asset_msg_data;
1588:
1589: if (l_x_asset_return_status <> FND_API.G_RET_STS_SUCCESS) then
1590: RAISE FND_API.G_EXC_ERROR ;
1591: else
1592: --if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1593:
1594: /* bug 5177526 : Need to pass maint org id */

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

1596: FROM mtl_parameters
1597: WHERE organization_id = p_organization_id;
1598:
1599: if (p_from_public_api = 'N') then
1600: l_owning_department_id := nvl(p_owning_department_id,FND_API.G_MISS_NUM);
1601: l_accounting_class_code := nvl(p_accounting_class_code,FND_API.G_MISS_CHAR);
1602: l_area_id := nvl(p_area_id,FND_API.G_MISS_NUM);
1603: else
1604: l_owning_department_id := p_owning_department_id;

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

1597: WHERE organization_id = p_organization_id;
1598:
1599: if (p_from_public_api = 'N') then
1600: l_owning_department_id := nvl(p_owning_department_id,FND_API.G_MISS_NUM);
1601: l_accounting_class_code := nvl(p_accounting_class_code,FND_API.G_MISS_CHAR);
1602: l_area_id := nvl(p_area_id,FND_API.G_MISS_NUM);
1603: else
1604: l_owning_department_id := p_owning_department_id;
1605: l_accounting_class_code := p_accounting_class_code;

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

1598:
1599: if (p_from_public_api = 'N') then
1600: l_owning_department_id := nvl(p_owning_department_id,FND_API.G_MISS_NUM);
1601: l_accounting_class_code := nvl(p_accounting_class_code,FND_API.G_MISS_CHAR);
1602: l_area_id := nvl(p_area_id,FND_API.G_MISS_NUM);
1603: else
1604: l_owning_department_id := p_owning_department_id;
1605: l_accounting_class_code := p_accounting_class_code;
1606: l_area_id := p_area_id;

Line 1630: IF fnd_api.to_boolean(p_commit) THEN

1626: end if;
1627:
1628: -- End of API body.
1629: -- Standard check of p_commit.
1630: IF fnd_api.to_boolean(p_commit) THEN
1631: COMMIT WORK;
1632: END IF;
1633:
1634:

Line 1642: WHEN fnd_api.g_exc_error THEN

1638: ,p_data => x_msg_data);
1639:
1640:
1641: EXCEPTION
1642: WHEN fnd_api.g_exc_error THEN
1643: ROLLBACK TO update_asset;
1644: x_return_status := fnd_api.g_ret_sts_error;
1645: /*fnd_msg_pub.count_and_get(
1646: p_count => x_msg_count

Line 1644: x_return_status := fnd_api.g_ret_sts_error;

1640:
1641: EXCEPTION
1642: WHEN fnd_api.g_exc_error THEN
1643: ROLLBACK TO update_asset;
1644: x_return_status := fnd_api.g_ret_sts_error;
1645: /*fnd_msg_pub.count_and_get(
1646: p_count => x_msg_count
1647: ,p_data => x_msg_data);*/
1648: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1648: WHEN fnd_api.g_exc_unexpected_error THEN

1644: x_return_status := fnd_api.g_ret_sts_error;
1645: /*fnd_msg_pub.count_and_get(
1646: p_count => x_msg_count
1647: ,p_data => x_msg_data);*/
1648: WHEN fnd_api.g_exc_unexpected_error THEN
1649: ROLLBACK TO update_asset;
1650: x_return_status := fnd_api.g_ret_sts_unexp_error;
1651: /*fnd_msg_pub.count_and_get(
1652: p_count => x_msg_count

Line 1650: x_return_status := fnd_api.g_ret_sts_unexp_error;

1646: p_count => x_msg_count
1647: ,p_data => x_msg_data);*/
1648: WHEN fnd_api.g_exc_unexpected_error THEN
1649: ROLLBACK TO update_asset;
1650: x_return_status := fnd_api.g_ret_sts_unexp_error;
1651: /*fnd_msg_pub.count_and_get(
1652: p_count => x_msg_count
1653: ,p_data => x_msg_data);*/
1654: WHEN OTHERS THEN

Line 1656: x_return_status := fnd_api.g_ret_sts_unexp_error;

1652: p_count => x_msg_count
1653: ,p_data => x_msg_data);*/
1654: WHEN OTHERS THEN
1655: ROLLBACK TO update_asset;
1656: x_return_status := fnd_api.g_ret_sts_unexp_error;
1657:
1658: IF fnd_msg_pub.check_msg_level(
1659: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1660: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

Line 1672: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1668: end update_asset;
1669:
1670: PROCEDURE SERIAL_CHECK
1671: ( p_api_version IN NUMBER,
1672: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1673: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1674: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1675: x_return_status OUT NOCOPY VARCHAR2,
1676: x_msg_count OUT NOCOPY NUMBER,

Line 1673: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1669:
1670: PROCEDURE SERIAL_CHECK
1671: ( p_api_version IN NUMBER,
1672: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1673: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1674: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1675: x_return_status OUT NOCOPY VARCHAR2,
1676: x_msg_count OUT NOCOPY NUMBER,
1677: x_msg_data OUT NOCOPY VARCHAR2,

Line 1674: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1670: PROCEDURE SERIAL_CHECK
1671: ( p_api_version IN NUMBER,
1672: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1673: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1674: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1675: x_return_status OUT NOCOPY VARCHAR2,
1676: x_msg_count OUT NOCOPY NUMBER,
1677: x_msg_data OUT NOCOPY VARCHAR2,
1678: x_errorcode OUT NOCOPY NUMBER,

Line 1695: IF NOT fnd_api.compatible_api_call(

1691: -- Standard Start of API savepoint
1692: SAVEPOINT serial_check;
1693:
1694: -- Standard call to check for call compatibility.
1695: IF NOT fnd_api.compatible_api_call(
1696: l_api_version
1697: ,p_api_version
1698: ,l_api_name
1699: ,g_pkg_name) THEN

Line 1700: RAISE fnd_api.g_exc_unexpected_error;

1696: l_api_version
1697: ,p_api_version
1698: ,l_api_name
1699: ,g_pkg_name) THEN
1700: RAISE fnd_api.g_exc_unexpected_error;
1701: END IF;
1702:
1703: -- Initialize message list if p_init_msg_list is set to TRUE.
1704: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1704: IF fnd_api.to_boolean(p_init_msg_list) THEN

1700: RAISE fnd_api.g_exc_unexpected_error;
1701: END IF;
1702:
1703: -- Initialize message list if p_init_msg_list is set to TRUE.
1704: IF fnd_api.to_boolean(p_init_msg_list) THEN
1705: fnd_msg_pub.initialize;
1706: END IF;
1707:
1708: -- Initialize API return status to success

Line 1709: x_return_status := fnd_api.g_ret_sts_success;

1705: fnd_msg_pub.initialize;
1706: END IF;
1707:
1708: -- Initialize API return status to success
1709: x_return_status := fnd_api.g_ret_sts_success;
1710:
1711: -- API body
1712:
1713: -- added to fix bug 2446341

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

1729: p_serial_number_type => l_serial_number_type,
1730: p_serial_number => p_Serial_number);
1731:
1732:
1733: /*IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1734: RAISE FND_API.G_EXC_ERROR ;
1735: END IF;
1736: */
1737:

Line 1734: RAISE FND_API.G_EXC_ERROR ;

1730: p_serial_number => p_Serial_number);
1731:
1732:
1733: /*IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1734: RAISE FND_API.G_EXC_ERROR ;
1735: END IF;
1736: */
1737:
1738: -- check if serial number exists within asset group

Line 1745: x_return_status := FND_API.G_RET_STS_ERROR;

1741: where inventory_item_id = p_inventory_item_id
1742: and serial_number = p_serial_number;
1743:
1744: if l_count > 0 then
1745: x_return_status := FND_API.G_RET_STS_ERROR;
1746: x_ser_num_in_item_id := TRUE;
1747: else
1748: x_ser_num_in_item_id := FALSE;
1749: end if;

Line 1755: IF fnd_api.to_boolean(p_commit) THEN

1751:
1752:
1753: -- End of API body.
1754: -- Standard check of p_commit.
1755: IF fnd_api.to_boolean(p_commit) THEN
1756: COMMIT WORK;
1757: END IF;
1758:
1759: -- Standard call to get message count and if count is 1, get message info.

Line 1766: WHEN fnd_api.g_exc_error THEN

1762: ,p_data => x_msg_data);
1763:
1764:
1765: EXCEPTION
1766: WHEN fnd_api.g_exc_error THEN
1767: ROLLBACK TO serial_check;
1768: x_return_status := fnd_api.g_ret_sts_error;
1769: fnd_msg_pub.count_and_get(
1770: p_count => x_msg_count

Line 1768: x_return_status := fnd_api.g_ret_sts_error;

1764:
1765: EXCEPTION
1766: WHEN fnd_api.g_exc_error THEN
1767: ROLLBACK TO serial_check;
1768: x_return_status := fnd_api.g_ret_sts_error;
1769: fnd_msg_pub.count_and_get(
1770: p_count => x_msg_count
1771: ,p_data => x_msg_data);
1772: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1772: WHEN fnd_api.g_exc_unexpected_error THEN

1768: x_return_status := fnd_api.g_ret_sts_error;
1769: fnd_msg_pub.count_and_get(
1770: p_count => x_msg_count
1771: ,p_data => x_msg_data);
1772: WHEN fnd_api.g_exc_unexpected_error THEN
1773: ROLLBACK TO serial_check;
1774: x_return_status := fnd_api.g_ret_sts_unexp_error;
1775: fnd_msg_pub.count_and_get(
1776: p_count => x_msg_count

Line 1774: x_return_status := fnd_api.g_ret_sts_unexp_error;

1770: p_count => x_msg_count
1771: ,p_data => x_msg_data);
1772: WHEN fnd_api.g_exc_unexpected_error THEN
1773: ROLLBACK TO serial_check;
1774: x_return_status := fnd_api.g_ret_sts_unexp_error;
1775: fnd_msg_pub.count_and_get(
1776: p_count => x_msg_count
1777: ,p_data => x_msg_data);
1778: WHEN OTHERS THEN

Line 1780: x_return_status := fnd_api.g_ret_sts_unexp_error;

1776: p_count => x_msg_count
1777: ,p_data => x_msg_data);
1778: WHEN OTHERS THEN
1779: ROLLBACK TO serial_check;
1780: x_return_status := fnd_api.g_ret_sts_unexp_error;
1781:
1782: IF fnd_msg_pub.check_msg_level(
1783: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1784: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);