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.FA_ASSET_DESC_PUB dependencies on FND_API

Line 29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

25: --*********************** Public procedures ******************************--
26: PROCEDURE update_desc(
27: -- Standard Parameters --
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,

Line 30: p_commit IN VARCHAR2 := FND_API.G_FALSE,

26: PROCEDURE update_desc(
27: -- Standard Parameters --
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,

Line 31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

27: -- Standard Parameters --
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_calling_fn IN VARCHAR2,

Line 73: if (NOT FND_API.Compatible_API_Call(

69: fa_debug_pkg.add('Update_desc', 'before', l_err_stage
70: ,p_log_level_rec => g_log_level_rec);
71: end if;
72:
73: if (NOT FND_API.Compatible_API_Call(
74: G_API_VERSION,
75: p_api_version,
76: G_API_NAME, G_PKG_NAME
77: )) then

Line 89: if (FND_API.To_Boolean(p_init_msg_list)) then

85: ,p_log_level_rec => g_log_level_rec);
86: end if;
87:
88:
89: if (FND_API.To_Boolean(p_init_msg_list)) then
90: -- Initialize error message stack.
91: FA_SRVR_MSG.Init_Server_Message;
92:
93: -- Initialize debug message stack.

Line 181: if (px_asset_desc_rec_new.asset_number = FND_API.G_MISS_CHAR) then

177: -- retain the old asset_number
178: null;
179: else
180: -- Check if user intentionally nulls out item.
181: if (px_asset_desc_rec_new.asset_number = FND_API.G_MISS_CHAR) then
182: -- use asset_id for asset_number
183: px_asset_desc_rec_new.asset_number :=
184: to_char(px_asset_hdr_rec.asset_id);
185: end if;

Line 218: elsif (px_asset_desc_rec_new.description = FND_API.G_MISS_CHAR) then

214: -- retain the old description
215: null;
216:
217: -- Check if user intentionally nulls out item.
218: elsif (px_asset_desc_rec_new.description = FND_API.G_MISS_CHAR) then
219: --l_asset_desc_rec.description := NULL;
220: null;
221: end if;
222:

Line 238: if (px_asset_desc_rec_new.tag_number = FND_API.G_MISS_CHAR) then

234: if (px_asset_desc_rec_new.tag_number is NOT NULL) then
235: if (nvl(l_asset_desc_rec.tag_number, '-999') <>
236: px_asset_desc_rec_new.tag_number) then
237:
238: if (px_asset_desc_rec_new.tag_number = FND_API.G_MISS_CHAR) then
239: --l_asset_desc_rec.tag_number := NULL;
240: null;
241: else
242:

Line 300: if (px_asset_desc_rec_new.serial_number = FND_API.G_MISS_CHAR) then

296: if (px_asset_desc_rec_new.serial_number is NOT NULL) then
297: if (nvl(l_asset_desc_rec.serial_number, '-999') <>
298: px_asset_desc_rec_new.serial_number) then
299:
300: if (px_asset_desc_rec_new.serial_number = FND_API.G_MISS_CHAR) then
301: --px_asset_desc_rec_new.serial_number := NULL;
302: null;
303: else
304: -- check whether update is allowed for Hierarchy Attached asset

Line 351: if (px_asset_desc_rec_new.asset_key_ccid = FND_API.G_MISS_NUM) then

347: if (px_asset_desc_rec_new.asset_key_ccid is NOT NULL) then
348: if (nvl(l_asset_desc_rec.asset_key_ccid, -999) <>
349: px_asset_desc_rec_new.asset_key_ccid) then
350:
351: if (px_asset_desc_rec_new.asset_key_ccid = FND_API.G_MISS_NUM) then
352: --px_asset_desc_rec_new.asset_key_ccid := NULL;
353:
354: if (NOT FA_ASSET_VAL_PVT.validate_asset_key (
355: p_transaction_type_code => px_trans_rec.transaction_type_code,

Line 411: if (px_asset_desc_rec_new.parent_asset_id = FND_API.G_MISS_NUM) then

407: if (px_asset_desc_rec_new.parent_asset_id is NOT NULL) then
408: if (nvl(l_asset_desc_rec.parent_asset_id, -999) <>
409: px_asset_desc_rec_new.parent_asset_id) then
410:
411: if (px_asset_desc_rec_new.parent_asset_id = FND_API.G_MISS_NUM) then
412: --px_asset_desc_rec_new.parent_asset_id := NULL;
413: null;
414: else
415: if (NOT FA_ASSET_VAL_PVT.validate_parent_asset(

Line 439: if (px_asset_desc_rec_new.manufacturer_name = FND_API.G_MISS_CHAR)

435: if (px_asset_desc_rec_new.manufacturer_name is NOT NULL) then
436: if (nvl(l_asset_desc_rec.manufacturer_name, '-999') <>
437: px_asset_desc_rec_new.manufacturer_name) then
438:
439: if (px_asset_desc_rec_new.manufacturer_name = FND_API.G_MISS_CHAR)
440: then null; --px_asset_desc_rec_new.manufacturer_name := NULL;
441: end if;
442:
443: l_asset_desc_rec.manufacturer_name :=

Line 479: if (px_asset_desc_rec_new.model_number = FND_API.G_MISS_CHAR) then

475: if (px_asset_desc_rec_new.model_number is NOT NULL) then
476: if (nvl(l_asset_desc_rec.model_number, '-999') <>
477: px_asset_desc_rec_new.model_number)
478: then
479: if (px_asset_desc_rec_new.model_number = FND_API.G_MISS_CHAR) then
480: --px_asset_desc_rec_new.model_number := NULL;
481: null;
482: end if;
483:

Line 500: if (px_asset_desc_rec_new.warranty_id = FND_API.G_MISS_NUM) then

496: if (px_asset_desc_rec_new.warranty_id is NOT NULL) then
497: if (nvl(l_asset_desc_rec.warranty_id, -999) <>
498: px_asset_desc_rec_new.warranty_id)
499: then
500: if (px_asset_desc_rec_new.warranty_id = FND_API.G_MISS_NUM) then
501: --px_asset_desc_rec_new.warranty_id := NULL;
502: null;
503: else
504: -- We will need dpis to validate warranty. Same in primary/rep

Line 538: if (px_asset_desc_rec_new.lease_id = FND_API.G_MISS_NUM) then

534: if (px_asset_desc_rec_new.lease_id is NOT NULL) then
535: if (nvl(l_asset_desc_rec.lease_id, -999) <>
536: px_asset_desc_rec_new.lease_id) then
537:
538: if (px_asset_desc_rec_new.lease_id = FND_API.G_MISS_NUM) then
539:
540: null;
541:
542: -- px_asset_desc_rec_new.lease_id := NULL;

Line 606: FND_API.G_MISS_CHAR)

602: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute1, '-999') <>
603: px_asset_desc_rec_new.lease_desc_flex.attribute1) then
604:
605: if (px_asset_desc_rec_new.lease_desc_flex.attribute1 =
606: FND_API.G_MISS_CHAR)
607: then null;
608: end if;
609:
610: l_asset_desc_rec.lease_desc_flex.attribute1 :=

Line 621: FND_API.G_MISS_CHAR)

617: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute2, '-999') <>
618: px_asset_desc_rec_new.lease_desc_flex.attribute2) then
619:
620: if (px_asset_desc_rec_new.lease_desc_flex.attribute2 =
621: FND_API.G_MISS_CHAR)
622: then null;
623: end if;
624:
625: l_asset_desc_rec.lease_desc_flex.attribute2 :=

Line 636: FND_API.G_MISS_CHAR)

