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.AHL_UC_INSTANCE_PVT dependencies on AHL_UTIL_UC_PKG

Line 475: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN

471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: ELSE
473:
474: -- ACL :: Changes for R12
475: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
476: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
477: FND_MSG_PUB.add;
478: CLOSE check_uc_header;
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 482: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,

478: CLOSE check_uc_header;
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
480: END IF;
481:
482: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,
483: l_root_uc_header_id,
484: l_root_instance_id,
485: l_root_uc_status_code,
486: l_root_active_uc_status_code,

Line 541: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);

537: END IF;
538:
539: --The following lines are used to update the position_reference column in csi_ii_relationships
540: --First, get transaction_type_id .
541: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);
542: IF NOT l_return_value THEN
543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: END IF;
545: --Set the CSI transaction record

Line 923: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN

919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
920: ELSE
921:
922: -- ACL :: Changes for R12
923: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
924: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
925: FND_MSG_PUB.add;
926: CLOSE check_uc_header;
927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 930: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,

926: CLOSE check_uc_header;
927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;
929:
930: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,
931: l_root_uc_header_id,
932: l_root_instance_id,
933: l_root_uc_status_code,
934: l_root_active_uc_status_code,

Line 980: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);

976: END IF;
977:
978: --The following lines are used to update the position_reference column in csi_ii_relationships
979: --First, get transaction_type_id .
980: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);
981: IF NOT l_return_value THEN
982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
983: END IF;
984: --Set the CSI transaction record

Line 1085: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);

1081: WHERE unit_config_header_id = l_sub_uc_header_id;
1082: --Not necessary to check the object_version_number here
1083:
1084: --Copy the change to UC history table
1085: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);
1086: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1087: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1088: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1089: FND_MSG_PUB.add;

Line 1120: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);

1116: --AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1117: --Not necessary to check the object_version_number here
1118:
1119: --Copy the change to UC history table
1120: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);
1121: --IF history copy failed, then don't raise exception, just add the messae to the message stack
1122: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1123: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1124: FND_MSG_PUB.add;

Line 1133: NOT ahl_util_uc_pkg.extra_node(p_instance_id, l_root_instance_id)) THEN

1129: END IF;
1130: CLOSE check_instance_subunit;
1131:
1132: IF (l_position_reference IS NOT NULL AND
1133: NOT ahl_util_uc_pkg.extra_node(p_instance_id, l_root_instance_id)) THEN
1134: OPEN get_position_necessity(l_position_reference);
1135: FETCH get_position_necessity INTO l_position_necessity;
1136: IF get_position_necessity%NOTFOUND THEN
1137: FND_MESSAGE.set_name( 'AHL','AHL_UC_POSTION_INVALID' );

Line 1438: ' IS_UNIT_QUARANTINED ='||ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null));

1434: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1436: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API',
1437: ' p_uc_header_id = '||p_uc_header_id||
1438: ' IS_UNIT_QUARANTINED ='||ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null));
1439: END IF;
1440:
1441: -- ACL :: Changes for R12
1442: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN

Line 1442: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN

1438: ' IS_UNIT_QUARANTINED ='||ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null));
1439: END IF;
1440:
1441: -- ACL :: Changes for R12
1442: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
1443: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1444: FND_MSG_PUB.add;
1445: CLOSE check_uc_header;
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1449: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,

1445: CLOSE check_uc_header;
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: END IF;
1448:
1449: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,
1450: l_root_uc_header_id,
1451: l_root_instance_id,
1452: l_root_uc_status_code,
1453: l_root_active_uc_status_code,

