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.CSI_ASSET_PVT dependencies on CSI_ASSET_VLD_PVT

Line 1072: CSI_Asset_vld_pvt.Check_Reqd_Param

1068: p_asset_count_rec.loc_count := 0;
1069: END IF;
1070: --
1071: -- Check if all the required parameters are passed
1072: CSI_Asset_vld_pvt.Check_Reqd_Param
1073: ( p_instance_asset_rec.INSTANCE_ID ,
1074: ' p_instance_asset_rec.INSTANCE_ID ',
1075: l_api_name );
1076:

Line 1078: CSI_Asset_vld_pvt.Check_Reqd_Param(

1074: ' p_instance_asset_rec.INSTANCE_ID ',
1075: l_api_name );
1076:
1077: IF nvl(p_instance_asset_rec.fa_mass_addition_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1078: CSI_Asset_vld_pvt.Check_Reqd_Param(
1079: p_instance_asset_rec.FA_ASSET_ID,
1080: 'p_instance_asset_rec.FA_ASSET_ID ',
1081: l_api_name);
1082: END IF;

Line 1084: CSI_Asset_vld_pvt.Check_Reqd_Param

1080: 'p_instance_asset_rec.FA_ASSET_ID ',
1081: l_api_name);
1082: END IF;
1083:
1084: CSI_Asset_vld_pvt.Check_Reqd_Param
1085: ( p_instance_asset_rec.FA_BOOK_TYPE_CODE ,
1086: ' p_instance_asset_rec.FA_BOOK_TYPE_CODE ',
1087: l_api_name );
1088:

Line 1089: CSI_Asset_vld_pvt.Check_Reqd_Param

1085: ( p_instance_asset_rec.FA_BOOK_TYPE_CODE ,
1086: ' p_instance_asset_rec.FA_BOOK_TYPE_CODE ',
1087: l_api_name );
1088:
1089: CSI_Asset_vld_pvt.Check_Reqd_Param
1090: ( p_instance_asset_rec.FA_LOCATION_ID,
1091: ' p_instance_asset_rec.FA_LOCATION_ID',
1092: l_api_name );
1093: -- Added by sk for bug 2232880.

Line 1156: CSI_Asset_vld_pvt.Check_Reqd_Param

1152: ELSE
1153: -- End addition by sk for bug 2232880.
1154:
1155:
1156: CSI_Asset_vld_pvt.Check_Reqd_Param
1157: ( p_instance_asset_rec.ASSET_QUANTITY,
1158: ' p_instance_asset_rec.ASSET_QUANTITY',
1159: l_api_name );
1160: CSI_Asset_vld_pvt.Check_Reqd_Param

Line 1160: CSI_Asset_vld_pvt.Check_Reqd_Param

1156: CSI_Asset_vld_pvt.Check_Reqd_Param
1157: ( p_instance_asset_rec.ASSET_QUANTITY,
1158: ' p_instance_asset_rec.ASSET_QUANTITY',
1159: l_api_name );
1160: CSI_Asset_vld_pvt.Check_Reqd_Param
1161: ( p_instance_asset_rec.UPDATE_STATUS,
1162: ' p_instance_asset_rec.UPDATE_STATUS',
1163: l_api_name );
1164:

Line 1167: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid

1163: l_api_name );
1164:
1165: -- Validate the Instance id exists in csi_item_instances
1166: IF p_called_from_grp <> FND_API.G_TRUE THEN
1167: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid
1168: (p_instance_asset_rec.INSTANCE_ID
1169: ,p_instance_asset_rec.check_for_instance_expiry
1170: )) THEN
1171: RAISE FND_API.G_EXC_ERROR;

Line 1183: p_instance_asset_rec.INSTANCE_ASSET_ID := CSI_Asset_vld_pvt.gen_inst_asset_id;