632: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute3, '-999') <>
633: px_asset_desc_rec_new.lease_desc_flex.attribute3) then
634:
635: if (px_asset_desc_rec_new.lease_desc_flex.attribute3 =
636: FND_API.G_MISS_CHAR)
637: then null;
638: end if;
639:
640: l_asset_desc_rec.lease_desc_flex.attribute3 :=

Line 651: FND_API.G_MISS_CHAR)

647: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute4, '-999') <>
648: px_asset_desc_rec_new.lease_desc_flex.attribute4) then
649:
650: if (px_asset_desc_rec_new.lease_desc_flex.attribute4 =
651: FND_API.G_MISS_CHAR)
652: then null;
653: end if;
654:
655: l_asset_desc_rec.lease_desc_flex.attribute4 :=

Line 666: FND_API.G_MISS_CHAR)

662: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute5, '-999') <>
663: px_asset_desc_rec_new.lease_desc_flex.attribute5) then
664:
665: if (px_asset_desc_rec_new.lease_desc_flex.attribute5 =
666: FND_API.G_MISS_CHAR)
667: then null;
668: end if;
669:
670: l_asset_desc_rec.lease_desc_flex.attribute5 :=

Line 681: FND_API.G_MISS_CHAR)

677: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute6, '-999') <>
678: px_asset_desc_rec_new.lease_desc_flex.attribute6) then
679:
680: if (px_asset_desc_rec_new.lease_desc_flex.attribute6 =
681: FND_API.G_MISS_CHAR)
682: then null;
683: end if;
684:
685: l_asset_desc_rec.lease_desc_flex.attribute6 :=

Line 696: FND_API.G_MISS_CHAR)

692: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute7, '-999') <>
693: px_asset_desc_rec_new.lease_desc_flex.attribute7) then
694:
695: if (px_asset_desc_rec_new.lease_desc_flex.attribute7 =
696: FND_API.G_MISS_CHAR)
697: then null;
698: end if;
699:
700: l_asset_desc_rec.lease_desc_flex.attribute7 :=

Line 711: FND_API.G_MISS_CHAR)

707: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute8, '-999') <>
708: px_asset_desc_rec_new.lease_desc_flex.attribute8) then
709:
710: if (px_asset_desc_rec_new.lease_desc_flex.attribute8 =
711: FND_API.G_MISS_CHAR)
712: then null;
713: end if;
714:
715: l_asset_desc_rec.lease_desc_flex.attribute8 :=

Line 726: FND_API.G_MISS_CHAR)

722: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute9, '-999') <>
723: px_asset_desc_rec_new.lease_desc_flex.attribute9) then
724:
725: if (px_asset_desc_rec_new.lease_desc_flex.attribute9 =
726: FND_API.G_MISS_CHAR)
727: then null;
728: end if;
729:
730: l_asset_desc_rec.lease_desc_flex.attribute9 :=

Line 741: FND_API.G_MISS_CHAR)

737: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute10, '-999') <>
738: px_asset_desc_rec_new.lease_desc_flex.attribute10) then
739:
740: if (px_asset_desc_rec_new.lease_desc_flex.attribute10 =
741: FND_API.G_MISS_CHAR)
742: then null;
743: end if;
744:
745: l_asset_desc_rec.lease_desc_flex.attribute10 :=

Line 756: FND_API.G_MISS_CHAR)

752: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute11, '-999') <>
753: px_asset_desc_rec_new.lease_desc_flex.attribute11) then
754:
755: if (px_asset_desc_rec_new.lease_desc_flex.attribute11 =
756: FND_API.G_MISS_CHAR)
757: then null;
758: end if;
759:
760: l_asset_desc_rec.lease_desc_flex.attribute11 :=

Line 771: FND_API.G_MISS_CHAR)

767: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute12, '-999') <>
768: px_asset_desc_rec_new.lease_desc_flex.attribute12) then
769:
770: if (px_asset_desc_rec_new.lease_desc_flex.attribute12 =
771: FND_API.G_MISS_CHAR)
772: then null;
773: end if;
774:
775: l_asset_desc_rec.lease_desc_flex.attribute12 :=

Line 786: FND_API.G_MISS_CHAR)

782: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute13, '-999') <>
783: px_asset_desc_rec_new.lease_desc_flex.attribute13) then
784:
785: if (px_asset_desc_rec_new.lease_desc_flex.attribute13 =
786: FND_API.G_MISS_CHAR)
787: then null;
788: end if;
789:
790: l_asset_desc_rec.lease_desc_flex.attribute13 :=

Line 801: FND_API.G_MISS_CHAR)

797: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute14, '-999') <>
798: px_asset_desc_rec_new.lease_desc_flex.attribute14) then
799:
800: if (px_asset_desc_rec_new.lease_desc_flex.attribute14 =
801: FND_API.G_MISS_CHAR)
802: then null;
803: end if;
804:
805: l_asset_desc_rec.lease_desc_flex.attribute14 :=

Line 816: FND_API.G_MISS_CHAR)

812: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute15, '-999') <>
813: px_asset_desc_rec_new.lease_desc_flex.attribute15) then
814:
815: if (px_asset_desc_rec_new.lease_desc_flex.attribute15 =
816: FND_API.G_MISS_CHAR)
817: then null;
818: end if;
819:
820: l_asset_desc_rec.lease_desc_flex.attribute15 :=

Line 834: = FND_API.G_MISS_CHAR)

830: px_asset_desc_rec_new.lease_desc_flex.attribute_category_code)
831: then
832:
833: if (px_asset_desc_rec_new.lease_desc_flex.attribute_category_code
834: = FND_API.G_MISS_CHAR)
835: then null;
836: end if;
837:
838: l_asset_desc_rec.lease_desc_flex.attribute_category_code :=

Line 849: FND_API.G_MISS_CHAR)

845: if (nvl(l_asset_desc_rec.lease_desc_flex.context, '-999') <>
846: px_asset_desc_rec_new.lease_desc_flex.context) then
847:
848: if (px_asset_desc_rec_new.lease_desc_flex.context =
849: FND_API.G_MISS_CHAR)
850: then null;
851: end if;
852:
853: l_asset_desc_rec.lease_desc_flex.context :=

Line 873: if (px_asset_desc_rec_new.in_use_flag = FND_API.G_MISS_CHAR) then

869: if (nvl(l_asset_desc_rec.in_use_flag, '-999') <>
870: px_asset_desc_rec_new.in_use_flag)
871: then
872:
873: if (px_asset_desc_rec_new.in_use_flag = FND_API.G_MISS_CHAR) then
874: --px_asset_desc_rec_new.in_use_flag := NULL;
875: null;
876: end if;
877:

Line 894: if (px_asset_desc_rec_new.inventorial = FND_API.G_MISS_CHAR) then

890: if (px_asset_desc_rec_new.inventorial is NOT NULL) then
891: if (nvl(l_asset_desc_rec.inventorial, '-999') <> px_asset_desc_rec_new.inventorial)
892: then
893:
894: if (px_asset_desc_rec_new.inventorial = FND_API.G_MISS_CHAR) then
895: --px_asset_desc_rec_new.inventorial := NULL;
896: null;
897: end if;
898:

Line 944: if (px_asset_desc_rec_new.property_type_code = FND_API.G_MISS_CHAR)