Line 1525: AHL_UTIL_UC_PKG.getcsi_attribute_value(l_old_uc_instance_rec.instance_id,

1521: CLOSE get_instance_attributes;
1522:
1523: --Added by mpothuku on 16-Jul-2007 to fix the Bug 4337259
1524: --Retrieve the old serial tag code so that change validations can be performed
1525: AHL_UTIL_UC_PKG.getcsi_attribute_value(l_old_uc_instance_rec.instance_id,
1526: 'AHL_TEMP_SERIAL_NUM',
1527: l_attribute_value,
1528: l_attribute_value_id,
1529: l_object_version_number,

Line 1809: AHL_UTIL_UC_PKG.validate_for_position(l_uc_instance_rec.relationship_id,

1805:
1806: --dbms_output.put_line('after validating invdetails');
1807: --Validate positional attributes.
1808: /*
1809: AHL_UTIL_UC_PKG.validate_for_position(l_uc_instance_rec.relationship_id,
1810: l_uc_instance_rec.inventory_item_id,
1811: l_uc_instance_rec.inventory_org_id,
1812: l_uc_instance_rec.quantity,
1813: l_uc_instance_rec.revision,

Line 1857: AHL_UTIL_UC_PKG.getcsi_attribute_value(l_uc_instance_rec.instance_id,

1853: RAISE FND_API.G_EXC_ERROR;
1854: END IF;
1855:
1856: --Retrieve existing value of sn_tag_code if present.
1857: AHL_UTIL_UC_PKG.getcsi_attribute_value(l_uc_instance_rec.instance_id,
1858: 'AHL_TEMP_SERIAL_NUM',
1859: l_attribute_value,
1860: l_attribute_value_id,
1861: l_object_version_number,

Line 1891: AHL_Util_UC_Pkg.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM', l_attribute_id,l_return_val);

1887: --END IF;
1888: ELSIF (l_sn_tag_rec_found = 'N') THEN
1889: IF (l_uc_instance_rec.sn_tag_code IS NOT NULL) THEN
1890: -- create extended attributes.
1891: AHL_Util_UC_Pkg.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM', l_attribute_id,l_return_val);
1892: IF NOT(l_return_val) THEN
1893: FND_MESSAGE.Set_Name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
1894: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');
1895: FND_MSG_PUB.ADD;

Line 1908: AHL_UTIL_UC_PKG.getcsi_attribute_value(l_uc_instance_rec.instance_id,

1904: END IF;
1905: END IF;
1906:
1907: --Retrieve existing value of manufacturing date if present.
1908: AHL_UTIL_UC_PKG.getcsi_attribute_value(l_uc_instance_rec.instance_id,
1909: 'AHL_MFG_DATE',
1910: l_attribute_value,
1911: l_attribute_value_id,
1912: l_object_version_number,

Line 1949: AHL_Util_UC_Pkg.getcsi_attribute_id('AHL_MFG_DATE', l_attribute_id, l_return_val);

1945: l_csi_ext_attrib_values_tbl(l_subscript) := l_csi_extend_attrib_rec;
1946: --END IF;
1947: ELSIF (l_mfg_date_rec_found = 'N' ) THEN
1948: IF (l_uc_instance_rec.mfg_date IS NOT NULL) THEN
1949: AHL_Util_UC_Pkg.getcsi_attribute_id('AHL_MFG_DATE', l_attribute_id, l_return_val);
1950: IF NOT(l_return_val) THEN
1951: FND_MESSAGE.Set_Name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
1952: FND_MESSAGE.Set_Token('CODE', 'AHL_MFG_DATE');
1953: FND_MSG_PUB.ADD;

Line 2035: AHL_Util_UC_Pkg.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_val);

2031: -- END IF;
2032:
2033: --Build CSI transaction record
2034: --First get transaction_type_id
2035: AHL_Util_UC_Pkg.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_val);
2036:
2037: IF NOT(l_return_val) THEN
2038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2039: END IF;

Line 2474: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN

2470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2471: ELSE
2472:
2473: -- ACL :: Changes for R12
2474: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
2475: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
2476: FND_MSG_PUB.add;
2477: CLOSE check_uc_header;
2478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2481: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,

2477: CLOSE check_uc_header;
2478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2479: END IF;
2480:
2481: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,
2482: l_root_uc_header_id,
2483: l_root_instance_id,
2484: l_root_uc_status_code,
2485: l_root_active_uc_status_code,

Line 2648: AHL_UTIL_UC_PKG.validate_for_position(l_position_id,

2644:
2645: --Validate whether an item can be installed into a position, the position refers to the
2646: --top node position in the sub UC if sub UC information is provided otherwise it refers
2647: --to the position from Parent UC.
2648: AHL_UTIL_UC_PKG.validate_for_position(l_position_id,
2649: p_x_uc_instance_rec.inventory_Item_id,
2650: p_x_uc_instance_rec.inventory_Org_id,
2651: p_x_uc_instance_rec.quantity,
2652: p_x_uc_instance_rec.revision,

Line 2903: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_MFG_DATE',l_attribute_id, l_return_val);

2899:
2900: --Build csi extended attribs.
2901: IF (p_x_uc_instance_rec.mfg_date IS NOT NULL AND
2902: p_x_uc_instance_rec.mfg_date <> FND_API.G_MISS_DATE) THEN
2903: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_MFG_DATE',l_attribute_id, l_return_val);
2904: IF NOT(l_return_val) THEN
2905: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
2906: FND_MESSAGE.set_token('CODE', 'AHL_MFG_DATE');
2907: FND_MSG_PUB.add;

Line 2919: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);

2915: END IF;
2916:
2917: IF (p_x_uc_instance_rec.serial_number IS NOT NULL AND
2918: p_x_uc_instance_rec.serial_number <> FND_API.G_MISS_CHAR) THEN
2919: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
2920:
2921: IF NOT(l_return_val) THEN
2922: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
2923: FND_MESSAGE.set_token('CODE', 'AHL_TEMP_SERIAL_NUM');

Line 2952: AHL_Util_UC_Pkg.getcsi_transaction_id('UC_CREATE',l_transaction_type_id, l_return_val);

2948: l_csi_account_tbl(i) := l_party_account_rec;
2949: END LOOP;
2950:
2951: --Build CSI transaction record, first get transaction_type_id
2952: AHL_Util_UC_Pkg.getcsi_transaction_id('UC_CREATE',l_transaction_type_id, l_return_val);
2953:
2954: IF NOT(l_return_val) THEN
2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2956: END IF;

Line 3052: ahl_util_uc_pkg.get_parent_uc_header(l_new_instance_id,

3048: IF l_sub_mc_header_id IS NOT NULL THEN
3049: --Insert the newly added sub unit into UC headers table.
3050: p_x_sub_uc_rec.mc_header_id := l_sub_mc_header_id;
3051: p_x_sub_uc_rec.instance_id := l_new_instance_id;
3052: ahl_util_uc_pkg.get_parent_uc_header(l_new_instance_id,
3053: l_parent_uc_header_id,
3054: l_parent_instance_id);
3055: p_x_sub_uc_rec.parent_uc_header_id := l_parent_uc_header_id;
3056: --p_x_sub_uc_rec.parent_uc_header_id := p_uc_header_id;

Line 3100: ahl_util_uc_pkg.copy_uc_header_to_history(p_x_sub_uc_rec.uc_header_id, l_return_status);

3096: END IF;
3097: --dbms_output.put_line('After calling create uc_header API:...');
3098:
3099: --Copy the newly created UC header to history table
3100: ahl_util_uc_pkg.copy_uc_header_to_history(p_x_sub_uc_rec.uc_header_id, l_return_status);
3101:
3102: --IF history copy failed, then don't raise exception, just add the message to the message stack
3103: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3104: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

Line 3675: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN

3671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3672: ELSE
3673:
3674: -- ACL :: Changes for R12
3675: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
3676: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
3677: FND_MSG_PUB.add;
3678: CLOSE check_uc_header;
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3682: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,

3678: CLOSE check_uc_header;
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3680: END IF;
3681:
3682: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,
3683: l_root_uc_header_id,
3684: l_root_instance_id,
3685: l_root_uc_status_code,
3686: l_root_active_uc_status_code,

Line 3803: AHL_UTIL_UC_PKG.convert_to_csimeaning('CSI_INST_LOCATION_SOURCE_CODE',

3799: */
3800: --Validate the status of the instance
3801: IF (l_instance_rec.location_type_code IN ('PO','IN-TRANSIT','PROJECT','INVENTORY')) THEN
3802: FND_MESSAGE.set_name('AHL','AHL_UC_INST_STATUS_INVALID');
3803: AHL_UTIL_UC_PKG.convert_to_csimeaning('CSI_INST_LOCATION_SOURCE_CODE',
3804: l_instance_rec.location_type_code,
3805: l_meaning,l_return_val);
3806: IF NOT(l_return_val) THEN
3807: l_meaning := l_instance_rec.location_type_code;

Line 3817: AHL_UTIL_UC_PKG.validate_for_position(p_relationship_id,

3813:
3814: --If the instance is not a unit, then validate positional attributes. For unit, it is not
3815: --necessary to validate.
3816: IF (l_instance_rec.uc_header_id IS NULL) THEN
3817: AHL_UTIL_UC_PKG.validate_for_position(p_relationship_id,
3818: l_instance_rec.inventory_item_id,
3819: l_instance_rec.inventory_org_id,
3820: l_instance_rec.quantity,
3821: l_instance_rec.revision,

Line 3876: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => l_sub_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN

3872: OPEN get_uc_header(p_instance_id);
3873: FETCH get_uc_header INTO l_sub_uc_header_id, l_mc_header_id;
3874: IF get_uc_header%FOUND THEN
3875: -- ACL :: R12 Changes
3876: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => l_sub_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
3877: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
3878: FND_MSG_PUB.add;
3879: CLOSE check_uc_header;
3880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3933: AHL_Util_UC_Pkg.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_val);

3929: END IF;
3930: CLOSE get_uc_header;
3931:
3932: --Build CSI transaction record, first get transaction_type_id
3933: AHL_Util_UC_Pkg.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_val);
3934: IF NOT(l_return_val) THEN
3935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3936: END IF;
3937:

Line 3989: AHL_UTIL_UC_PKG.getcsi_attribute_value(p_instance_id,

3985: END IF;
3986:
3987: IF l_serial_number IS NOT NULL THEN
3988: --Retrieve existing value of serial_number_tag if present.
3989: AHL_UTIL_UC_PKG.getcsi_attribute_value(p_instance_id,
3990: 'AHL_TEMP_SERIAL_NUM',
3991: l_attribute_value,
3992: l_attribute_value_id,
3993: l_object_version_number,

Line 4006: AHL_Util_UC_Pkg.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM', l_attribute_id, l_return_val);

4002: END IF;
4003: */
4004: l_serial_number_tag := 'ACTUAL';
4005: --mpothuku End
4006: AHL_Util_UC_Pkg.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM', l_attribute_id, l_return_val);
4007:
4008: IF NOT(l_return_val) THEN
4009: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
4010: FND_MESSAGE.set_token('CODE', 'AHL_TEMP_SERIAL_NUM');

Line 4192: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,

4188: --to another unit and automatically becomes a sub-unit, then it loses all its statuses. So
4189: --we don't have to update the two statuses here.
4190:
4191: IF l_subunit THEN
4192: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,
4193: l_parent_uc_header_id,
4194: l_parent_instance_id);
4195: UPDATE ahl_unit_config_headers
4196: --SET parent_uc_header_id = p_uc_header_id

Line 4208: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);

4204: WHERE csi_item_instance_id = p_instance_id
4205: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4206: --Not necessary to check the object_version_number here
4207: --Copy the change to history table
4208: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);
4209: --IF history copy failed, then don't raise exception, just add the message to the message stack
4210: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4211: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
4212: FND_MSG_PUB.add;

Line 4215: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,

4211: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
4212: FND_MSG_PUB.add;
4213: END IF;
4214: ELSIF l_instance_type = 'B' THEN --this instance is a branch node
4215: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,
4216: l_parent_uc_header_id,
4217: l_parent_instance_id);
4218: FOR l_get_1st_level_subunit IN get_1st_level_subunits(p_instance_id) LOOP
4219: UPDATE ahl_unit_config_headers

Line 4242: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);

