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 2468: 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

2464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2465: ELSE
2466:
2467: -- ACL :: Changes for R12
2468: 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
2469: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
2470: FND_MSG_PUB.add;
2471: CLOSE check_uc_header;
2472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2475: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,

2471: CLOSE check_uc_header;
2472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2473: END IF;
2474:
2475: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,
2476: l_root_uc_header_id,
2477: l_root_instance_id,
2478: l_root_uc_status_code,
2479: l_root_active_uc_status_code,

Line 2642: AHL_UTIL_UC_PKG.validate_for_position(l_position_id,

2638:
2639: --Validate whether an item can be installed into a position, the position refers to the
2640: --top node position in the sub UC if sub UC information is provided otherwise it refers
2641: --to the position from Parent UC.
2642: AHL_UTIL_UC_PKG.validate_for_position(l_position_id,
2643: p_x_uc_instance_rec.inventory_Item_id,
2644: p_x_uc_instance_rec.inventory_Org_id,
2645: p_x_uc_instance_rec.quantity,
2646: p_x_uc_instance_rec.revision,

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

2893:
2894: --Build csi extended attribs.
2895: IF (p_x_uc_instance_rec.mfg_date IS NOT NULL AND
2896: p_x_uc_instance_rec.mfg_date <> FND_API.G_MISS_DATE) THEN
2897: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_MFG_DATE',l_attribute_id, l_return_val);
2898: IF NOT(l_return_val) THEN
2899: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
2900: FND_MESSAGE.set_token('CODE', 'AHL_MFG_DATE');
2901: FND_MSG_PUB.add;

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

2909: END IF;
2910:
2911: IF (p_x_uc_instance_rec.serial_number IS NOT NULL AND
2912: p_x_uc_instance_rec.serial_number <> FND_API.G_MISS_CHAR) THEN
2913: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
2914:
2915: IF NOT(l_return_val) THEN
2916: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
2917: FND_MESSAGE.set_token('CODE', 'AHL_TEMP_SERIAL_NUM');

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

2942: l_csi_account_tbl(i) := l_party_account_rec;
2943: END LOOP;
2944:
2945: --Build CSI transaction record, first get transaction_type_id
2946: AHL_Util_UC_Pkg.getcsi_transaction_id('UC_CREATE',l_transaction_type_id, l_return_val);
2947:
2948: IF NOT(l_return_val) THEN
2949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2950: END IF;

Line 3046: ahl_util_uc_pkg.get_parent_uc_header(l_new_instance_id,

3042: IF l_sub_mc_header_id IS NOT NULL THEN
3043: --Insert the newly added sub unit into UC headers table.
3044: p_x_sub_uc_rec.mc_header_id := l_sub_mc_header_id;
3045: p_x_sub_uc_rec.instance_id := l_new_instance_id;
3046: ahl_util_uc_pkg.get_parent_uc_header(l_new_instance_id,
3047: l_parent_uc_header_id,
3048: l_parent_instance_id);
3049: p_x_sub_uc_rec.parent_uc_header_id := l_parent_uc_header_id;
3050: --p_x_sub_uc_rec.parent_uc_header_id := p_uc_header_id;

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

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

Line 3659: 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

3655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3656: ELSE
3657:
3658: -- ACL :: Changes for R12
3659: 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
3660: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
3661: FND_MSG_PUB.add;
3662: CLOSE check_uc_header;
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3666: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,

3662: CLOSE check_uc_header;
3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END IF;
3665:
3666: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,
3667: l_root_uc_header_id,
3668: l_root_instance_id,
3669: l_root_uc_status_code,
3670: l_root_active_uc_status_code,

Line 3787: AHL_UTIL_UC_PKG.convert_to_csimeaning('CSI_INST_LOCATION_SOURCE_CODE',

3783: */
3784: --Validate the status of the instance
3785: IF (l_instance_rec.location_type_code IN ('PO','IN-TRANSIT','PROJECT','INVENTORY')) THEN
3786: FND_MESSAGE.set_name('AHL','AHL_UC_INST_STATUS_INVALID');
3787: AHL_UTIL_UC_PKG.convert_to_csimeaning('CSI_INST_LOCATION_SOURCE_CODE',
3788: l_instance_rec.location_type_code,
3789: l_meaning,l_return_val);
3790: IF NOT(l_return_val) THEN
3791: l_meaning := l_instance_rec.location_type_code;

Line 3801: AHL_UTIL_UC_PKG.validate_for_position(p_relationship_id,

3797:
3798: --If the instance is not a unit, then validate positional attributes. For unit, it is not
3799: --necessary to validate.
3800: IF (l_instance_rec.uc_header_id IS NULL) THEN
3801: AHL_UTIL_UC_PKG.validate_for_position(p_relationship_id,
3802: l_instance_rec.inventory_item_id,
3803: l_instance_rec.inventory_org_id,
3804: l_instance_rec.quantity,
3805: l_instance_rec.revision,

Line 3860: 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

3856: OPEN get_uc_header(p_instance_id);
3857: FETCH get_uc_header INTO l_sub_uc_header_id, l_mc_header_id;
3858: IF get_uc_header%FOUND THEN
3859: -- ACL :: R12 Changes
3860: 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
3861: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
3862: FND_MSG_PUB.add;
3863: CLOSE check_uc_header;
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3913: END IF;
3914: CLOSE get_uc_header;
3915:
3916: --Build CSI transaction record, first get transaction_type_id
3917: AHL_Util_UC_Pkg.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_val);
3918: IF NOT(l_return_val) THEN
3919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3920: END IF;
3921:

Line 3973: AHL_UTIL_UC_PKG.getcsi_attribute_value(p_instance_id,

3969: END IF;
3970:
3971: IF l_serial_number IS NOT NULL THEN
3972: --Retrieve existing value of serial_number_tag if present.
3973: AHL_UTIL_UC_PKG.getcsi_attribute_value(p_instance_id,
3974: 'AHL_TEMP_SERIAL_NUM',
3975: l_attribute_value,
3976: l_attribute_value_id,
3977: l_object_version_number,

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

3986: END IF;
3987: */
3988: l_serial_number_tag := 'ACTUAL';
3989: --mpothuku End
3990: AHL_Util_UC_Pkg.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM', l_attribute_id, l_return_val);
3991:
3992: IF NOT(l_return_val) THEN
3993: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
3994: FND_MESSAGE.set_token('CODE', 'AHL_TEMP_SERIAL_NUM');

Line 4176: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,

4172: --to another unit and automatically becomes a sub-unit, then it loses all its statuses. So
4173: --we don't have to update the two statuses here.
4174:
4175: IF l_subunit THEN
4176: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,
4177: l_parent_uc_header_id,
4178: l_parent_instance_id);
4179: UPDATE ahl_unit_config_headers
4180: --SET parent_uc_header_id = p_uc_header_id

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

4188: WHERE csi_item_instance_id = p_instance_id
4189: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4190: --Not necessary to check the object_version_number here
4191: --Copy the change to history table
4192: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);
4193: --IF history copy failed, then don't raise exception, just add the message to the message stack
4194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4195: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
4196: FND_MSG_PUB.add;

Line 4199: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,

4195: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
4196: FND_MSG_PUB.add;
4197: END IF;
4198: ELSIF l_instance_type = 'B' THEN --this instance is a branch node
4199: ahl_util_uc_pkg.get_parent_uc_header(p_instance_id,
4200: l_parent_uc_header_id,
4201: l_parent_instance_id);
4202: FOR l_get_1st_level_subunit IN get_1st_level_subunits(p_instance_id) LOOP
4203: UPDATE ahl_unit_config_headers

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

4222: CLOSE get_uc_header;
4223: END IF;
4224:
4225: --Copy the change to history table
4226: ahl_util_uc_pkg.copy_uc_header_to_history(l_sub_uc_header_id, l_return_status);
4227: --IF history copy failed, then don't raise exception, just add the messageto the message stack
4228:
4229: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4230: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

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

5135: --If the instance is not a unit then, call procedure to validate whether thecorresponding inventory
5136: --can be assigned to that position
5137:
5138: IF l_subinv_inst_rec.uc_header_id IS NULL THEN
5139: AHL_UTIL_UC_PKG.validate_for_position(p_mc_relationship_id => p_relationship_id,
5140: p_inventory_id => l_subinv_inst_rec.inventory_item_id,
5141: p_organization_id => l_subinv_inst_rec.inv_master_organization_id,
5142: p_quantity => l_subinv_inst_rec.quantity,
5143: p_revision => l_subinv_inst_rec.inventory_revision,

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

5186: x_avail_subinv_instance_tbl(j).quantity := l_instance_details_rec.quantity;
5187: x_avail_subinv_instance_tbl(j).install_date := l_instance_details_rec.install_date;
5188: x_avail_subinv_instance_tbl(j).mfg_date := l_instance_details_rec.mfg_date;
5189: -- Verify if location description return correct details else
5190: -- the logic in ahl_util_uc_pkg.getcsi_locationDesc need to be modified or
5191: -- a new cursor need to be opened to get correct description.
5192: x_avail_subinv_instance_tbl(j).location_description := l_instance_details_rec.location_description;
5193: x_avail_subinv_instance_tbl(j).party_type := l_instance_details_rec.party_type;
5194: x_avail_subinv_instance_tbl(j).owner_site_number := l_instance_details_rec.owner_site_number;

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

5592: mp.organization_Id = io.organization_id AND
5593: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5594: mo_global.get_current_org_id()
5595: )
5596: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) =
5597: FND_API.G_FALSE
5598: ORDER BY 2;
5599:
5600: CURSOR check_relationship_id IS

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

5926: ELSE
5927: l_ignore_quant_vald := 'N';
5928: END IF;
5929:
5930: AHL_UTIL_UC_PKG.validate_for_position(p_mc_relationship_id => p_relationship_id,
5931: p_inventory_id => l_inventory_item_id,
5932: p_organization_id => l_inventory_Org_id,
5933: p_quantity => l_quantity,
5934: p_revision => l_inventory_revision,

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

6341:
6342: -- Build CSI extended attribs
6343: IF (p_x_uc_instance_rec.mfg_date IS NOT NULL AND
6344: p_x_uc_instance_rec.mfg_date <> FND_API.G_MISS_DATE) THEN
6345: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_MFG_DATE',l_attribute_id, l_return_val);
6346:
6347: IF NOT(l_return_val) THEN
6348: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
6349: FND_MESSAGE.set_token('CODE', 'AHL_MFG_DATE');

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

6357: END IF;
6358:
6359: IF (p_x_uc_instance_rec.serial_number IS NOT NULL AND
6360: p_x_uc_instance_rec.serial_number <> FND_API.G_MISS_CHAR) THEN
6361: AHL_UTIL_UC_PKG.getcsi_attribute_id('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
6362:
6363: IF NOT(l_return_val) THEN
6364: FND_MESSAGE.set_name('AHL','AHL_UC_ATTRIB_CODE_MISSING');
6365: FND_MESSAGE.set_token('CODE', 'AHL_TEMP_SERIAL_NUM');

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

6394: l_csi_account_tbl(i) := l_party_account_rec;
6395: END LOOP;
6396:
6397: -- Build CSI transaction record, first get transaction_type_id
6398: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_CREATE',l_transaction_type_id, l_return_val);
6399:
6400: IF NOT(l_return_val) THEN
6401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6402: END IF;