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 71: if (NOT FND_API.Compatible_API_Call(

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

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

82: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
83: end if;
84:
85:
86: if (FND_API.To_Boolean(p_init_msg_list)) then
87: -- Initialize error message stack.
88: FA_SRVR_MSG.Init_Server_Message;
89:
90: -- Initialize debug message stack.

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

168: -- retain the old asset_number
169: null;
170: else
171: -- Check if user intentionally nulls out item.
172: if (px_asset_desc_rec_new.asset_number = FND_API.G_MISS_CHAR) then
173: -- use asset_id for asset_number
174: px_asset_desc_rec_new.asset_number :=
175: to_char(px_asset_hdr_rec.asset_id);
176: end if;

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

204: -- retain the old description
205: null;
206:
207: -- Check if user intentionally nulls out item.
208: elsif (px_asset_desc_rec_new.description = FND_API.G_MISS_CHAR) then
209: --l_asset_desc_rec.description := NULL;
210: null;
211: end if;
212:

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

223: if (px_asset_desc_rec_new.tag_number is NOT NULL) then
224: if (nvl(l_asset_desc_rec.tag_number, '-999') <>
225: px_asset_desc_rec_new.tag_number) then
226:
227: if (px_asset_desc_rec_new.tag_number = FND_API.G_MISS_CHAR) then
228: --l_asset_desc_rec.tag_number := NULL;
229: null;
230: else
231:

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

281: if (px_asset_desc_rec_new.serial_number is NOT NULL) then
282: if (nvl(l_asset_desc_rec.serial_number, '-999') <>
283: px_asset_desc_rec_new.serial_number) then
284:
285: if (px_asset_desc_rec_new.serial_number = FND_API.G_MISS_CHAR) then
286: --px_asset_desc_rec_new.serial_number := NULL;
287: null;
288: else
289: -- check whether update is allowed for Hierarchy Attached asset

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

330: if (px_asset_desc_rec_new.asset_key_ccid is NOT NULL) then
331: if (nvl(l_asset_desc_rec.asset_key_ccid, -999) <>
332: px_asset_desc_rec_new.asset_key_ccid) then
333:
334: if (px_asset_desc_rec_new.asset_key_ccid = FND_API.G_MISS_NUM) then
335: --px_asset_desc_rec_new.asset_key_ccid := NULL;
336:
337: if (NOT FA_ASSET_VAL_PVT.validate_asset_key (
338: p_transaction_type_code => px_trans_rec.transaction_type_code,

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

388: if (px_asset_desc_rec_new.parent_asset_id is NOT NULL) then
389: if (nvl(l_asset_desc_rec.parent_asset_id, -999) <>
390: px_asset_desc_rec_new.parent_asset_id) then
391:
392: if (px_asset_desc_rec_new.parent_asset_id = FND_API.G_MISS_NUM) then
393: --px_asset_desc_rec_new.parent_asset_id := NULL;
394: null;
395: else
396: if (NOT FA_ASSET_VAL_PVT.validate_parent_asset(

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

415: if (px_asset_desc_rec_new.manufacturer_name is NOT NULL) then
416: if (nvl(l_asset_desc_rec.manufacturer_name, '-999') <>
417: px_asset_desc_rec_new.manufacturer_name) then
418:
419: if (px_asset_desc_rec_new.manufacturer_name = FND_API.G_MISS_CHAR)
420: then null; --px_asset_desc_rec_new.manufacturer_name := NULL;
421: end if;
422:
423: l_asset_desc_rec.manufacturer_name :=

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

454: if (px_asset_desc_rec_new.model_number is NOT NULL) then
455: if (nvl(l_asset_desc_rec.model_number, '-999') <>
456: px_asset_desc_rec_new.model_number)
457: then
458: if (px_asset_desc_rec_new.model_number = FND_API.G_MISS_CHAR) then
459: --px_asset_desc_rec_new.model_number := NULL;
460: null;
461: end if;
462:

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

474: if (px_asset_desc_rec_new.warranty_id is NOT NULL) then
475: if (nvl(l_asset_desc_rec.warranty_id, -999) <>
476: px_asset_desc_rec_new.warranty_id)
477: then
478: if (px_asset_desc_rec_new.warranty_id = FND_API.G_MISS_NUM) then
479: --px_asset_desc_rec_new.warranty_id := NULL;
480: null;
481: else
482: -- We will need dpis to validate warranty. Same in primary/rep

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

510: if (px_asset_desc_rec_new.lease_id is NOT NULL) then
511: if (nvl(l_asset_desc_rec.lease_id, -999) <>
512: px_asset_desc_rec_new.lease_id) then
513:
514: if (px_asset_desc_rec_new.lease_id = FND_API.G_MISS_NUM) then
515:
516: null;
517:
518: -- px_asset_desc_rec_new.lease_id := NULL;

Line 582: FND_API.G_MISS_CHAR)

578: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute1, '-999') <>
579: px_asset_desc_rec_new.lease_desc_flex.attribute1) then
580:
581: if (px_asset_desc_rec_new.lease_desc_flex.attribute1 =
582: FND_API.G_MISS_CHAR)
583: then null;
584: end if;
585:
586: l_asset_desc_rec.lease_desc_flex.attribute1 :=

Line 597: FND_API.G_MISS_CHAR)

593: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute2, '-999') <>
594: px_asset_desc_rec_new.lease_desc_flex.attribute2) then
595:
596: if (px_asset_desc_rec_new.lease_desc_flex.attribute2 =
597: FND_API.G_MISS_CHAR)
598: then null;
599: end if;
600:
601: l_asset_desc_rec.lease_desc_flex.attribute2 :=

Line 612: FND_API.G_MISS_CHAR)

608: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute3, '-999') <>
609: px_asset_desc_rec_new.lease_desc_flex.attribute3) then
610:
611: if (px_asset_desc_rec_new.lease_desc_flex.attribute3 =
612: FND_API.G_MISS_CHAR)
613: then null;
614: end if;
615:
616: l_asset_desc_rec.lease_desc_flex.attribute3 :=

Line 627: FND_API.G_MISS_CHAR)

623: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute4, '-999') <>
624: px_asset_desc_rec_new.lease_desc_flex.attribute4) then
625:
626: if (px_asset_desc_rec_new.lease_desc_flex.attribute4 =
627: FND_API.G_MISS_CHAR)
628: then null;
629: end if;
630:
631: l_asset_desc_rec.lease_desc_flex.attribute4 :=

Line 642: FND_API.G_MISS_CHAR)