4238: CLOSE get_uc_header;
4239: END IF;
4240:
4241: --Copy the change to history table
4242: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);
4243: --IF history copy failed, then don't raise exception, just add the messageto the message stack
4244:
4245: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4246: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

Line 5234: AHL_UTIL_UC_PKG.validate_for_position(p_mc_relationship_id => p_relationship_id,

5230: --If the instance is not a unit then, call procedure to validate whether thecorresponding inventory
5231: --can be assigned to that position
5232:
5233: IF l_subinv_inst_rec.uc_header_id IS NULL THEN
5234: AHL_UTIL_UC_PKG.validate_for_position(p_mc_relationship_id => p_relationship_id,
5235: p_inventory_id => l_subinv_inst_rec.inventory_item_id,
5236: p_organization_id => l_subinv_inst_rec.inv_master_organization_id,
5237: p_quantity => l_subinv_inst_rec.quantity,
5238: p_revision => l_subinv_inst_rec.inventory_revision,

Line 5285: -- the logic in ahl_util_uc_pkg.getcsi_locationDesc need to be modified or

5281: x_avail_subinv_instance_tbl(j).quantity := l_instance_details_rec.quantity;
5282: x_avail_subinv_instance_tbl(j).install_date := l_instance_details_rec.install_date;
5283: x_avail_subinv_instance_tbl(j).mfg_date := l_instance_details_rec.mfg_date;
5284: -- Verify if location description return correct details else
5285: -- the logic in ahl_util_uc_pkg.getcsi_locationDesc need to be modified or
5286: -- a new cursor need to be opened to get correct description.
5287: x_avail_subinv_instance_tbl(j).location_description := l_instance_details_rec.location_description;
5288: x_avail_subinv_instance_tbl(j).party_type := l_instance_details_rec.party_type;
5289: x_avail_subinv_instance_tbl(j).owner_site_number := l_instance_details_rec.owner_site_number;

Line 5703: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) =

5699: mp.organization_Id = io.organization_id AND
5700: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5701: mo_global.get_current_org_id()
5702: )
5703: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) =
5704: FND_API.G_FALSE
5705: ORDER BY 2;
5706:
5707: CURSOR check_relationship_id IS