1179: -- and check if the value exists . If exists then generate
1180: -- again from the sequence till we get a value that does not exist
1181: WHILE l_process_flag
1182: LOOP
1183: p_instance_asset_rec.INSTANCE_ASSET_ID := CSI_Asset_vld_pvt.gen_inst_asset_id;
1184: IF NOT(CSI_Asset_vld_pvt.Is_Inst_assetID_exists
1185: (p_instance_asset_rec.INSTANCE_ASSET_ID,
1186: FALSE )) THEN
1187: l_process_flag := FALSE;

Line 1184: IF NOT(CSI_Asset_vld_pvt.Is_Inst_assetID_exists

1180: -- again from the sequence till we get a value that does not exist
1181: WHILE l_process_flag
1182: LOOP
1183: p_instance_asset_rec.INSTANCE_ASSET_ID := CSI_Asset_vld_pvt.gen_inst_asset_id;
1184: IF NOT(CSI_Asset_vld_pvt.Is_Inst_assetID_exists
1185: (p_instance_asset_rec.INSTANCE_ASSET_ID,
1186: FALSE )) THEN
1187: l_process_flag := FALSE;
1188: END IF;

Line 1192: IF CSI_Asset_vld_pvt.Is_Inst_assetID_exists

1188: END IF;
1189: END LOOP;
1190: ELSE
1191: -- Validate the instance asset id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
1192: IF CSI_Asset_vld_pvt.Is_Inst_assetID_exists
1193: (p_instance_asset_rec.INSTANCE_ASSET_ID,
1194: TRUE ) THEN
1195: RAISE FND_API.G_EXC_ERROR;
1196: END IF;

Line 1226: IF NOT( CSI_Asset_vld_pvt.Is_Update_Status_Exists

1222: IF l_exists_flag <> 'Y' THEN
1223: p_asset_count_rec.lookup_count := p_asset_count_rec.lookup_count + 1;
1224: p_lookup_tbl(p_asset_count_rec.lookup_count).lookup_code :=
1225: p_instance_asset_rec.update_status;
1226: IF NOT( CSI_Asset_vld_pvt.Is_Update_Status_Exists
1227: (p_instance_asset_rec.UPDATE_STATUS)) THEN
1228: p_lookup_tbl(p_asset_count_rec.lookup_count).valid_flag := 'N';
1229: RAISE FND_API.G_EXC_ERROR;
1230: ELSE

Line 1238: IF NOT( CSI_Asset_vld_pvt.Is_Quantity_Valid

1234: END IF;
1235: --
1236:
1237: -- Validate the quantity > 0
1238: IF NOT( CSI_Asset_vld_pvt.Is_Quantity_Valid
1239: (p_instance_asset_rec.ASSET_QUANTITY)) THEN
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:

Line 1276: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Comb_Valid

1272: p_asset_count_rec.asset_count := p_asset_count_rec.asset_count + 1;
1273: p_asset_id_tbl(p_asset_count_rec.asset_count).asset_id := p_instance_asset_rec.fa_asset_id;
1274: p_asset_id_tbl(p_asset_count_rec.asset_count).asset_book_type :=
1275: p_instance_asset_rec.fa_book_type_code;
1276: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Comb_Valid
1277: (p_instance_asset_rec.FA_ASSET_ID ,
1278: p_instance_asset_rec.FA_BOOK_TYPE_CODE )) THEN
1279: p_asset_id_tbl(p_asset_count_rec.asset_count).valid_flag := 'N';
1280: RAISE fnd_api.g_exc_error;

Line 1299: IF NOT(CSI_Asset_vld_pvt.Is_StartDate_Valid(

1295: END IF;
1296: --
1297: IF p_called_from_grp <> FND_API.G_TRUE THEN
1298: -- Validation for the active start date passed
1299: IF NOT(CSI_Asset_vld_pvt.Is_StartDate_Valid(
1300: p_instance_asset_rec.ACTIVE_START_DATE,
1301: p_instance_asset_rec.ACTIVE_END_DATE ,
1302: p_instance_asset_rec.INSTANCE_ID,
1303: p_instance_asset_rec.check_for_instance_expiry ))

Line 1313: IF NOT(CSI_Asset_vld_pvt.Is_EndDate_Valid(

1309: IF p_called_from_grp <> FND_API.G_TRUE THEN
1310: -- Verify if the active_end_date is valid
1311: IF ((p_instance_asset_rec.ACTIVE_END_DATE is NOT NULL) AND
1312: ( p_instance_asset_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE)) THEN
1313: IF NOT(CSI_Asset_vld_pvt.Is_EndDate_Valid(
1314: p_instance_asset_rec.ACTIVE_START_DATE,
1315: p_instance_asset_rec.ACTIVE_END_DATE ,
1316: p_instance_asset_rec.INSTANCE_ID,
1317: p_instance_asset_rec.INSTANCE_ASSET_ID,

Line 1381: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Location_Valid (p_instance_asset_rec.FA_LOCATION_ID ))

1377: IF l_exists_flag <> 'Y' THEN
1378: p_asset_count_rec.loc_count := p_asset_count_rec.loc_count + 1;
1379: p_asset_loc_tbl(p_asset_count_rec.loc_count).asset_loc_id :=
1380: p_instance_asset_rec.fa_location_id;
1381: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Location_Valid (p_instance_asset_rec.FA_LOCATION_ID ))
1382: THEN
1383: p_asset_loc_tbl(p_asset_count_rec.loc_count).valid_flag := 'N';
1384: RAISE fnd_api.g_exc_error;
1385: ELSE

Line 1437: l_instance_asset_hist_id := CSI_Asset_vld_pvt.gen_inst_asset_hist_id;

1433: END IF;
1434: END IF;
1435:
1436: -- Generate the instance asset history id from the sequence
1437: l_instance_asset_hist_id := CSI_Asset_vld_pvt.gen_inst_asset_hist_id;
1438: -- Call table handlers to insert into history table
1439: CSI_I_ASSETS_H_PKG.Insert_Row (
1440: px_INSTANCE_ASSET_HISTORY_ID => l_instance_asset_hist_id,
1441: p_INSTANCE_ASSET_ID => p_instance_asset_rec.INSTANCE_ASSET_ID,

Line 1652: CSI_Asset_vld_pvt.Check_Reqd_Param (p_instance_asset_rec.INSTANCE_ASSET_ID,

1648: p_asset_count_rec.loc_count := 0;
1649: END IF;
1650:
1651: -- Check if all the required parameters are passed
1652: CSI_Asset_vld_pvt.Check_Reqd_Param (p_instance_asset_rec.INSTANCE_ASSET_ID,
1653: 'p_instance_asset_rec.INSTANCE_ASSET_ID ',
1654: l_api_name);
1655:
1656: -- check if the object_version_number passed matches with the one

Line 1676: IF NOT( CSI_Asset_vld_pvt.Is_Inst_asset_id_valid (p_instance_asset_rec.INSTANCE_ASSET_ID)) THEN

1672: --
1673: p_instance_asset_rec.instance_id := l_curr_asset_rec.instance_id;
1674: --
1675: -- Validate the Instance asset id exists in csi_i_assets
1676: IF NOT( CSI_Asset_vld_pvt.Is_Inst_asset_id_valid (p_instance_asset_rec.INSTANCE_ASSET_ID)) THEN
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:
1680: -- Validate the Instance id exists in csi_item_instances

Line 1683: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid

1679:
1680: -- Validate the Instance id exists in csi_item_instances
1681: IF ((p_instance_asset_rec.INSTANCE_ID IS NOT NULL)
1682: AND (p_instance_asset_rec.INSTANCE_ID <> FND_API.G_MISS_NUM)) THEN
1683: IF NOT( CSI_Asset_vld_pvt.Is_InstanceID_Valid
1684: (p_instance_asset_rec.INSTANCE_ID
1685: ,p_instance_asset_rec.check_for_instance_expiry
1686: )) THEN
1687: RAISE FND_API.G_EXC_ERROR;

Line 1717: IF NOT( CSI_Asset_vld_pvt.Is_Update_Status_Exists

1713: --
1714: IF l_exists_flag <> 'Y' THEN
1715: p_asset_count_rec.lookup_count := p_asset_count_rec.lookup_count + 1;
1716: p_lookup_tbl(p_asset_count_rec.lookup_count).lookup_code := p_instance_asset_rec.update_status;
1717: IF NOT( CSI_Asset_vld_pvt.Is_Update_Status_Exists
1718: (p_instance_asset_rec.UPDATE_STATUS)) THEN
1719: p_lookup_tbl(p_asset_count_rec.lookup_count).valid_flag := 'N';
1720: RAISE FND_API.G_EXC_ERROR;
1721: ELSE

Line 1760: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Comb_Valid

1756: IF l_exists_flag <> 'Y' THEN
1757: p_asset_count_rec.asset_count := p_asset_count_rec.asset_count + 1;
1758: p_asset_id_tbl(p_asset_count_rec.asset_count).asset_id := p_instance_asset_rec.fa_asset_id;
1759: p_asset_id_tbl(p_asset_count_rec.asset_count).asset_book_type := p_instance_asset_rec.fa_book_type_code;
1760: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Comb_Valid
1761: (p_instance_asset_rec.FA_ASSET_ID ,
1762: p_instance_asset_rec.FA_BOOK_TYPE_CODE )) THEN
1763: p_asset_id_tbl(p_asset_count_rec.asset_count).valid_flag := 'N';
1764: RAISE fnd_api.g_exc_error;

Line 1800: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Location_Valid (p_instance_asset_rec.FA_LOCATION_ID )) THEN

1796: --
1797: IF l_exists_flag <> 'Y' THEN
1798: p_asset_count_rec.loc_count := p_asset_count_rec.loc_count + 1;
1799: p_asset_loc_tbl(p_asset_count_rec.loc_count).asset_loc_id := p_instance_asset_rec.fa_location_id;
1800: IF NOT( CSI_Asset_vld_pvt.Is_Asset_Location_Valid (p_instance_asset_rec.FA_LOCATION_ID )) THEN
1801: p_asset_loc_tbl(p_asset_count_rec.loc_count).valid_flag := 'N';
1802: RAISE fnd_api.g_exc_error;
1803: ELSE
1804: p_asset_loc_tbl(p_asset_count_rec.loc_count).valid_flag := 'Y';

Line 1824: IF NOT(CSI_Asset_vld_pvt.Is_EndDate_Valid

1820:
1821: -- Verify end effective end date
1822: IF ( p_instance_asset_rec.active_end_date <> FND_API.G_MISS_DATE) THEN
1823: IF p_instance_asset_rec.active_end_date IS NOT NULL THEN
1824: IF NOT(CSI_Asset_vld_pvt.Is_EndDate_Valid
1825: (p_instance_asset_rec.ACTIVE_START_DATE,
1826: p_instance_asset_rec.ACTIVE_END_DATE,
1827: p_instance_asset_rec.INSTANCE_ID ,
1828: p_instance_asset_rec.INSTANCE_ASSET_ID,

Line 1950: l_instance_asset_hist_id := CSI_Asset_vld_pvt.gen_inst_asset_hist_id;

1946: END IF;
1947: END IF;
1948:
1949: -- Generate the instance asset history id from the sequence
1950: l_instance_asset_hist_id := CSI_Asset_vld_pvt.gen_inst_asset_hist_id;
1951:
1952: -- Get the full_dump_frequency from csi_install_parameter
1953: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1954: csi_gen_utility_pvt.populate_install_param_rec;