940: if (px_asset_desc_rec_new.property_type_code is NOT NULL) then
941: if (nvl(l_asset_desc_rec.property_type_code, '-999') <>
942: px_asset_desc_rec_new.property_type_code) then
943:
944: if (px_asset_desc_rec_new.property_type_code = FND_API.G_MISS_CHAR)
945: then --px_asset_desc_rec_new.property_type_code := NULL;
946:
947: if (NOT FA_ASSET_VAL_PVT.validate_property_type(
948: p_property_type_code => NULL,

Line 977: FND_API.G_MISS_CHAR) then

973: if (nvl(l_asset_desc_rec.property_1245_1250_code, '-999') <>
974: px_asset_desc_rec_new.property_1245_1250_code) then
975:
976: if (px_asset_desc_rec_new.property_1245_1250_code =
977: FND_API.G_MISS_CHAR) then
978: --px_asset_desc_rec_new.property_1245_1250_code := NULL;
979:
980: if (NOT FA_ASSET_VAL_PVT.validate_1245_1250_code(
981: p_1245_1250_code => NULL,

Line 1009: if (px_asset_desc_rec_new.owned_leased = FND_API.G_MISS_CHAR) then

1005:
1006: if (px_asset_desc_rec_new.owned_leased is NOT NULL) then
1007: if (nvl(l_asset_desc_rec.owned_leased, '-999') <>
1008: px_asset_desc_rec_new.owned_leased) then
1009: if (px_asset_desc_rec_new.owned_leased = FND_API.G_MISS_CHAR) then
1010: null;
1011: --px_asset_desc_rec_new.owned_leased := NULL;
1012: end if;
1013:

Line 1029: if (px_asset_desc_rec_new.new_used = FND_API.G_MISS_CHAR) then

1025:
1026: if (px_asset_desc_rec_new.new_used is NOT NULL) then
1027: if (nvl(l_asset_desc_rec.new_used, '-999') <>
1028: px_asset_desc_rec_new.new_used) then
1029: if (px_asset_desc_rec_new.new_used = FND_API.G_MISS_CHAR) then
1030: --px_asset_desc_rec_new.new_used := NULL;
1031: null;
1032: end if;
1033:

Line 1050: if (px_asset_desc_rec_new.add_cost_je_flag = FND_API.G_MISS_CHAR) then

1046: if (px_asset_desc_rec_new.add_cost_je_flag is NOT NULL) then
1047: if (nvl(l_asset_desc_rec.add_cost_je_flag, '-999') <>
1048: px_asset_desc_rec_new.add_cost_je_flag) then
1049:
1050: if (px_asset_desc_rec_new.add_cost_je_flag = FND_API.G_MISS_CHAR) then
1051: --px_asset_desc_rec_new.add_cost_je_flag := NULL;
1052: null;
1053: end if;
1054:

Line 1072: if (px_asset_desc_rec_new.status = FND_API.G_MISS_CHAR) then

1068: if (px_asset_desc_rec_new.status is NOT NULL) then
1069: if (nvl(l_asset_desc_rec.status, '-999') <>
1070: px_asset_desc_rec_new.status) then
1071:
1072: if (px_asset_desc_rec_new.status = FND_API.G_MISS_CHAR) then
1073: --px_asset_desc_rec_new.status := NULL;
1074: null;
1075: end if;
1076:

Line 1108: if (FND_API.To_Boolean(p_commit)) then

1104: p_log_level_rec => g_log_level_rec)) then
1105: raise pub_error;
1106: end if;
1107:
1108: if (FND_API.To_Boolean(p_commit)) then
1109: commit;
1110: end if;
1111:
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1112: x_return_status := FND_API.G_RET_STS_SUCCESS;

1108: if (FND_API.To_Boolean(p_commit)) then
1109: commit;
1110: end if;
1111:
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;
1113:
1114: EXCEPTION
1115:
1116: when pub_error then

Line 1129: x_return_status := FND_API.G_RET_STS_ERROR;

1125: p_count => x_msg_count,
1126: p_data => x_msg_data
1127: );
1128:
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130:
1131: when others then
1132:
1133: ROLLBACK TO do_desc_update;

Line 1144: x_return_status := FND_API.G_RET_STS_ERROR;

1140: p_count => x_msg_count,
1141: p_data => x_msg_data
1142: );
1143:
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145:
1146: END update_desc;
1147:
1148:

Line 1281: p_asset_desc_rec_new.lease_id <> FND_API.G_MISS_NUM) then