Line 6037: AHL_UTIL_UC_PKG.validate_for_position(p_mc_relationship_id => p_relationship_id,

6033: ELSE
6034: l_ignore_quant_vald := 'N';
6035: END IF;
6036:
6037: AHL_UTIL_UC_PKG.validate_for_position(p_mc_relationship_id => p_relationship_id,
6038: p_inventory_id => l_inventory_item_id,
6039: p_organization_id => l_inventory_Org_id,
6040: p_quantity => l_quantity,
6041: p_revision => l_inventory_revision,

Line 6452: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_MFG_DATE',l_attribute_id, l_return_val);

6448:
6449: -- Build CSI extended attribs
6450: IF (p_x_uc_instance_rec.mfg_date IS NOT NULL AND
6451: p_x_uc_instance_rec.mfg_date <> FND_API.G_MISS_DATE) THEN
6452: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_MFG_DATE',l_attribute_id, l_return_val);
6453:
6454: IF NOT(l_return_val) THEN
6455: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
6456: FND_MESSAGE.set_token('CODE', 'AHL_MFG_DATE');

Line 6468: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);

6464: END IF;
6465:
6466: IF (p_x_uc_instance_rec.serial_number IS NOT NULL AND
6467: p_x_uc_instance_rec.serial_number <> FND_API.G_MISS_CHAR) THEN
6468: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
6469:
6470: IF NOT(l_return_val) THEN
6471: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
6472: FND_MESSAGE.set_token('CODE', 'AHL_TEMP_SERIAL_NUM');

Line 6505: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_CREATE',l_transaction_type_id, l_return_val);

6501: l_csi_account_tbl(i) := l_party_account_rec;
6502: END LOOP;
6503:
6504: -- Build CSI transaction record, first get transaction_type_id
6505: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_CREATE',l_transaction_type_id, l_return_val);
6506:
6507: IF NOT(l_return_val) THEN
6508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6509: END IF;

Line 6854: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) = FND_API.G_FALSE