638: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute5, '-999') <>
639: px_asset_desc_rec_new.lease_desc_flex.attribute5) then
640:
641: if (px_asset_desc_rec_new.lease_desc_flex.attribute5 =
642: FND_API.G_MISS_CHAR)
643: then null;
644: end if;
645:
646: l_asset_desc_rec.lease_desc_flex.attribute5 :=

Line 657: FND_API.G_MISS_CHAR)

653: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute6, '-999') <>
654: px_asset_desc_rec_new.lease_desc_flex.attribute6) then
655:
656: if (px_asset_desc_rec_new.lease_desc_flex.attribute6 =
657: FND_API.G_MISS_CHAR)
658: then null;
659: end if;
660:
661: l_asset_desc_rec.lease_desc_flex.attribute6 :=

Line 672: FND_API.G_MISS_CHAR)

668: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute7, '-999') <>
669: px_asset_desc_rec_new.lease_desc_flex.attribute7) then
670:
671: if (px_asset_desc_rec_new.lease_desc_flex.attribute7 =
672: FND_API.G_MISS_CHAR)
673: then null;
674: end if;
675:
676: l_asset_desc_rec.lease_desc_flex.attribute7 :=

Line 687: FND_API.G_MISS_CHAR)

683: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute8, '-999') <>
684: px_asset_desc_rec_new.lease_desc_flex.attribute8) then
685:
686: if (px_asset_desc_rec_new.lease_desc_flex.attribute8 =
687: FND_API.G_MISS_CHAR)
688: then null;
689: end if;
690:
691: l_asset_desc_rec.lease_desc_flex.attribute8 :=

Line 702: FND_API.G_MISS_CHAR)

698: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute9, '-999') <>
699: px_asset_desc_rec_new.lease_desc_flex.attribute9) then
700:
701: if (px_asset_desc_rec_new.lease_desc_flex.attribute9 =
702: FND_API.G_MISS_CHAR)
703: then null;
704: end if;
705:
706: l_asset_desc_rec.lease_desc_flex.attribute9 :=

Line 717: FND_API.G_MISS_CHAR)

713: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute10, '-999') <>
714: px_asset_desc_rec_new.lease_desc_flex.attribute10) then
715:
716: if (px_asset_desc_rec_new.lease_desc_flex.attribute10 =
717: FND_API.G_MISS_CHAR)
718: then null;
719: end if;
720:
721: l_asset_desc_rec.lease_desc_flex.attribute10 :=

Line 732: FND_API.G_MISS_CHAR)

728: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute11, '-999') <>
729: px_asset_desc_rec_new.lease_desc_flex.attribute11) then
730:
731: if (px_asset_desc_rec_new.lease_desc_flex.attribute11 =
732: FND_API.G_MISS_CHAR)
733: then null;
734: end if;
735:
736: l_asset_desc_rec.lease_desc_flex.attribute11 :=

Line 747: FND_API.G_MISS_CHAR)

743: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute12, '-999') <>
744: px_asset_desc_rec_new.lease_desc_flex.attribute12) then
745:
746: if (px_asset_desc_rec_new.lease_desc_flex.attribute12 =
747: FND_API.G_MISS_CHAR)
748: then null;
749: end if;
750:
751: l_asset_desc_rec.lease_desc_flex.attribute12 :=

Line 762: FND_API.G_MISS_CHAR)

758: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute13, '-999') <>
759: px_asset_desc_rec_new.lease_desc_flex.attribute13) then
760:
761: if (px_asset_desc_rec_new.lease_desc_flex.attribute13 =
762: FND_API.G_MISS_CHAR)
763: then null;
764: end if;
765:
766: l_asset_desc_rec.lease_desc_flex.attribute13 :=

Line 777: FND_API.G_MISS_CHAR)

773: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute14, '-999') <>
774: px_asset_desc_rec_new.lease_desc_flex.attribute14) then
775:
776: if (px_asset_desc_rec_new.lease_desc_flex.attribute14 =
777: FND_API.G_MISS_CHAR)
778: then null;
779: end if;
780:
781: l_asset_desc_rec.lease_desc_flex.attribute14 :=

Line 792: FND_API.G_MISS_CHAR)

788: if (nvl(l_asset_desc_rec.lease_desc_flex.attribute15, '-999') <>
789: px_asset_desc_rec_new.lease_desc_flex.attribute15) then
790:
791: if (px_asset_desc_rec_new.lease_desc_flex.attribute15 =
792: FND_API.G_MISS_CHAR)
793: then null;
794: end if;
795:
796: l_asset_desc_rec.lease_desc_flex.attribute15 :=

Line 810: = FND_API.G_MISS_CHAR)

806: px_asset_desc_rec_new.lease_desc_flex.attribute_category_code)
807: then
808:
809: if (px_asset_desc_rec_new.lease_desc_flex.attribute_category_code
810: = FND_API.G_MISS_CHAR)
811: then null;
812: end if;
813:
814: l_asset_desc_rec.lease_desc_flex.attribute_category_code :=

Line 825: FND_API.G_MISS_CHAR)

821: if (nvl(l_asset_desc_rec.lease_desc_flex.context, '-999') <>
822: px_asset_desc_rec_new.lease_desc_flex.context) then
823:
824: if (px_asset_desc_rec_new.lease_desc_flex.context =
825: FND_API.G_MISS_CHAR)
826: then null;
827: end if;
828:
829: l_asset_desc_rec.lease_desc_flex.context :=

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

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

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

864: if (px_asset_desc_rec_new.inventorial is NOT NULL) then
865: if (nvl(l_asset_desc_rec.inventorial, '-999') <> px_asset_desc_rec_new.inventorial)
866: then
867:
868: if (px_asset_desc_rec_new.inventorial = FND_API.G_MISS_CHAR) then
869: --px_asset_desc_rec_new.inventorial := NULL;
870: null;
871: end if;
872:

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