1277: end if;
1278:
1279:
1280: if ( p_asset_desc_rec_new.lease_id is not null and
1281: p_asset_desc_rec_new.lease_id <> FND_API.G_MISS_NUM) then
1282:
1283: FA_DET_ADD_PKG.UPDATE_LEASE_DF
1284: (X_Lease_Id => p_asset_desc_rec_new.Lease_Id,
1285: X_Last_Update_Date => p_trans_rec.who_info.Last_Update_Date,

Line 1332: if ((p_asset_desc_rec_new.warranty_id = FND_API.G_MISS_NUM) and

1328: end if;
1329:
1330: -- Update warranty info
1331: if (p_asset_desc_rec_new.warranty_id is NOT NULL) then
1332: if ((p_asset_desc_rec_new.warranty_id = FND_API.G_MISS_NUM) and
1333: (p_old_warranty_id is NOT NULL)) then
1334: -- Remove an existing warranty from an asset
1335: FA_ADD_WARRANTY_PKG.Update_table(
1336: WR_warranty_id => NULL,

Line 1407: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1403:
1404: PROCEDURE update_invoice_desc(
1405: -- Standard Parameters --
1406: p_api_version IN NUMBER,
1407: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1410: x_return_status OUT NOCOPY VARCHAR2,
1411: x_msg_count OUT NOCOPY NUMBER,

Line 1408: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1404: PROCEDURE update_invoice_desc(
1405: -- Standard Parameters --
1406: p_api_version IN NUMBER,
1407: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1410: x_return_status OUT NOCOPY VARCHAR2,
1411: x_msg_count OUT NOCOPY NUMBER,
1412: x_msg_data OUT NOCOPY VARCHAR2,

Line 1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1405: -- Standard Parameters --
1406: p_api_version IN NUMBER,
1407: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1410: x_return_status OUT NOCOPY VARCHAR2,
1411: x_msg_count OUT NOCOPY NUMBER,
1412: x_msg_data OUT NOCOPY VARCHAR2,
1413: p_calling_fn IN VARCHAR2,

Line 1457: if (fnd_api.to_boolean(p_init_msg_list)) then

1453: end if;
1454: end if;
1455:
1456: -- Initialize message list if p_init_msg_list is set to TRUE.
1457: if (fnd_api.to_boolean(p_init_msg_list)) then
1458: -- initialize error message stack.
1459: fa_srvr_msg.init_server_message;
1460:
1461: -- initialize debug message stack.

Line 1467: if (NOT fnd_api.compatible_api_call (

1463: end if;
1464:
1465: -- Check version of the API
1466: -- Standard call to check for API call compatibility.
1467: if (NOT fnd_api.compatible_api_call (
1468: G_API_VERSION,
1469: p_api_version,
1470: G_API_NAME,
1471: G_PKG_NAME

Line 1589: if (px_inv_tbl_new(i).invoice_number = FND_API.G_MISS_CHAR) then

1585: if (px_inv_tbl_new(i).invoice_number is NOT NULL) then
1586: if (nvl(l_inv_rec.invoice_number, '-999') <>
1587: px_inv_tbl_new(i).invoice_number)
1588: then
1589: if (px_inv_tbl_new(i).invoice_number = FND_API.G_MISS_CHAR) then
1590: --px_inv_tbl_new(i).invoice_number := NULL;
1591: null;
1592: end if;
1593:

Line 1603: FND_API.G_MISS_NUM) then

1599: if (px_inv_tbl_new(i).ap_distribution_line_number is NOT NULL) then
1600: if (nvl(l_inv_rec.ap_distribution_line_number, -999) <>
1601: px_inv_tbl_new(i).ap_distribution_line_number) then
1602: if (px_inv_tbl_new(i).ap_distribution_line_number =
1603: FND_API.G_MISS_NUM) then
1604: --px_inv_tbl_new(i).ap_distribution_line_number := NULL;
1605: null;
1606: end if;
1607:

Line 1618: if (px_inv_tbl_new(i).invoice_line_number = FND_API.G_MISS_NUM) then

1614: if (px_inv_tbl_new(i).invoice_line_number is NOT NULL) then
1615: if (nvl(l_inv_rec.invoice_line_number, '-999') <>
1616: px_inv_tbl_new(i).invoice_line_number)
1617: then
1618: if (px_inv_tbl_new(i).invoice_line_number = FND_API.G_MISS_NUM) then
1619: --px_inv_tbl_new(i).invoice_line_number := NULL;
1620: null;
1621: end if;
1622:

Line 1632: if (px_inv_tbl_new(i).invoice_distribution_id = FND_API.G_MISS_NUM) then

1628: if (px_inv_tbl_new(i).invoice_distribution_id is NOT NULL) then
1629: if (nvl(l_inv_rec.invoice_distribution_id, '-999') <>
1630: px_inv_tbl_new(i).invoice_distribution_id)
1631: then
1632: if (px_inv_tbl_new(i).invoice_distribution_id = FND_API.G_MISS_NUM) then
1633: --px_inv_tbl_new(i).invoice_distribution_id := NULL;
1634: null;
1635: end if;
1636:

Line 1646: if (px_inv_tbl_new(i).po_distribution_id = FND_API.G_MISS_NUM) then

1642: if (px_inv_tbl_new(i).po_distribution_id is NOT NULL) then
1643: if (nvl(l_inv_rec.po_distribution_id, '-999') <>
1644: px_inv_tbl_new(i).po_distribution_id)
1645: then
1646: if (px_inv_tbl_new(i).po_distribution_id = FND_API.G_MISS_NUM) then
1647: --px_inv_tbl_new(i).po_distribution_id := NULL;
1648: null;
1649: end if;
1650:

Line 1659: if (px_inv_tbl_new(i).description = FND_API.G_MISS_CHAR) then

1655: -- Description
1656: if (px_inv_tbl_new(i).description is NOT NULL) then
1657: if (nvl(l_inv_rec.description, '-999') <>
1658: px_inv_tbl_new(i).description) then
1659: if (px_inv_tbl_new(i).description = FND_API.G_MISS_CHAR) then
1660: --px_inv_tbl_new(i).description := NULL;
1661: null;
1662: end if;
1663:

Line 1672: if (px_inv_tbl_new(i).deleted_flag = FND_API.G_MISS_CHAR) then

1668: -- Deleted_Flag
1669: if (px_inv_tbl_new(i).deleted_flag is NOT NULL) then
1670: if (nvl(l_inv_rec.deleted_flag, '-999') <>
1671: px_inv_tbl_new(i).deleted_flag) then
1672: if (px_inv_tbl_new(i).deleted_flag = FND_API.G_MISS_CHAR) then
1673: --px_inv_tbl_new(i).deleted_flag := NULL;
1674: null;
1675: end if;
1676:

Line 1686: if (px_inv_tbl_new(i).po_vendor_id = FND_API.G_MISS_NUM) then

1682: -- PO_Vendor_Id
1683: if (px_inv_tbl_new(i).po_vendor_id is NOT NULL) then
1684: if (nvl(l_inv_rec.po_vendor_id, -999) <>
1685: px_inv_tbl_new(i).po_vendor_id) then
1686: if (px_inv_tbl_new(i).po_vendor_id = FND_API.G_MISS_NUM) then
1687: --px_inv_tbl_new(i).po_vendor_id := NULL;
1688: null;
1689: end if;
1690:

Line 1699: if (px_inv_tbl_new(i).po_number = FND_API.G_MISS_CHAR) then

1695: -- PO_Number
1696: if (px_inv_tbl_new(i).po_number is NOT NULL) then
1697: if (nvl(l_inv_rec.po_number, '-999') <>
1698: px_inv_tbl_new(i).po_number) then
1699: if (px_inv_tbl_new(i).po_number = FND_API.G_MISS_CHAR) then
1700: --px_inv_tbl_new(i).po_number := NULL;
1701: null;
1702: end if;
1703:

Line 1712: if (px_inv_tbl_new(i).payables_batch_name = FND_API.G_MISS_CHAR)

1708: -- Payables_Batch_Name
1709: if (px_inv_tbl_new(i).payables_batch_name is NOT NULL) then
1710: if (nvl(l_inv_rec.payables_batch_name, '-999') <>
1711: px_inv_tbl_new(i).payables_batch_name) then
1712: if (px_inv_tbl_new(i).payables_batch_name = FND_API.G_MISS_CHAR)
1713: then null; --px_inv_tbl_new(i).payables_batch_name := NULL;
1714: end if;
1715:
1716: l_inv_rec.payables_batch_name :=

Line 1726: FND_API.G_MISS_NUM) then

1722: if (px_inv_tbl_new(i).project_asset_line_id is NOT NULL) then
1723: if (nvl(l_inv_rec.project_asset_line_id, -999) <>
1724: px_inv_tbl_new(i).project_asset_line_id) then
1725: if (px_inv_tbl_new(i).project_asset_line_id =
1726: FND_API.G_MISS_NUM) then
1727: --px_inv_tbl_new(i).project_asset_line_id := NULL;
1728: null;
1729: end if;
1730:

Line 1740: if (px_inv_tbl_new(i).project_id = FND_API.G_MISS_NUM) then

1736: -- Project_Id
1737: if (px_inv_tbl_new(i).project_id is NOT NULL) then
1738: if (nvl(l_inv_rec.project_id, -999) <>
1739: px_inv_tbl_new(i).project_id) then
1740: if (px_inv_tbl_new(i).project_id = FND_API.G_MISS_NUM) then
1741: --px_inv_tbl_new(i).project_id := NULL;
1742: null;
1743: end if;
1744:

Line 1752: if (px_inv_tbl_new(i).task_id = FND_API.G_MISS_NUM) then

1748:
1749: -- Task_Id
1750: if (px_inv_tbl_new(i).task_id is NOT NULL) then
1751: if (nvl(l_inv_rec.task_id, -999) <> px_inv_tbl_new(i).task_id) then
1752: if (px_inv_tbl_new(i).task_id = FND_API.G_MISS_NUM) then
1753: --px_inv_tbl_new(i).task_id := NULL;
1754: null;
1755: end if;
1756:

Line 1766: FND_API.G_MISS_CHAR) then

1762: if (px_inv_tbl_new(i).material_indicator_flag is NOT NULL) then
1763: if (nvl(l_inv_rec.material_indicator_flag, '-999') <>
1764: px_inv_tbl_new(i).material_indicator_flag) then
1765: if (px_inv_tbl_new(i).material_indicator_flag =
1766: FND_API.G_MISS_CHAR) then
1767: --px_inv_tbl_new(i).material_indicator_flag := NULL;
1768: null;
1769: end if;
1770:

Line 1982: if (fnd_api.to_boolean (p_commit)) then

1978: end loop;
1979: end loop;
1980:
1981: -- commit if p_commit is TRUE.
1982: if (fnd_api.to_boolean (p_commit)) then
1983: COMMIT WORK;
1984: end if;
1985:
1986: -- Reset the gl_sob profile to this book

Line 1996: x_return_status := FND_API.G_RET_STS_SUCCESS;

1992: p_count => x_msg_count,
1993: p_data => x_msg_data
1994: );
1995:
1996: x_return_status := FND_API.G_RET_STS_SUCCESS;
1997:
1998: EXCEPTION
1999:
2000: WHEN inv_err THEN

Line 2017: x_return_status := FND_API.G_RET_STS_ERROR;

2013: p_count => x_msg_count,
2014: p_data => x_msg_data
2015: );
2016:
2017: x_return_status := FND_API.G_RET_STS_ERROR;
2018:
2019: WHEN OTHERS THEN
2020:
2021: ROLLBACK TO do_invoice_desc_update;

Line 2036: x_return_status := FND_API.G_RET_STS_ERROR;

2032: p_count => x_msg_count,
2033: p_data => x_msg_data
2034: );
2035:
2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037:
2038: END update_invoice_desc;
2039:
2040: PROCEDURE update_retirement_desc(

Line 2043: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2039:
2040: PROCEDURE update_retirement_desc(
2041: -- Standard Parameters --
2042: p_api_version IN NUMBER,
2043: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2044: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2045: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2046: x_return_status OUT NOCOPY VARCHAR2,
2047: x_msg_count OUT NOCOPY NUMBER,

Line 2044: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2040: PROCEDURE update_retirement_desc(
2041: -- Standard Parameters --
2042: p_api_version IN NUMBER,
2043: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2044: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2045: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2046: x_return_status OUT NOCOPY VARCHAR2,
2047: x_msg_count OUT NOCOPY NUMBER,
2048: x_msg_data OUT NOCOPY VARCHAR2,

Line 2045: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2041: -- Standard Parameters --
2042: p_api_version IN NUMBER,
2043: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2044: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2045: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2046: x_return_status OUT NOCOPY VARCHAR2,
2047: x_msg_count OUT NOCOPY NUMBER,
2048: x_msg_data OUT NOCOPY VARCHAR2,
2049: p_calling_fn IN VARCHAR2,

Line 2087: if (fnd_api.to_boolean(p_init_msg_list)) then

2083: end if;
2084: end if;
2085:
2086: -- Initialize message list if p_init_msg_list is set to TRUE.
2087: if (fnd_api.to_boolean(p_init_msg_list)) then
2088: -- initialize error message stack.
2089: fa_srvr_msg.init_server_message;
2090:
2091: -- initialize debug message stack.

Line 2097: if (NOT fnd_api.compatible_api_call (

2093: end if;
2094:
2095: -- Check version of the API
2096: -- Standard call to check for API call compatibility.
2097: if (NOT fnd_api.compatible_api_call (
2098: G_API_VERSION,
2099: p_api_version,
2100: G_API_NAME,
2101: G_PKG_NAME

Line 2238: if (px_asset_retire_rec_new.status = FND_API.G_MISS_CHAR) then

2234:
2235: -- Status
2236: if (px_asset_retire_rec_new.status is NOT NULL) then
2237: if (l_asset_retire_rec.status <> px_asset_retire_rec_new.status) then
2238: if (px_asset_retire_rec_new.status = FND_API.G_MISS_CHAR) then
2239: --px_asset_retire_rec_new.status := NULL;
2240: null;
2241: end if;
2242:

Line 2252: FND_API.G_MISS_CHAR) then

2248: if (px_asset_retire_rec_new.retirement_type_code is NOT NULL) then
2249: if (nvl(l_asset_retire_rec.retirement_type_code, '-999') <>
2250: px_asset_retire_rec_new.retirement_type_code) then
2251: if (px_asset_retire_rec_new.retirement_type_code =
2252: FND_API.G_MISS_CHAR) then
2253: --px_asset_retire_rec_new.retirement_type_code := NULL;
2254: null;
2255: end if;
2256:

Line 2268: FND_API.G_MISS_CHAR) then

2264: then
2265: if (l_asset_retire_rec.retirement_prorate_convention <>
2266: px_asset_retire_rec_new.retirement_prorate_convention) then
2267: if (px_asset_retire_rec_new.retirement_prorate_convention =
2268: FND_API.G_MISS_CHAR) then
2269: --px_asset_retire_rec_new.retirement_prorate_convention := NULL;
2270: null;
2271: end if;
2272:

Line 2282: if (px_asset_retire_rec_new.proceeds_of_sale = FND_API.G_MISS_NUM)

2278: -- Proceeds of Sale
2279: if (px_asset_retire_rec_new.proceeds_of_sale is NOT NULL) then
2280: if (nvl(l_asset_retire_rec.proceeds_of_sale, -999) <>
2281: px_asset_retire_rec_new.proceeds_of_sale) then
2282: if (px_asset_retire_rec_new.proceeds_of_sale = FND_API.G_MISS_NUM)
2283: then null; --px_asset_retire_rec_new.proceeds_of_sale := NULL;
2284: end if;
2285:
2286: -- Fix for Bug #2368292. Need to account for reporting books

Line 2360: if (px_asset_retire_rec_new.cost_of_removal = FND_API.G_MISS_NUM)

2356: -- Cost of Removal
2357: if (px_asset_retire_rec_new.cost_of_removal is NOT NULL) then
2358: if (nvl(l_asset_retire_rec.cost_of_removal, -999) <>
2359: px_asset_retire_rec_new.cost_of_removal) then
2360: if (px_asset_retire_rec_new.cost_of_removal = FND_API.G_MISS_NUM)
2361: then null; --px_asset_retire_rec_new.cost_of_removal := NULL;
2362: end if;
2363:
2364: -- Fix for Bug #2368292. Need to account for reporting books

Line 2434: FND_API.G_MISS_CHAR) then

2430: if (px_asset_retire_rec_new.detail_info.stl_method_code is NOT NULL) then
2431: if (nvl(l_asset_retire_rec.detail_info.stl_method_code, '-999') <>
2432: px_asset_retire_rec_new.detail_info.stl_method_code) then
2433: if (px_asset_retire_rec_new.detail_info.stl_method_code =
2434: FND_API.G_MISS_CHAR) then
2435: null;
2436: --px_asset_retire_rec_new.detail_info.stl_method_code := NULL;
2437: end if;
2438:

Line 2450: FND_API.G_MISS_NUM) then

2446: then
2447: if (nvl(l_asset_retire_rec.detail_info.stl_life_in_months, -999) <>
2448: px_asset_retire_rec_new.detail_info.stl_life_in_months) then
2449: if (px_asset_retire_rec_new.detail_info.stl_life_in_months =
2450: FND_API.G_MISS_NUM) then
2451: --px_asset_retire_rec_new.detail_info.stl_life_in_months := NULL;
2452: null;
2453: end if;
2454:

Line 2464: if (px_asset_retire_rec_new.reference_num = FND_API.G_MISS_CHAR)

2460: -- Reference Num
2461: if (px_asset_retire_rec_new.reference_num is NOT NULL) then
2462: if (nvl(l_asset_retire_rec.reference_num, '-999') <>
2463: px_asset_retire_rec_new.reference_num) then
2464: if (px_asset_retire_rec_new.reference_num = FND_API.G_MISS_CHAR)
2465: then null; --px_asset_retire_rec_new.reference_num := NULL;
2466: end if;
2467:
2468: l_asset_retire_rec.reference_num :=

Line 2478: if (px_asset_retire_rec_new.sold_to = FND_API.G_MISS_CHAR) then

2474: if (px_asset_retire_rec_new.sold_to is NOT NULL) then
2475: if (nvl(l_asset_retire_rec.sold_to, '-999') <>
2476: px_asset_retire_rec_new.sold_to)
2477: then
2478: if (px_asset_retire_rec_new.sold_to = FND_API.G_MISS_CHAR) then
2479: null;
2480: --px_asset_retire_rec_new.sold_to := NULL;
2481: end if;
2482:

Line 2491: if (px_asset_retire_rec_new.trade_in_asset_id = FND_API.G_MISS_NUM)

2487: -- Trade In Asset Id
2488: if (px_asset_retire_rec_new.trade_in_asset_id is NOT NULL) then
2489: if (nvl(l_asset_retire_rec.trade_in_asset_id, -999) <>
2490: px_asset_retire_rec_new.trade_in_asset_id) then
2491: if (px_asset_retire_rec_new.trade_in_asset_id = FND_API.G_MISS_NUM)
2492: then null; --px_asset_retire_rec_new.trade_in_asset_id := NULL;
2493: end if;
2494:
2495: l_asset_retire_rec.trade_in_asset_id :=

Line 2709: if (fnd_api.to_boolean (p_commit)) then

2705:
2706: end loop;
2707:
2708: -- commit if p_commit is TRUE.
2709: if (fnd_api.to_boolean (p_commit)) then
2710: COMMIT WORK;
2711: end if;
2712:
2713: -- Reset the gl_sob profile to this book

Line 2723: x_return_status := FND_API.G_RET_STS_SUCCESS;

2719: p_count => x_msg_count,
2720: p_data => x_msg_data
2721: );
2722:
2723: x_return_status := FND_API.G_RET_STS_SUCCESS;
2724:
2725: EXCEPTION
2726:
2727: WHEN ret_err THEN

Line 2744: x_return_status := FND_API.G_RET_STS_ERROR;

2740: p_count => x_msg_count,
2741: p_data => x_msg_data
2742: );
2743:
2744: x_return_status := FND_API.G_RET_STS_ERROR;
2745:
2746: WHEN OTHERS THEN
2747:
2748: ROLLBACK TO do_retirement_desc_update;

Line 2763: x_return_status := FND_API.G_RET_STS_ERROR;

2759: p_count => x_msg_count,
2760: p_data => x_msg_data
2761: );
2762:
2763: x_return_status := FND_API.G_RET_STS_ERROR;
2764:
2765: END update_retirement_desc;
2766:
2767:

Line 2824: if (px_asset_cat_rec.desc_flex.attribute1 = FND_API.G_MISS_CHAR) then

2820:
2821: -- commenting this for bug 2700227
2822: --px_asset_cat_rec.desc_flex.context := l_concat_string;
2823: /*
2824: if (px_asset_cat_rec.desc_flex.attribute1 = FND_API.G_MISS_CHAR) then
2825: px_asset_cat_rec.desc_flex.attribute1 := null;
2826: end if;
2827: if (px_asset_cat_rec.desc_flex.attribute2 = FND_API.G_MISS_CHAR) then
2828: px_asset_cat_rec.desc_flex.attribute2 := null;

Line 2827: if (px_asset_cat_rec.desc_flex.attribute2 = FND_API.G_MISS_CHAR) then

2823: /*
2824: if (px_asset_cat_rec.desc_flex.attribute1 = FND_API.G_MISS_CHAR) then
2825: px_asset_cat_rec.desc_flex.attribute1 := null;
2826: end if;
2827: if (px_asset_cat_rec.desc_flex.attribute2 = FND_API.G_MISS_CHAR) then
2828: px_asset_cat_rec.desc_flex.attribute2 := null;
2829: end if;
2830: if (px_asset_cat_rec.desc_flex.attribute3 = FND_API.G_MISS_CHAR) then
2831: px_asset_cat_rec.desc_flex.attribute3 := null;

Line 2830: if (px_asset_cat_rec.desc_flex.attribute3 = FND_API.G_MISS_CHAR) then

2826: end if;
2827: if (px_asset_cat_rec.desc_flex.attribute2 = FND_API.G_MISS_CHAR) then
2828: px_asset_cat_rec.desc_flex.attribute2 := null;
2829: end if;
2830: if (px_asset_cat_rec.desc_flex.attribute3 = FND_API.G_MISS_CHAR) then
2831: px_asset_cat_rec.desc_flex.attribute3 := null;
2832: end if;
2833: if (px_asset_cat_rec.desc_flex.attribute4 = FND_API.G_MISS_CHAR) then
2834: px_asset_cat_rec.desc_flex.attribute4 := null;

Line 2833: if (px_asset_cat_rec.desc_flex.attribute4 = FND_API.G_MISS_CHAR) then

2829: end if;
2830: if (px_asset_cat_rec.desc_flex.attribute3 = FND_API.G_MISS_CHAR) then
2831: px_asset_cat_rec.desc_flex.attribute3 := null;
2832: end if;
2833: if (px_asset_cat_rec.desc_flex.attribute4 = FND_API.G_MISS_CHAR) then
2834: px_asset_cat_rec.desc_flex.attribute4 := null;
2835: end if;
2836: if (px_asset_cat_rec.desc_flex.attribute5 = FND_API.G_MISS_CHAR) then
2837: px_asset_cat_rec.desc_flex.attribute5 := null;

Line 2836: if (px_asset_cat_rec.desc_flex.attribute5 = FND_API.G_MISS_CHAR) then

2832: end if;
2833: if (px_asset_cat_rec.desc_flex.attribute4 = FND_API.G_MISS_CHAR) then
2834: px_asset_cat_rec.desc_flex.attribute4 := null;
2835: end if;
2836: if (px_asset_cat_rec.desc_flex.attribute5 = FND_API.G_MISS_CHAR) then
2837: px_asset_cat_rec.desc_flex.attribute5 := null;
2838: end if;
2839: if (px_asset_cat_rec.desc_flex.attribute6 = FND_API.G_MISS_CHAR) then
2840: px_asset_cat_rec.desc_flex.attribute6 := null;

Line 2839: if (px_asset_cat_rec.desc_flex.attribute6 = FND_API.G_MISS_CHAR) then

2835: end if;
2836: if (px_asset_cat_rec.desc_flex.attribute5 = FND_API.G_MISS_CHAR) then
2837: px_asset_cat_rec.desc_flex.attribute5 := null;
2838: end if;
2839: if (px_asset_cat_rec.desc_flex.attribute6 = FND_API.G_MISS_CHAR) then
2840: px_asset_cat_rec.desc_flex.attribute6 := null;
2841: end if;
2842: if (px_asset_cat_rec.desc_flex.attribute7 = FND_API.G_MISS_CHAR) then
2843: px_asset_cat_rec.desc_flex.attribute7 := null;

Line 2842: if (px_asset_cat_rec.desc_flex.attribute7 = FND_API.G_MISS_CHAR) then

2838: end if;
2839: if (px_asset_cat_rec.desc_flex.attribute6 = FND_API.G_MISS_CHAR) then
2840: px_asset_cat_rec.desc_flex.attribute6 := null;
2841: end if;
2842: if (px_asset_cat_rec.desc_flex.attribute7 = FND_API.G_MISS_CHAR) then
2843: px_asset_cat_rec.desc_flex.attribute7 := null;
2844: end if;
2845: if (px_asset_cat_rec.desc_flex.attribute8 = FND_API.G_MISS_CHAR) then
2846: px_asset_cat_rec.desc_flex.attribute8 := null;

Line 2845: if (px_asset_cat_rec.desc_flex.attribute8 = FND_API.G_MISS_CHAR) then

2841: end if;
2842: if (px_asset_cat_rec.desc_flex.attribute7 = FND_API.G_MISS_CHAR) then
2843: px_asset_cat_rec.desc_flex.attribute7 := null;
2844: end if;
2845: if (px_asset_cat_rec.desc_flex.attribute8 = FND_API.G_MISS_CHAR) then
2846: px_asset_cat_rec.desc_flex.attribute8 := null;
2847: end if;
2848: if (px_asset_cat_rec.desc_flex.attribute9 = FND_API.G_MISS_CHAR) then
2849: px_asset_cat_rec.desc_flex.attribute9 := null;

Line 2848: if (px_asset_cat_rec.desc_flex.attribute9 = FND_API.G_MISS_CHAR) then

2844: end if;
2845: if (px_asset_cat_rec.desc_flex.attribute8 = FND_API.G_MISS_CHAR) then
2846: px_asset_cat_rec.desc_flex.attribute8 := null;
2847: end if;
2848: if (px_asset_cat_rec.desc_flex.attribute9 = FND_API.G_MISS_CHAR) then
2849: px_asset_cat_rec.desc_flex.attribute9 := null;
2850: end if;
2851: if (px_asset_cat_rec.desc_flex.attribute10 = FND_API.G_MISS_CHAR) then
2852: px_asset_cat_rec.desc_flex.attribute10 := null;

Line 2851: if (px_asset_cat_rec.desc_flex.attribute10 = FND_API.G_MISS_CHAR) then

2847: end if;
2848: if (px_asset_cat_rec.desc_flex.attribute9 = FND_API.G_MISS_CHAR) then
2849: px_asset_cat_rec.desc_flex.attribute9 := null;
2850: end if;
2851: if (px_asset_cat_rec.desc_flex.attribute10 = FND_API.G_MISS_CHAR) then
2852: px_asset_cat_rec.desc_flex.attribute10 := null;
2853: end if;
2854: if (px_asset_cat_rec.desc_flex.attribute11 = FND_API.G_MISS_CHAR) then
2855: px_asset_cat_rec.desc_flex.attribute11 := null;

Line 2854: if (px_asset_cat_rec.desc_flex.attribute11 = FND_API.G_MISS_CHAR) then

2850: end if;
2851: if (px_asset_cat_rec.desc_flex.attribute10 = FND_API.G_MISS_CHAR) then
2852: px_asset_cat_rec.desc_flex.attribute10 := null;
2853: end if;
2854: if (px_asset_cat_rec.desc_flex.attribute11 = FND_API.G_MISS_CHAR) then
2855: px_asset_cat_rec.desc_flex.attribute11 := null;
2856: end if;
2857: if (px_asset_cat_rec.desc_flex.attribute12 = FND_API.G_MISS_CHAR) then
2858: px_asset_cat_rec.desc_flex.attribute12 := null;

Line 2857: if (px_asset_cat_rec.desc_flex.attribute12 = FND_API.G_MISS_CHAR) then

2853: end if;
2854: if (px_asset_cat_rec.desc_flex.attribute11 = FND_API.G_MISS_CHAR) then
2855: px_asset_cat_rec.desc_flex.attribute11 := null;
2856: end if;
2857: if (px_asset_cat_rec.desc_flex.attribute12 = FND_API.G_MISS_CHAR) then
2858: px_asset_cat_rec.desc_flex.attribute12 := null;
2859: end if;
2860: if (px_asset_cat_rec.desc_flex.attribute13 = FND_API.G_MISS_CHAR) then
2861: px_asset_cat_rec.desc_flex.attribute13 := null;

Line 2860: if (px_asset_cat_rec.desc_flex.attribute13 = FND_API.G_MISS_CHAR) then

2856: end if;
2857: if (px_asset_cat_rec.desc_flex.attribute12 = FND_API.G_MISS_CHAR) then
2858: px_asset_cat_rec.desc_flex.attribute12 := null;
2859: end if;
2860: if (px_asset_cat_rec.desc_flex.attribute13 = FND_API.G_MISS_CHAR) then
2861: px_asset_cat_rec.desc_flex.attribute13 := null;
2862: end if;
2863: if (px_asset_cat_rec.desc_flex.attribute14 = FND_API.G_MISS_CHAR) then
2864: px_asset_cat_rec.desc_flex.attribute14 := null;

Line 2863: if (px_asset_cat_rec.desc_flex.attribute14 = FND_API.G_MISS_CHAR) then

2859: end if;
2860: if (px_asset_cat_rec.desc_flex.attribute13 = FND_API.G_MISS_CHAR) then
2861: px_asset_cat_rec.desc_flex.attribute13 := null;
2862: end if;
2863: if (px_asset_cat_rec.desc_flex.attribute14 = FND_API.G_MISS_CHAR) then
2864: px_asset_cat_rec.desc_flex.attribute14 := null;
2865: end if;
2866: if (px_asset_cat_rec.desc_flex.attribute15 = FND_API.G_MISS_CHAR) then
2867: px_asset_cat_rec.desc_flex.attribute15 := null;

Line 2866: if (px_asset_cat_rec.desc_flex.attribute15 = FND_API.G_MISS_CHAR) then

2862: end if;
2863: if (px_asset_cat_rec.desc_flex.attribute14 = FND_API.G_MISS_CHAR) then
2864: px_asset_cat_rec.desc_flex.attribute14 := null;
2865: end if;
2866: if (px_asset_cat_rec.desc_flex.attribute15 = FND_API.G_MISS_CHAR) then
2867: px_asset_cat_rec.desc_flex.attribute15 := null;
2868: end if;
2869: if (px_asset_cat_rec.desc_flex.attribute16 = FND_API.G_MISS_CHAR) then
2870: px_asset_cat_rec.desc_flex.attribute16 := null;

Line 2869: if (px_asset_cat_rec.desc_flex.attribute16 = FND_API.G_MISS_CHAR) then

2865: end if;
2866: if (px_asset_cat_rec.desc_flex.attribute15 = FND_API.G_MISS_CHAR) then
2867: px_asset_cat_rec.desc_flex.attribute15 := null;
2868: end if;
2869: if (px_asset_cat_rec.desc_flex.attribute16 = FND_API.G_MISS_CHAR) then
2870: px_asset_cat_rec.desc_flex.attribute16 := null;
2871: end if;
2872: if (px_asset_cat_rec.desc_flex.attribute17 = FND_API.G_MISS_CHAR) then
2873: px_asset_cat_rec.desc_flex.attribute17 := null;

Line 2872: if (px_asset_cat_rec.desc_flex.attribute17 = FND_API.G_MISS_CHAR) then

2868: end if;
2869: if (px_asset_cat_rec.desc_flex.attribute16 = FND_API.G_MISS_CHAR) then
2870: px_asset_cat_rec.desc_flex.attribute16 := null;
2871: end if;
2872: if (px_asset_cat_rec.desc_flex.attribute17 = FND_API.G_MISS_CHAR) then
2873: px_asset_cat_rec.desc_flex.attribute17 := null;
2874: end if;
2875: if (px_asset_cat_rec.desc_flex.attribute18 = FND_API.G_MISS_CHAR) then
2876: px_asset_cat_rec.desc_flex.attribute18 := null;

Line 2875: if (px_asset_cat_rec.desc_flex.attribute18 = FND_API.G_MISS_CHAR) then

2871: end if;
2872: if (px_asset_cat_rec.desc_flex.attribute17 = FND_API.G_MISS_CHAR) then
2873: px_asset_cat_rec.desc_flex.attribute17 := null;
2874: end if;
2875: if (px_asset_cat_rec.desc_flex.attribute18 = FND_API.G_MISS_CHAR) then
2876: px_asset_cat_rec.desc_flex.attribute18 := null;
2877: end if;
2878: if (px_asset_cat_rec.desc_flex.attribute19 = FND_API.G_MISS_CHAR) then
2879: px_asset_cat_rec.desc_flex.attribute19 := null;

Line 2878: if (px_asset_cat_rec.desc_flex.attribute19 = FND_API.G_MISS_CHAR) then

2874: end if;
2875: if (px_asset_cat_rec.desc_flex.attribute18 = FND_API.G_MISS_CHAR) then
2876: px_asset_cat_rec.desc_flex.attribute18 := null;
2877: end if;
2878: if (px_asset_cat_rec.desc_flex.attribute19 = FND_API.G_MISS_CHAR) then
2879: px_asset_cat_rec.desc_flex.attribute19 := null;
2880: end if;
2881: if (px_asset_cat_rec.desc_flex.attribute20 = FND_API.G_MISS_CHAR) then
2882: px_asset_cat_rec.desc_flex.attribute20 := null;

Line 2881: if (px_asset_cat_rec.desc_flex.attribute20 = FND_API.G_MISS_CHAR) then

2877: end if;
2878: if (px_asset_cat_rec.desc_flex.attribute19 = FND_API.G_MISS_CHAR) then
2879: px_asset_cat_rec.desc_flex.attribute19 := null;
2880: end if;
2881: if (px_asset_cat_rec.desc_flex.attribute20 = FND_API.G_MISS_CHAR) then
2882: px_asset_cat_rec.desc_flex.attribute20 := null;
2883: end if;
2884: if (px_asset_cat_rec.desc_flex.attribute21 = FND_API.G_MISS_CHAR) then
2885: px_asset_cat_rec.desc_flex.attribute21 := null;

Line 2884: if (px_asset_cat_rec.desc_flex.attribute21 = FND_API.G_MISS_CHAR) then

2880: end if;
2881: if (px_asset_cat_rec.desc_flex.attribute20 = FND_API.G_MISS_CHAR) then
2882: px_asset_cat_rec.desc_flex.attribute20 := null;
2883: end if;
2884: if (px_asset_cat_rec.desc_flex.attribute21 = FND_API.G_MISS_CHAR) then
2885: px_asset_cat_rec.desc_flex.attribute21 := null;
2886: end if;
2887: if (px_asset_cat_rec.desc_flex.attribute22 = FND_API.G_MISS_CHAR) then
2888: px_asset_cat_rec.desc_flex.attribute22 := null;

Line 2887: if (px_asset_cat_rec.desc_flex.attribute22 = FND_API.G_MISS_CHAR) then

2883: end if;
2884: if (px_asset_cat_rec.desc_flex.attribute21 = FND_API.G_MISS_CHAR) then
2885: px_asset_cat_rec.desc_flex.attribute21 := null;
2886: end if;
2887: if (px_asset_cat_rec.desc_flex.attribute22 = FND_API.G_MISS_CHAR) then
2888: px_asset_cat_rec.desc_flex.attribute22 := null;
2889: end if;
2890: if (px_asset_cat_rec.desc_flex.attribute23 = FND_API.G_MISS_CHAR) then
2891: px_asset_cat_rec.desc_flex.attribute23 := null;

Line 2890: if (px_asset_cat_rec.desc_flex.attribute23 = FND_API.G_MISS_CHAR) then

2886: end if;
2887: if (px_asset_cat_rec.desc_flex.attribute22 = FND_API.G_MISS_CHAR) then
2888: px_asset_cat_rec.desc_flex.attribute22 := null;
2889: end if;
2890: if (px_asset_cat_rec.desc_flex.attribute23 = FND_API.G_MISS_CHAR) then
2891: px_asset_cat_rec.desc_flex.attribute23 := null;
2892: end if;
2893: if (px_asset_cat_rec.desc_flex.attribute24 = FND_API.G_MISS_CHAR) then
2894: px_asset_cat_rec.desc_flex.attribute24 := null;

Line 2893: if (px_asset_cat_rec.desc_flex.attribute24 = FND_API.G_MISS_CHAR) then

2889: end if;
2890: if (px_asset_cat_rec.desc_flex.attribute23 = FND_API.G_MISS_CHAR) then
2891: px_asset_cat_rec.desc_flex.attribute23 := null;
2892: end if;
2893: if (px_asset_cat_rec.desc_flex.attribute24 = FND_API.G_MISS_CHAR) then
2894: px_asset_cat_rec.desc_flex.attribute24 := null;
2895: end if;
2896: if (px_asset_cat_rec.desc_flex.attribute25 = FND_API.G_MISS_CHAR) then
2897: px_asset_cat_rec.desc_flex.attribute25 := null;

Line 2896: if (px_asset_cat_rec.desc_flex.attribute25 = FND_API.G_MISS_CHAR) then

2892: end if;
2893: if (px_asset_cat_rec.desc_flex.attribute24 = FND_API.G_MISS_CHAR) then
2894: px_asset_cat_rec.desc_flex.attribute24 := null;
2895: end if;
2896: if (px_asset_cat_rec.desc_flex.attribute25 = FND_API.G_MISS_CHAR) then
2897: px_asset_cat_rec.desc_flex.attribute25 := null;
2898: end if;
2899: if (px_asset_cat_rec.desc_flex.attribute26 = FND_API.G_MISS_CHAR) then
2900: px_asset_cat_rec.desc_flex.attribute26 := null;

Line 2899: if (px_asset_cat_rec.desc_flex.attribute26 = FND_API.G_MISS_CHAR) then

2895: end if;
2896: if (px_asset_cat_rec.desc_flex.attribute25 = FND_API.G_MISS_CHAR) then
2897: px_asset_cat_rec.desc_flex.attribute25 := null;
2898: end if;
2899: if (px_asset_cat_rec.desc_flex.attribute26 = FND_API.G_MISS_CHAR) then
2900: px_asset_cat_rec.desc_flex.attribute26 := null;
2901: end if;
2902: if (px_asset_cat_rec.desc_flex.attribute27 = FND_API.G_MISS_CHAR) then
2903: px_asset_cat_rec.desc_flex.attribute27 := null;

Line 2902: if (px_asset_cat_rec.desc_flex.attribute27 = FND_API.G_MISS_CHAR) then

2898: end if;
2899: if (px_asset_cat_rec.desc_flex.attribute26 = FND_API.G_MISS_CHAR) then
2900: px_asset_cat_rec.desc_flex.attribute26 := null;
2901: end if;
2902: if (px_asset_cat_rec.desc_flex.attribute27 = FND_API.G_MISS_CHAR) then
2903: px_asset_cat_rec.desc_flex.attribute27 := null;
2904: end if;
2905: if (px_asset_cat_rec.desc_flex.attribute28 = FND_API.G_MISS_CHAR) then
2906: px_asset_cat_rec.desc_flex.attribute28 := null;

Line 2905: if (px_asset_cat_rec.desc_flex.attribute28 = FND_API.G_MISS_CHAR) then

2901: end if;
2902: if (px_asset_cat_rec.desc_flex.attribute27 = FND_API.G_MISS_CHAR) then
2903: px_asset_cat_rec.desc_flex.attribute27 := null;
2904: end if;
2905: if (px_asset_cat_rec.desc_flex.attribute28 = FND_API.G_MISS_CHAR) then
2906: px_asset_cat_rec.desc_flex.attribute28 := null;
2907: end if;
2908: if (px_asset_cat_rec.desc_flex.attribute29 = FND_API.G_MISS_CHAR) then
2909: px_asset_cat_rec.desc_flex.attribute29 := null;

Line 2908: if (px_asset_cat_rec.desc_flex.attribute29 = FND_API.G_MISS_CHAR) then

2904: end if;
2905: if (px_asset_cat_rec.desc_flex.attribute28 = FND_API.G_MISS_CHAR) then
2906: px_asset_cat_rec.desc_flex.attribute28 := null;
2907: end if;
2908: if (px_asset_cat_rec.desc_flex.attribute29 = FND_API.G_MISS_CHAR) then
2909: px_asset_cat_rec.desc_flex.attribute29 := null;
2910: end if;
2911: if (px_asset_cat_rec.desc_flex.attribute30 = FND_API.G_MISS_CHAR) then
2912: px_asset_cat_rec.desc_flex.attribute30 := null;

Line 2911: if (px_asset_cat_rec.desc_flex.attribute30 = FND_API.G_MISS_CHAR) then

2907: end if;
2908: if (px_asset_cat_rec.desc_flex.attribute29 = FND_API.G_MISS_CHAR) then
2909: px_asset_cat_rec.desc_flex.attribute29 := null;
2910: end if;
2911: if (px_asset_cat_rec.desc_flex.attribute30 = FND_API.G_MISS_CHAR) then
2912: px_asset_cat_rec.desc_flex.attribute30 := null;
2913: end if;
2914: */
2915: return (TRUE);