6850: AND mp.organization_Id = io.organization_id
6851: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
6852: )
6853: -- Do not get quarantined units
6854: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) = FND_API.G_FALSE
6855: -- Org Filtering: If p_supply_location_type is INVENTORY, filter by the org by the passed in p_organization_name
6856: AND CII.inv_organization_id = HAOUT.organization_id(+)
6857: AND HAOUT.language = USERENV('LANG')
6858: AND HAOUT.NAME LIKE DECODE(p_supply_location_type, 'INVENTORY', NVL(c_organization_name, '%'), HAOUT.NAME)

Line 7009: AHL_UTIL_UC_PKG.validate_for_position(p_mc_relationship_id => l_asm_details_rec.relationship_id,

7005: -- If the instance is not a unit then, call procedure to validate whether the corresponding inventory
7006: -- can be assigned to that position
7007: IF l_uc_header_id IS NULL THEN
7008:
7009: AHL_UTIL_UC_PKG.validate_for_position(p_mc_relationship_id => l_asm_details_rec.relationship_id,
7010: p_inventory_id => l_inventory_item_id,
7011: p_organization_id => l_inv_master_org_id,
7012: p_quantity => l_quantity,
7013: p_revision => l_inventory_revision,

Line 7201: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) = FND_API.G_FALSE;

7197: AND mp.organization_Id = io.organization_id
7198: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
7199: )
7200: -- Do not get quarantined units
7201: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) = FND_API.G_FALSE;
7202:
7203: l_api_name CONSTANT VARCHAR2(30) := 'is_instance_valid_for_pos';
7204: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;
7205: l_relationship_id NUMBER;