912: if (px_asset_desc_rec_new.property_type_code is NOT NULL) then
913: if (nvl(l_asset_desc_rec.property_type_code, '-999') <>
914: px_asset_desc_rec_new.property_type_code) then
915:
916: if (px_asset_desc_rec_new.property_type_code = FND_API.G_MISS_CHAR)
917: then --px_asset_desc_rec_new.property_type_code := NULL;
918:
919: if (NOT FA_ASSET_VAL_PVT.validate_property_type(
920: p_property_type_code => NULL

Line 948: FND_API.G_MISS_CHAR) then

944: if (nvl(l_asset_desc_rec.property_1245_1250_code, '-999') <>
945: px_asset_desc_rec_new.property_1245_1250_code) then
946:
947: if (px_asset_desc_rec_new.property_1245_1250_code =
948: FND_API.G_MISS_CHAR) then
949: --px_asset_desc_rec_new.property_1245_1250_code := NULL;
950:
951: if (NOT FA_ASSET_VAL_PVT.validate_1245_1250_code(
952: p_1245_1250_code => NULL

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

975:
976: if (px_asset_desc_rec_new.owned_leased is NOT NULL) then
977: if (nvl(l_asset_desc_rec.owned_leased, '-999') <>
978: px_asset_desc_rec_new.owned_leased) then
979: if (px_asset_desc_rec_new.owned_leased = FND_API.G_MISS_CHAR) then
980: null;
981: --px_asset_desc_rec_new.owned_leased := NULL;
982: end if;
983:

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

994:
995: if (px_asset_desc_rec_new.new_used is NOT NULL) then
996: if (nvl(l_asset_desc_rec.new_used, '-999') <>
997: px_asset_desc_rec_new.new_used) then
998: if (px_asset_desc_rec_new.new_used = FND_API.G_MISS_CHAR) then
999: --px_asset_desc_rec_new.new_used := NULL;
1000: null;
1001: end if;
1002:

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

1014: if (px_asset_desc_rec_new.add_cost_je_flag is NOT NULL) then
1015: if (nvl(l_asset_desc_rec.add_cost_je_flag, '-999') <>
1016: px_asset_desc_rec_new.add_cost_je_flag) then
1017:
1018: if (px_asset_desc_rec_new.add_cost_je_flag = FND_API.G_MISS_CHAR) then
1019: --px_asset_desc_rec_new.add_cost_je_flag := NULL;
1020: null;
1021: end if;
1022:

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

1035: if (px_asset_desc_rec_new.status is NOT NULL) then
1036: if (nvl(l_asset_desc_rec.status, '-999') <>
1037: px_asset_desc_rec_new.status) then
1038:
1039: if (px_asset_desc_rec_new.status = FND_API.G_MISS_CHAR) then
1040: --px_asset_desc_rec_new.status := NULL;
1041: null;
1042: end if;
1043:

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

1070: )) then
1071: raise pub_error;
1072: end if;
1073:
1074: if (FND_API.To_Boolean(p_commit)) then
1075: commit;
1076: end if;
1077:
1078: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1078: x_return_status := FND_API.G_RET_STS_SUCCESS;

1074: if (FND_API.To_Boolean(p_commit)) then
1075: commit;
1076: end if;
1077:
1078: x_return_status := FND_API.G_RET_STS_SUCCESS;
1079:
1080: EXCEPTION
1081:
1082: when pub_error then

Line 1094: x_return_status := FND_API.G_RET_STS_ERROR;

1090: p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1093:
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095:
1096: when others then
1097:
1098: ROLLBACK TO do_desc_update;

Line 1108: x_return_status := FND_API.G_RET_STS_ERROR;

1104: p_count => x_msg_count,
1105: p_data => x_msg_data
1106: );
1107:
1108: x_return_status := FND_API.G_RET_STS_ERROR;
1109:
1110: END update_desc;
1111:
1112:

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

1241: end if;
1242:
1243:
1244: if ( p_asset_desc_rec_new.lease_id is not null and
1245: p_asset_desc_rec_new.lease_id <> FND_API.G_MISS_NUM ) then
1246:
1247: FA_DET_ADD_PKG.UPDATE_LEASE_DF
1248: (X_Lease_Id => p_asset_desc_rec_new.Lease_Id,
1249: X_Last_Update_Date => p_trans_rec.who_info.Last_Update_Date,

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

1291: end if;
1292:
1293: -- Update warranty info
1294: if (p_asset_desc_rec_new.warranty_id is NOT NULL) then
1295: if ((p_asset_desc_rec_new.warranty_id = FND_API.G_MISS_NUM) and
1296: (p_old_warranty_id is NOT NULL)) then
1297: -- Remove an existing warranty from an asset
1298: FA_ADD_WARRANTY_PKG.Update_table(
1299: WR_warranty_id => NULL,

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

1364:
1365: PROCEDURE update_invoice_desc(
1366: -- Standard Parameters --
1367: p_api_version IN NUMBER,
1368: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_msg_count OUT NOCOPY NUMBER,

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

1365: PROCEDURE update_invoice_desc(
1366: -- Standard Parameters --
1367: p_api_version IN NUMBER,
1368: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_msg_count OUT NOCOPY NUMBER,
1373: x_msg_data OUT NOCOPY VARCHAR2,

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

1366: -- Standard Parameters --
1367: p_api_version IN NUMBER,
1368: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_msg_count OUT NOCOPY NUMBER,
1373: x_msg_data OUT NOCOPY VARCHAR2,
1374: p_calling_fn IN VARCHAR2,

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

1413: end if;
1414: end if;
1415:
1416: -- Initialize message list if p_init_msg_list is set to TRUE.
1417: if (fnd_api.to_boolean(p_init_msg_list)) then
1418: -- initialize error message stack.
1419: fa_srvr_msg.init_server_message;
1420:
1421: -- initialize debug message stack.

Line 1427: if (NOT fnd_api.compatible_api_call (

1423: end if;
1424:
1425: -- Check version of the API
1426: -- Standard call to check for API call compatibility.
1427: if (NOT fnd_api.compatible_api_call (
1428: G_API_VERSION,
1429: p_api_version,
1430: G_API_NAME,
1431: G_PKG_NAME

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

1537: if (px_inv_tbl_new(i).invoice_number is NOT NULL) then
1538: if (nvl(l_inv_rec.invoice_number, '-999') <>
1539: px_inv_tbl_new(i).invoice_number)
1540: then
1541: if (px_inv_tbl_new(i).invoice_number = FND_API.G_MISS_CHAR) then
1542: --px_inv_tbl_new(i).invoice_number := NULL;
1543: null;
1544: end if;
1545:

Line 1555: FND_API.G_MISS_NUM) then

1551: if (px_inv_tbl_new(i).ap_distribution_line_number is NOT NULL) then
1552: if (nvl(l_inv_rec.ap_distribution_line_number, -999) <>
1553: px_inv_tbl_new(i).ap_distribution_line_number) then
1554: if (px_inv_tbl_new(i).ap_distribution_line_number =
1555: FND_API.G_MISS_NUM) then
1556: --px_inv_tbl_new(i).ap_distribution_line_number := NULL;
1557: null;
1558: end if;
1559:

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

1566: if (px_inv_tbl_new(i).invoice_line_number is NOT NULL) then
1567: if (nvl(l_inv_rec.invoice_line_number, '-999') <>
1568: px_inv_tbl_new(i).invoice_line_number)
1569: then
1570: if (px_inv_tbl_new(i).invoice_line_number = FND_API.G_MISS_NUM) then
1571: --px_inv_tbl_new(i).invoice_line_number := NULL;
1572: null;
1573: end if;
1574:

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

1580: if (px_inv_tbl_new(i).invoice_distribution_id is NOT NULL) then
1581: if (nvl(l_inv_rec.invoice_distribution_id, '-999') <>
1582: px_inv_tbl_new(i).invoice_distribution_id)
1583: then
1584: if (px_inv_tbl_new(i).invoice_distribution_id = FND_API.G_MISS_NUM) then
1585: --px_inv_tbl_new(i).invoice_distribution_id := NULL;
1586: null;
1587: end if;
1588:

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

1594: if (px_inv_tbl_new(i).po_distribution_id is NOT NULL) then
1595: if (nvl(l_inv_rec.po_distribution_id, '-999') <>
1596: px_inv_tbl_new(i).po_distribution_id)
1597: then
1598: if (px_inv_tbl_new(i).po_distribution_id = FND_API.G_MISS_NUM) then
1599: --px_inv_tbl_new(i).po_distribution_id := NULL;
1600: null;
1601: end if;
1602:

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

1607: -- Description
1608: if (px_inv_tbl_new(i).description is NOT NULL) then
1609: if (nvl(l_inv_rec.description, '-999') <>
1610: px_inv_tbl_new(i).description) then
1611: if (px_inv_tbl_new(i).description = FND_API.G_MISS_CHAR) then
1612: --px_inv_tbl_new(i).description := NULL;
1613: null;
1614: end if;
1615:

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

1620: -- Deleted_Flag
1621: if (px_inv_tbl_new(i).deleted_flag is NOT NULL) then
1622: if (nvl(l_inv_rec.deleted_flag, '-999') <>
1623: px_inv_tbl_new(i).deleted_flag) then
1624: if (px_inv_tbl_new(i).deleted_flag = FND_API.G_MISS_CHAR) then
1625: --px_inv_tbl_new(i).deleted_flag := NULL;
1626: null;
1627: end if;
1628:

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

1634: -- PO_Vendor_Id
1635: if (px_inv_tbl_new(i).po_vendor_id is NOT NULL) then
1636: if (nvl(l_inv_rec.po_vendor_id, -999) <>
1637: px_inv_tbl_new(i).po_vendor_id) then
1638: if (px_inv_tbl_new(i).po_vendor_id = FND_API.G_MISS_NUM) then
1639: --px_inv_tbl_new(i).po_vendor_id := NULL;
1640: null;
1641: end if;
1642:

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

1647: -- PO_Number
1648: if (px_inv_tbl_new(i).po_number is NOT NULL) then
1649: if (nvl(l_inv_rec.po_number, '-999') <>
1650: px_inv_tbl_new(i).po_number) then
1651: if (px_inv_tbl_new(i).po_number = FND_API.G_MISS_CHAR) then
1652: --px_inv_tbl_new(i).po_number := NULL;
1653: null;
1654: end if;
1655:

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

1660: -- Payables_Batch_Name
1661: if (px_inv_tbl_new(i).payables_batch_name is NOT NULL) then
1662: if (nvl(l_inv_rec.payables_batch_name, '-999') <>
1663: px_inv_tbl_new(i).payables_batch_name) then
1664: if (px_inv_tbl_new(i).payables_batch_name = FND_API.G_MISS_CHAR)
1665: then null; --px_inv_tbl_new(i).payables_batch_name := NULL;
1666: end if;
1667:
1668: l_inv_rec.payables_batch_name :=

Line 1678: FND_API.G_MISS_NUM) then

1674: if (px_inv_tbl_new(i).project_asset_line_id is NOT NULL) then
1675: if (nvl(l_inv_rec.project_asset_line_id, -999) <>
1676: px_inv_tbl_new(i).project_asset_line_id) then
1677: if (px_inv_tbl_new(i).project_asset_line_id =
1678: FND_API.G_MISS_NUM) then
1679: --px_inv_tbl_new(i).project_asset_line_id := NULL;
1680: null;
1681: end if;
1682:

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

1688: -- Project_Id
1689: if (px_inv_tbl_new(i).project_id is NOT NULL) then
1690: if (nvl(l_inv_rec.project_id, -999) <>
1691: px_inv_tbl_new(i).project_id) then
1692: if (px_inv_tbl_new(i).project_id = FND_API.G_MISS_NUM) then
1693: --px_inv_tbl_new(i).project_id := NULL;
1694: null;
1695: end if;
1696:

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

1700:
1701: -- Task_Id
1702: if (px_inv_tbl_new(i).task_id is NOT NULL) then
1703: if (nvl(l_inv_rec.task_id, -999) <> px_inv_tbl_new(i).task_id) then
1704: if (px_inv_tbl_new(i).task_id = FND_API.G_MISS_NUM) then
1705: --px_inv_tbl_new(i).task_id := NULL;
1706: null;
1707: end if;
1708:

Line 1718: FND_API.G_MISS_CHAR) then

1714: if (px_inv_tbl_new(i).material_indicator_flag is NOT NULL) then
1715: if (nvl(l_inv_rec.material_indicator_flag, '-999') <>
1716: px_inv_tbl_new(i).material_indicator_flag) then
1717: if (px_inv_tbl_new(i).material_indicator_flag =
1718: FND_API.G_MISS_CHAR) then
1719: --px_inv_tbl_new(i).material_indicator_flag := NULL;
1720: null;
1721: end if;
1722:

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

1931: end loop;
1932: end loop;
1933:
1934: -- commit if p_commit is TRUE.
1935: if (fnd_api.to_boolean (p_commit)) then
1936: COMMIT WORK;
1937: end if;
1938:
1939: -- Standard call to get message count and if count is 1 get message info.

Line 1945: x_return_status := FND_API.G_RET_STS_SUCCESS;

1941: p_count => x_msg_count,
1942: p_data => x_msg_data
1943: );
1944:
1945: x_return_status := FND_API.G_RET_STS_SUCCESS;
1946:
1947: EXCEPTION
1948:
1949: WHEN inv_err THEN

Line 1961: x_return_status := FND_API.G_RET_STS_ERROR;

1957: p_count => x_msg_count,
1958: p_data => x_msg_data
1959: );
1960:
1961: x_return_status := FND_API.G_RET_STS_ERROR;
1962:
1963: WHEN OTHERS THEN
1964:
1965: ROLLBACK TO do_invoice_desc_update;

Line 1975: x_return_status := FND_API.G_RET_STS_ERROR;

1971: p_count => x_msg_count,
1972: p_data => x_msg_data
1973: );
1974:
1975: x_return_status := FND_API.G_RET_STS_ERROR;
1976:
1977: END update_invoice_desc;
1978:
1979: PROCEDURE update_retirement_desc(

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

1978:
1979: PROCEDURE update_retirement_desc(
1980: -- Standard Parameters --
1981: p_api_version IN NUMBER,
1982: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1983: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1985: x_return_status OUT NOCOPY VARCHAR2,
1986: x_msg_count OUT NOCOPY NUMBER,

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

1979: PROCEDURE update_retirement_desc(
1980: -- Standard Parameters --
1981: p_api_version IN NUMBER,
1982: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1983: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1985: x_return_status OUT NOCOPY VARCHAR2,
1986: x_msg_count OUT NOCOPY NUMBER,
1987: x_msg_data OUT NOCOPY VARCHAR2,

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

1980: -- Standard Parameters --
1981: p_api_version IN NUMBER,
1982: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1983: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1985: x_return_status OUT NOCOPY VARCHAR2,
1986: x_msg_count OUT NOCOPY NUMBER,
1987: x_msg_data OUT NOCOPY VARCHAR2,
1988: p_calling_fn IN VARCHAR2,

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

2022: end if;
2023: end if;
2024:
2025: -- Initialize message list if p_init_msg_list is set to TRUE.
2026: if (fnd_api.to_boolean(p_init_msg_list)) then
2027: -- initialize error message stack.
2028: fa_srvr_msg.init_server_message;
2029:
2030: -- initialize debug message stack.

Line 2036: if (NOT fnd_api.compatible_api_call (

2032: end if;
2033:
2034: -- Check version of the API
2035: -- Standard call to check for API call compatibility.
2036: if (NOT fnd_api.compatible_api_call (
2037: G_API_VERSION,
2038: p_api_version,
2039: G_API_NAME,
2040: G_PKG_NAME

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

2164:
2165: -- Status
2166: if (px_asset_retire_rec_new.status is NOT NULL) then
2167: if (l_asset_retire_rec.status <> px_asset_retire_rec_new.status) then
2168: if (px_asset_retire_rec_new.status = FND_API.G_MISS_CHAR) then
2169: --px_asset_retire_rec_new.status := NULL;
2170: null;
2171: end if;
2172:

Line 2182: FND_API.G_MISS_CHAR) then

2178: if (px_asset_retire_rec_new.retirement_type_code is NOT NULL) then
2179: if (nvl(l_asset_retire_rec.retirement_type_code, '-999') <>
2180: px_asset_retire_rec_new.retirement_type_code) then
2181: if (px_asset_retire_rec_new.retirement_type_code =
2182: FND_API.G_MISS_CHAR) then
2183: --px_asset_retire_rec_new.retirement_type_code := NULL;
2184: null;
2185: end if;
2186:

Line 2198: FND_API.G_MISS_CHAR) then

2194: then
2195: if (l_asset_retire_rec.retirement_prorate_convention <>
2196: px_asset_retire_rec_new.retirement_prorate_convention) then
2197: if (px_asset_retire_rec_new.retirement_prorate_convention =
2198: FND_API.G_MISS_CHAR) then
2199: --px_asset_retire_rec_new.retirement_prorate_convention := NULL;
2200: null;
2201: end if;
2202:

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

2208: -- Proceeds of Sale
2209: if (px_asset_retire_rec_new.proceeds_of_sale is NOT NULL) then
2210: if (nvl(l_asset_retire_rec.proceeds_of_sale, -999) <>
2211: px_asset_retire_rec_new.proceeds_of_sale) then
2212: if (px_asset_retire_rec_new.proceeds_of_sale = FND_API.G_MISS_NUM)
2213: then null; --px_asset_retire_rec_new.proceeds_of_sale := NULL;
2214: end if;
2215:
2216: -- Fix for Bug #2368292. Need to account for reporting books

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

2287: -- Cost of Removal
2288: if (px_asset_retire_rec_new.cost_of_removal is NOT NULL) then
2289: if (nvl(l_asset_retire_rec.cost_of_removal, -999) <>
2290: px_asset_retire_rec_new.cost_of_removal) then
2291: if (px_asset_retire_rec_new.cost_of_removal = FND_API.G_MISS_NUM)
2292: then null; --px_asset_retire_rec_new.cost_of_removal := NULL;
2293: end if;
2294:
2295: -- Fix for Bug #2368292. Need to account for reporting books

Line 2362: FND_API.G_MISS_CHAR) then

2358: if (px_asset_retire_rec_new.detail_info.stl_method_code is NOT NULL) then
2359: if (nvl(l_asset_retire_rec.detail_info.stl_method_code, '-999') <>
2360: px_asset_retire_rec_new.detail_info.stl_method_code) then
2361: if (px_asset_retire_rec_new.detail_info.stl_method_code =
2362: FND_API.G_MISS_CHAR) then
2363: null;
2364: --px_asset_retire_rec_new.detail_info.stl_method_code := NULL;
2365: end if;
2366:

Line 2378: FND_API.G_MISS_NUM) then

2374: then
2375: if (nvl(l_asset_retire_rec.detail_info.stl_life_in_months, -999) <>
2376: px_asset_retire_rec_new.detail_info.stl_life_in_months) then
2377: if (px_asset_retire_rec_new.detail_info.stl_life_in_months =
2378: FND_API.G_MISS_NUM) then
2379: --px_asset_retire_rec_new.detail_info.stl_life_in_months := NULL;
2380: null;
2381: end if;
2382:

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

2388: -- Reference Num
2389: if (px_asset_retire_rec_new.reference_num is NOT NULL) then
2390: if (nvl(l_asset_retire_rec.reference_num, '-999') <>
2391: px_asset_retire_rec_new.reference_num) then
2392: if (px_asset_retire_rec_new.reference_num = FND_API.G_MISS_CHAR)
2393: then null; --px_asset_retire_rec_new.reference_num := NULL;
2394: end if;
2395:
2396: l_asset_retire_rec.reference_num :=

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

2402: if (px_asset_retire_rec_new.sold_to is NOT NULL) then
2403: if (nvl(l_asset_retire_rec.sold_to, '-999') <>
2404: px_asset_retire_rec_new.sold_to)
2405: then
2406: if (px_asset_retire_rec_new.sold_to = FND_API.G_MISS_CHAR) then
2407: null;
2408: --px_asset_retire_rec_new.sold_to := NULL;
2409: end if;
2410:

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

2415: -- Trade In Asset Id
2416: if (px_asset_retire_rec_new.trade_in_asset_id is NOT NULL) then
2417: if (nvl(l_asset_retire_rec.trade_in_asset_id, -999) <>
2418: px_asset_retire_rec_new.trade_in_asset_id) then
2419: if (px_asset_retire_rec_new.trade_in_asset_id = FND_API.G_MISS_NUM)
2420: then null; --px_asset_retire_rec_new.trade_in_asset_id := NULL;
2421: end if;
2422:
2423: l_asset_retire_rec.trade_in_asset_id :=

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

2633:
2634: end loop;
2635:
2636: -- commit if p_commit is TRUE.
2637: if (fnd_api.to_boolean (p_commit)) then
2638: COMMIT WORK;
2639: end if;
2640:
2641: -- Standard call to get message count and if count is 1 get message info.

Line 2647: x_return_status := FND_API.G_RET_STS_SUCCESS;

2643: p_count => x_msg_count,
2644: p_data => x_msg_data
2645: );
2646:
2647: x_return_status := FND_API.G_RET_STS_SUCCESS;
2648:
2649: EXCEPTION
2650:
2651: WHEN ret_err THEN

Line 2663: x_return_status := FND_API.G_RET_STS_ERROR;

2659: p_count => x_msg_count,
2660: p_data => x_msg_data
2661: );
2662:
2663: x_return_status := FND_API.G_RET_STS_ERROR;
2664:
2665: WHEN OTHERS THEN
2666:
2667: ROLLBACK TO do_retirement_desc_update;

Line 2677: x_return_status := FND_API.G_RET_STS_ERROR;

2673: p_count => x_msg_count,
2674: p_data => x_msg_data
2675: );
2676:
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678:
2679: END update_retirement_desc;
2680:
2681:

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

2731:
2732: -- commenting this for bug 2700227
2733: --px_asset_cat_rec.desc_flex.context := l_concat_string;
2734: /*
2735: if (px_asset_cat_rec.desc_flex.attribute1 = FND_API.G_MISS_CHAR) then
2736: px_asset_cat_rec.desc_flex.attribute1 := null;
2737: end if;
2738: if (px_asset_cat_rec.desc_flex.attribute2 = FND_API.G_MISS_CHAR) then
2739: px_asset_cat_rec.desc_flex.attribute2 := null;

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

2734: /*
2735: if (px_asset_cat_rec.desc_flex.attribute1 = FND_API.G_MISS_CHAR) then
2736: px_asset_cat_rec.desc_flex.attribute1 := null;
2737: end if;
2738: if (px_asset_cat_rec.desc_flex.attribute2 = FND_API.G_MISS_CHAR) then
2739: px_asset_cat_rec.desc_flex.attribute2 := null;
2740: end if;
2741: if (px_asset_cat_rec.desc_flex.attribute3 = FND_API.G_MISS_CHAR) then
2742: px_asset_cat_rec.desc_flex.attribute3 := null;

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

2737: end if;
2738: if (px_asset_cat_rec.desc_flex.attribute2 = FND_API.G_MISS_CHAR) then
2739: px_asset_cat_rec.desc_flex.attribute2 := null;
2740: end if;
2741: if (px_asset_cat_rec.desc_flex.attribute3 = FND_API.G_MISS_CHAR) then
2742: px_asset_cat_rec.desc_flex.attribute3 := null;
2743: end if;
2744: if (px_asset_cat_rec.desc_flex.attribute4 = FND_API.G_MISS_CHAR) then
2745: px_asset_cat_rec.desc_flex.attribute4 := null;

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

2740: end if;
2741: if (px_asset_cat_rec.desc_flex.attribute3 = FND_API.G_MISS_CHAR) then
2742: px_asset_cat_rec.desc_flex.attribute3 := null;
2743: end if;
2744: if (px_asset_cat_rec.desc_flex.attribute4 = FND_API.G_MISS_CHAR) then
2745: px_asset_cat_rec.desc_flex.attribute4 := null;
2746: end if;
2747: if (px_asset_cat_rec.desc_flex.attribute5 = FND_API.G_MISS_CHAR) then
2748: px_asset_cat_rec.desc_flex.attribute5 := null;

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

2743: end if;
2744: if (px_asset_cat_rec.desc_flex.attribute4 = FND_API.G_MISS_CHAR) then
2745: px_asset_cat_rec.desc_flex.attribute4 := null;
2746: end if;
2747: if (px_asset_cat_rec.desc_flex.attribute5 = FND_API.G_MISS_CHAR) then
2748: px_asset_cat_rec.desc_flex.attribute5 := null;
2749: end if;
2750: if (px_asset_cat_rec.desc_flex.attribute6 = FND_API.G_MISS_CHAR) then
2751: px_asset_cat_rec.desc_flex.attribute6 := null;

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

2746: end if;
2747: if (px_asset_cat_rec.desc_flex.attribute5 = FND_API.G_MISS_CHAR) then
2748: px_asset_cat_rec.desc_flex.attribute5 := null;
2749: end if;
2750: if (px_asset_cat_rec.desc_flex.attribute6 = FND_API.G_MISS_CHAR) then
2751: px_asset_cat_rec.desc_flex.attribute6 := null;
2752: end if;
2753: if (px_asset_cat_rec.desc_flex.attribute7 = FND_API.G_MISS_CHAR) then
2754: px_asset_cat_rec.desc_flex.attribute7 := null;

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

2749: end if;
2750: if (px_asset_cat_rec.desc_flex.attribute6 = FND_API.G_MISS_CHAR) then
2751: px_asset_cat_rec.desc_flex.attribute6 := null;
2752: end if;
2753: if (px_asset_cat_rec.desc_flex.attribute7 = FND_API.G_MISS_CHAR) then
2754: px_asset_cat_rec.desc_flex.attribute7 := null;
2755: end if;
2756: if (px_asset_cat_rec.desc_flex.attribute8 = FND_API.G_MISS_CHAR) then
2757: px_asset_cat_rec.desc_flex.attribute8 := null;

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

2752: end if;
2753: if (px_asset_cat_rec.desc_flex.attribute7 = FND_API.G_MISS_CHAR) then
2754: px_asset_cat_rec.desc_flex.attribute7 := null;
2755: end if;
2756: if (px_asset_cat_rec.desc_flex.attribute8 = FND_API.G_MISS_CHAR) then
2757: px_asset_cat_rec.desc_flex.attribute8 := null;
2758: end if;
2759: if (px_asset_cat_rec.desc_flex.attribute9 = FND_API.G_MISS_CHAR) then
2760: px_asset_cat_rec.desc_flex.attribute9 := null;

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

2755: end if;
2756: if (px_asset_cat_rec.desc_flex.attribute8 = FND_API.G_MISS_CHAR) then
2757: px_asset_cat_rec.desc_flex.attribute8 := null;
2758: end if;
2759: if (px_asset_cat_rec.desc_flex.attribute9 = FND_API.G_MISS_CHAR) then
2760: px_asset_cat_rec.desc_flex.attribute9 := null;
2761: end if;
2762: if (px_asset_cat_rec.desc_flex.attribute10 = FND_API.G_MISS_CHAR) then
2763: px_asset_cat_rec.desc_flex.attribute10 := null;

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

2758: end if;
2759: if (px_asset_cat_rec.desc_flex.attribute9 = FND_API.G_MISS_CHAR) then
2760: px_asset_cat_rec.desc_flex.attribute9 := null;
2761: end if;
2762: if (px_asset_cat_rec.desc_flex.attribute10 = FND_API.G_MISS_CHAR) then
2763: px_asset_cat_rec.desc_flex.attribute10 := null;
2764: end if;
2765: if (px_asset_cat_rec.desc_flex.attribute11 = FND_API.G_MISS_CHAR) then
2766: px_asset_cat_rec.desc_flex.attribute11 := null;

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

2761: end if;
2762: if (px_asset_cat_rec.desc_flex.attribute10 = FND_API.G_MISS_CHAR) then
2763: px_asset_cat_rec.desc_flex.attribute10 := null;
2764: end if;
2765: if (px_asset_cat_rec.desc_flex.attribute11 = FND_API.G_MISS_CHAR) then
2766: px_asset_cat_rec.desc_flex.attribute11 := null;
2767: end if;
2768: if (px_asset_cat_rec.desc_flex.attribute12 = FND_API.G_MISS_CHAR) then
2769: px_asset_cat_rec.desc_flex.attribute12 := null;

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

2764: end if;
2765: if (px_asset_cat_rec.desc_flex.attribute11 = FND_API.G_MISS_CHAR) then
2766: px_asset_cat_rec.desc_flex.attribute11 := null;
2767: end if;
2768: if (px_asset_cat_rec.desc_flex.attribute12 = FND_API.G_MISS_CHAR) then
2769: px_asset_cat_rec.desc_flex.attribute12 := null;
2770: end if;
2771: if (px_asset_cat_rec.desc_flex.attribute13 = FND_API.G_MISS_CHAR) then
2772: px_asset_cat_rec.desc_flex.attribute13 := null;

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

2767: end if;
2768: if (px_asset_cat_rec.desc_flex.attribute12 = FND_API.G_MISS_CHAR) then
2769: px_asset_cat_rec.desc_flex.attribute12 := null;
2770: end if;
2771: if (px_asset_cat_rec.desc_flex.attribute13 = FND_API.G_MISS_CHAR) then
2772: px_asset_cat_rec.desc_flex.attribute13 := null;
2773: end if;
2774: if (px_asset_cat_rec.desc_flex.attribute14 = FND_API.G_MISS_CHAR) then
2775: px_asset_cat_rec.desc_flex.attribute14 := null;

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

2770: end if;
2771: if (px_asset_cat_rec.desc_flex.attribute13 = FND_API.G_MISS_CHAR) then
2772: px_asset_cat_rec.desc_flex.attribute13 := null;
2773: end if;
2774: if (px_asset_cat_rec.desc_flex.attribute14 = FND_API.G_MISS_CHAR) then
2775: px_asset_cat_rec.desc_flex.attribute14 := null;
2776: end if;
2777: if (px_asset_cat_rec.desc_flex.attribute15 = FND_API.G_MISS_CHAR) then
2778: px_asset_cat_rec.desc_flex.attribute15 := null;

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

2773: end if;
2774: if (px_asset_cat_rec.desc_flex.attribute14 = FND_API.G_MISS_CHAR) then
2775: px_asset_cat_rec.desc_flex.attribute14 := null;
2776: end if;
2777: if (px_asset_cat_rec.desc_flex.attribute15 = FND_API.G_MISS_CHAR) then
2778: px_asset_cat_rec.desc_flex.attribute15 := null;
2779: end if;
2780: if (px_asset_cat_rec.desc_flex.attribute16 = FND_API.G_MISS_CHAR) then
2781: px_asset_cat_rec.desc_flex.attribute16 := null;

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

2776: end if;
2777: if (px_asset_cat_rec.desc_flex.attribute15 = FND_API.G_MISS_CHAR) then
2778: px_asset_cat_rec.desc_flex.attribute15 := null;
2779: end if;
2780: if (px_asset_cat_rec.desc_flex.attribute16 = FND_API.G_MISS_CHAR) then
2781: px_asset_cat_rec.desc_flex.attribute16 := null;
2782: end if;
2783: if (px_asset_cat_rec.desc_flex.attribute17 = FND_API.G_MISS_CHAR) then
2784: px_asset_cat_rec.desc_flex.attribute17 := null;

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

2779: end if;
2780: if (px_asset_cat_rec.desc_flex.attribute16 = FND_API.G_MISS_CHAR) then
2781: px_asset_cat_rec.desc_flex.attribute16 := null;
2782: end if;
2783: if (px_asset_cat_rec.desc_flex.attribute17 = FND_API.G_MISS_CHAR) then
2784: px_asset_cat_rec.desc_flex.attribute17 := null;
2785: end if;
2786: if (px_asset_cat_rec.desc_flex.attribute18 = FND_API.G_MISS_CHAR) then
2787: px_asset_cat_rec.desc_flex.attribute18 := null;

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

2782: end if;
2783: if (px_asset_cat_rec.desc_flex.attribute17 = FND_API.G_MISS_CHAR) then
2784: px_asset_cat_rec.desc_flex.attribute17 := null;
2785: end if;
2786: if (px_asset_cat_rec.desc_flex.attribute18 = FND_API.G_MISS_CHAR) then
2787: px_asset_cat_rec.desc_flex.attribute18 := null;
2788: end if;
2789: if (px_asset_cat_rec.desc_flex.attribute19 = FND_API.G_MISS_CHAR) then
2790: px_asset_cat_rec.desc_flex.attribute19 := null;

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

2785: end if;
2786: if (px_asset_cat_rec.desc_flex.attribute18 = FND_API.G_MISS_CHAR) then
2787: px_asset_cat_rec.desc_flex.attribute18 := null;
2788: end if;
2789: if (px_asset_cat_rec.desc_flex.attribute19 = FND_API.G_MISS_CHAR) then
2790: px_asset_cat_rec.desc_flex.attribute19 := null;
2791: end if;
2792: if (px_asset_cat_rec.desc_flex.attribute20 = FND_API.G_MISS_CHAR) then
2793: px_asset_cat_rec.desc_flex.attribute20 := null;

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

2788: end if;
2789: if (px_asset_cat_rec.desc_flex.attribute19 = FND_API.G_MISS_CHAR) then
2790: px_asset_cat_rec.desc_flex.attribute19 := null;
2791: end if;
2792: if (px_asset_cat_rec.desc_flex.attribute20 = FND_API.G_MISS_CHAR) then
2793: px_asset_cat_rec.desc_flex.attribute20 := null;
2794: end if;
2795: if (px_asset_cat_rec.desc_flex.attribute21 = FND_API.G_MISS_CHAR) then
2796: px_asset_cat_rec.desc_flex.attribute21 := null;

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

2791: end if;
2792: if (px_asset_cat_rec.desc_flex.attribute20 = FND_API.G_MISS_CHAR) then
2793: px_asset_cat_rec.desc_flex.attribute20 := null;
2794: end if;
2795: if (px_asset_cat_rec.desc_flex.attribute21 = FND_API.G_MISS_CHAR) then
2796: px_asset_cat_rec.desc_flex.attribute21 := null;
2797: end if;
2798: if (px_asset_cat_rec.desc_flex.attribute22 = FND_API.G_MISS_CHAR) then
2799: px_asset_cat_rec.desc_flex.attribute22 := null;

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

2794: end if;
2795: if (px_asset_cat_rec.desc_flex.attribute21 = FND_API.G_MISS_CHAR) then
2796: px_asset_cat_rec.desc_flex.attribute21 := null;
2797: end if;
2798: if (px_asset_cat_rec.desc_flex.attribute22 = FND_API.G_MISS_CHAR) then
2799: px_asset_cat_rec.desc_flex.attribute22 := null;
2800: end if;
2801: if (px_asset_cat_rec.desc_flex.attribute23 = FND_API.G_MISS_CHAR) then
2802: px_asset_cat_rec.desc_flex.attribute23 := null;

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

2797: end if;
2798: if (px_asset_cat_rec.desc_flex.attribute22 = FND_API.G_MISS_CHAR) then
2799: px_asset_cat_rec.desc_flex.attribute22 := null;
2800: end if;
2801: if (px_asset_cat_rec.desc_flex.attribute23 = FND_API.G_MISS_CHAR) then
2802: px_asset_cat_rec.desc_flex.attribute23 := null;
2803: end if;
2804: if (px_asset_cat_rec.desc_flex.attribute24 = FND_API.G_MISS_CHAR) then
2805: px_asset_cat_rec.desc_flex.attribute24 := null;

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

2800: end if;
2801: if (px_asset_cat_rec.desc_flex.attribute23 = FND_API.G_MISS_CHAR) then
2802: px_asset_cat_rec.desc_flex.attribute23 := null;
2803: end if;
2804: if (px_asset_cat_rec.desc_flex.attribute24 = FND_API.G_MISS_CHAR) then
2805: px_asset_cat_rec.desc_flex.attribute24 := null;
2806: end if;
2807: if (px_asset_cat_rec.desc_flex.attribute25 = FND_API.G_MISS_CHAR) then
2808: px_asset_cat_rec.desc_flex.attribute25 := null;

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

2803: end if;
2804: if (px_asset_cat_rec.desc_flex.attribute24 = FND_API.G_MISS_CHAR) then
2805: px_asset_cat_rec.desc_flex.attribute24 := null;
2806: end if;
2807: if (px_asset_cat_rec.desc_flex.attribute25 = FND_API.G_MISS_CHAR) then
2808: px_asset_cat_rec.desc_flex.attribute25 := null;
2809: end if;
2810: if (px_asset_cat_rec.desc_flex.attribute26 = FND_API.G_MISS_CHAR) then
2811: px_asset_cat_rec.desc_flex.attribute26 := null;

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

2806: end if;
2807: if (px_asset_cat_rec.desc_flex.attribute25 = FND_API.G_MISS_CHAR) then
2808: px_asset_cat_rec.desc_flex.attribute25 := null;
2809: end if;
2810: if (px_asset_cat_rec.desc_flex.attribute26 = FND_API.G_MISS_CHAR) then
2811: px_asset_cat_rec.desc_flex.attribute26 := null;
2812: end if;
2813: if (px_asset_cat_rec.desc_flex.attribute27 = FND_API.G_MISS_CHAR) then
2814: px_asset_cat_rec.desc_flex.attribute27 := null;

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

2809: end if;
2810: if (px_asset_cat_rec.desc_flex.attribute26 = FND_API.G_MISS_CHAR) then
2811: px_asset_cat_rec.desc_flex.attribute26 := null;
2812: end if;
2813: if (px_asset_cat_rec.desc_flex.attribute27 = FND_API.G_MISS_CHAR) then
2814: px_asset_cat_rec.desc_flex.attribute27 := null;
2815: end if;
2816: if (px_asset_cat_rec.desc_flex.attribute28 = FND_API.G_MISS_CHAR) then
2817: px_asset_cat_rec.desc_flex.attribute28 := null;

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

2812: end if;
2813: if (px_asset_cat_rec.desc_flex.attribute27 = FND_API.G_MISS_CHAR) then
2814: px_asset_cat_rec.desc_flex.attribute27 := null;
2815: end if;
2816: if (px_asset_cat_rec.desc_flex.attribute28 = FND_API.G_MISS_CHAR) then
2817: px_asset_cat_rec.desc_flex.attribute28 := null;
2818: end if;
2819: if (px_asset_cat_rec.desc_flex.attribute29 = FND_API.G_MISS_CHAR) then
2820: px_asset_cat_rec.desc_flex.attribute29 := null;

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

2815: end if;
2816: if (px_asset_cat_rec.desc_flex.attribute28 = FND_API.G_MISS_CHAR) then
2817: px_asset_cat_rec.desc_flex.attribute28 := null;
2818: end if;
2819: if (px_asset_cat_rec.desc_flex.attribute29 = FND_API.G_MISS_CHAR) then
2820: px_asset_cat_rec.desc_flex.attribute29 := null;
2821: end if;
2822: if (px_asset_cat_rec.desc_flex.attribute30 = FND_API.G_MISS_CHAR) then
2823: px_asset_cat_rec.desc_flex.attribute30 := null;

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

2818: end if;
2819: if (px_asset_cat_rec.desc_flex.attribute29 = FND_API.G_MISS_CHAR) then
2820: px_asset_cat_rec.desc_flex.attribute29 := null;
2821: end if;
2822: if (px_asset_cat_rec.desc_flex.attribute30 = FND_API.G_MISS_CHAR) then
2823: px_asset_cat_rec.desc_flex.attribute30 := null;
2824: end if;
2825: */
2826: return (TRUE);