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_MC_ITEMGROUP_PVT dependencies on FND_API

Line 29: IF (p_name IS NULL OR p_name = FND_API.G_MISS_CHAR) THEN

25: l_junk VARCHAR2(1);
26:
27: BEGIN
28:
29: IF (p_name IS NULL OR p_name = FND_API.G_MISS_CHAR) THEN
30: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_NAME_NULL');
31: FND_MSG_PUB.ADD;
32: RETURN;
33: END IF;

Line 82: RAISE FND_API.G_EXC_ERROR;

78: true
79: );
80: END IF;
81: CLOSE check_priority_dup_exists;
82: RAISE FND_API.G_EXC_ERROR;
83: END IF;
84:
85: END Validate_priority;
86:

Line 123: RAISE FND_API.G_EXC_ERROR;

119: true
120: );
121: END IF;
122: CLOSE check_revision_dup_exists;
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;
125:
126: END Validate_IG_revision;
127: --Priyan IG Mass Update Changes Ends.

Line 238: x_return_status := FND_API.G_RET_STS_SUCCESS;

234: END IF;
235:
236: -- SATHAPLI::Bug# 5566764 fix
237: -- Initialize API return status to success
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: BEGIN
241: -- Retrieve the items that are invalidated in the current revision
242: SELECT SOURCE.item_group_id,

Line 297: p_init_msg_list => FND_API.G_FALSE,

293: -- Call UC procedure to check if active Units are getting affected
294: AHL_UTIL_UC_PKG.Check_Invalidate_Instance
295: (
296: p_api_version => 1.0,
297: p_init_msg_list => FND_API.G_FALSE,
298: p_instance_tbl => l_invalid_item_instance_tbl,
299: p_operator => 'U',
300: x_return_status => x_return_status,
301: x_msg_count => x_msg_count,

Line 352: OR (p_inventory_item_id = FND_API.G_MISS_NUM)

348:
349: BEGIN
350:
351: IF (p_inventory_item_id IS NULL)
352: OR (p_inventory_item_id = FND_API.G_MISS_NUM)
353: OR (p_inventory_org_id IS NULL)
354: OR (p_inventory_org_id = FND_API.G_MISS_NUM) THEN
355: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NULL');
356: --FND_MESSAGE.Set_Token('INV_ITEM',p_inventory_item_id);

Line 354: OR (p_inventory_org_id = FND_API.G_MISS_NUM) THEN

350:
351: IF (p_inventory_item_id IS NULL)
352: OR (p_inventory_item_id = FND_API.G_MISS_NUM)
353: OR (p_inventory_org_id IS NULL)
354: OR (p_inventory_org_id = FND_API.G_MISS_NUM) THEN
355: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NULL');
356: --FND_MESSAGE.Set_Token('INV_ITEM',p_inventory_item_id);
357: FND_MSG_PUB.ADD;
358: --dbms_output.put_line('Inventory item is null.');

Line 432: OR p_interchange_type_code = FND_API.G_MISS_CHAR) THEN

428: p_inv_segment IN VARCHAR2) IS
429:
430: BEGIN
431: IF (p_interchange_type_code IS NULL
432: OR p_interchange_type_code = FND_API.G_MISS_CHAR) THEN
433: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_TYP_NULL');
434: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
435: FND_MSG_PUB.ADD;
436: RETURN;

Line 480: IF (p_revision IS NULL) OR (p_revision = FND_API.G_MISS_CHAR) THEN

476:
477: l_junk VARCHAR2(1);
478:
479: BEGIN
480: IF (p_revision IS NULL) OR (p_revision = FND_API.G_MISS_CHAR) THEN
481: RETURN;
482: END IF;
483:
484: IF (nvl(p_revision_qty_control_code,0) <> 2) THEN

Line 564: IF (p_item_revision = FND_API.G_MISS_CHAR OR p_item_revision IS NULL) THEN

560:
561: BEGIN
562:
563: IF (p_operation_flag = 'C' ) THEN
564: IF (p_item_revision = FND_API.G_MISS_CHAR OR p_item_revision IS NULL) THEN
565: OPEN item_revnotnull_csr(p_item_group_id, p_inventory_item_id, p_inventory_org_id);
566: FETCH item_revnotnull_csr INTO l_junk;
567: IF (item_revnotnull_csr%FOUND) THEN
568: if l_junk is not null then

Line 607: IF (p_item_revision = FND_API.G_MISS_CHAR OR p_item_revision IS NULL) THEN

603: CLOSE rev_exists_csr;
604: END IF;
605: END IF;
606: ELSIF (p_operation_flag = 'M' ) THEN
607: IF (p_item_revision = FND_API.G_MISS_CHAR OR p_item_revision IS NULL) THEN
608: -- Check if any record exists, in the DB .
609: -- If there are more than one row then the user cannot change the revison to Null as other not nul revision exists.
610: -- If there is only one record, then no validation is required.
611: -- If there are no records , then do nothing.

Line 636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

632: FND_MSG_PUB.ADD;
633: WHEN NO_DATA_FOUND THEN
634: NULL;
635: WHEN OTHERS THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END;
638:
639: /*ELSE --commented out for mass update changes --Priyan
640:

Line 682: IF (p_item_revision = FND_API.G_MISS_CHAR OR p_item_revision IS NULL) THEN

678: BEGIN
679: -- Bug Number 4069855
680: -- Changed on 21st Dec 2004, to allow for Items with different revisions to be added to the same Item Group
681: -- Now we have different Error mesages, depending on the combination which is Duplicate
682: IF (p_item_revision = FND_API.G_MISS_CHAR OR p_item_revision IS NULL) THEN
683: OPEN item_assoc_csr(p_item_group_id, p_inventory_item_id,'000', p_inventory_org_id);
684: FETCH item_assoc_csr INTO l_junk;
685: IF (item_assoc_csr%FOUND) THEN
686: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_DUP');

Line 721: IF (p_uom_code IS NULL OR p_uom_code = FND_API.G_MISS_CHAR) THEN

717: END IF;
718:
719:
720: -- Check if UOM entered and valid.
721: IF (p_uom_code IS NULL OR p_uom_code = FND_API.G_MISS_CHAR) THEN
722: -- uom_code is null but quantity is not null.
723: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_NULL');
724: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
725: FND_MSG_PUB.ADD;

Line 739: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN

735: --dbms_output.put_line('Invalid UOM code for the item');
736: END IF;
737:
738: -- Validate quantity.
739: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN
740: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
741: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
742: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
743: FND_MSG_PUB.ADD;

Line 929: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

925: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IA_INVALID'); -- Invalid association of item ITEM.
926: FND_MESSAGE.Set_Token('ITEM', l_x_item_assoc_rec.inventory_item_name);
927: FND_MSG_PUB.ADD;
928: --dbms_output.put_line('Item Assoc does not exist');
929: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931:
932: -- Set variables.
933: x_row_id := l_item_assoc_rec.row_id;

Line 960: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

956:
957: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');
958: FND_MSG_PUB.ADD;
959: --dbms_output.put_line('Primary key cannot be updated');
960: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962:
963: -- plug primary key values.
964: l_x_item_assoc_rec.inventory_item_id := l_item_assoc_rec.inventory_item_id;

Line 1003: IF (l_x_item_assoc_rec.revision = FND_API.G_MISS_CHAR OR l_x_item_assoc_rec.revision IS NULL) THEN

999:
1000: -- Bug Number 4069855
1001: -- Changed on 21st Dec 2004 , to allow for Items with different revisions to be added to the same Group
1002: -- 000 is used to denote that user has not entered a revision
1003: IF (l_x_item_assoc_rec.revision = FND_API.G_MISS_CHAR OR l_x_item_assoc_rec.revision IS NULL) THEN
1004: l_inventory_item_revision := '000';
1005: ELSE
1006: l_inventory_item_revision := l_x_item_assoc_rec.revision;
1007: END IF;

Line 1057: nvl(l_x_item_assoc_rec.revision,FND_API.G_MISS_CHAR) <>

1053:
1054: --Priyan (revision check change for update for Item Group)
1055: --Bug # 4330922
1056: if (( l_x_item_assoc_rec.operation_flag = 'M') and
1057: nvl(l_x_item_assoc_rec.revision,FND_API.G_MISS_CHAR) <>
1058: nvl(l_item_assoc_rec.revision,FND_API.G_MISS_CHAR)) THEN
1059:
1060: Validate_Dup_Inventory(p_name,
1061: p_item_group_id,

Line 1058: nvl(l_item_assoc_rec.revision,FND_API.G_MISS_CHAR)) THEN

1054: --Priyan (revision check change for update for Item Group)
1055: --Bug # 4330922
1056: if (( l_x_item_assoc_rec.operation_flag = 'M') and
1057: nvl(l_x_item_assoc_rec.revision,FND_API.G_MISS_CHAR) <>
1058: nvl(l_item_assoc_rec.revision,FND_API.G_MISS_CHAR)) THEN
1059:
1060: Validate_Dup_Inventory(p_name,
1061: p_item_group_id,
1062: l_x_item_assoc_rec.inventory_item_id,

Line 1094: IF (l_x_item_assoc_rec.priority <> FND_API.G_MISS_NUM AND l_x_item_assoc_rec.priority IS NOT NULL)

1090: END IF;
1091:
1092:
1093: -- Validate priority only for 'Create' and if changed during modify.
1094: IF (l_x_item_assoc_rec.priority <> FND_API.G_MISS_NUM AND l_x_item_assoc_rec.priority IS NOT NULL)
1095: THEN
1096: IF (l_x_item_assoc_rec.priority <= 0) THEN
1097: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_INVALID');
1098: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);

Line 1104: (l_x_item_assoc_rec.operation_flag = 'M' AND l_x_item_assoc_rec.priority = FND_API.G_MISS_NUM) THEN

1100: FND_MSG_PUB.ADD;
1101: --dbms_output.put_line('Invalid priority');
1102: END IF;
1103: ELSIF l_x_item_assoc_rec.operation_flag = 'C' OR
1104: (l_x_item_assoc_rec.operation_flag = 'M' AND l_x_item_assoc_rec.priority = FND_API.G_MISS_NUM) THEN
1105: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_NULL');
1106: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1107: FND_MSG_PUB.ADD;
1108: --dbms_output.put_line('Null priority');

Line 1118: IF (l_x_item_assoc_rec.quantity = FND_API.G_MISS_NUM) THEN

1114: l_uom_code := l_x_item_assoc_rec.uom_code;
1115: ELSIF (l_x_item_assoc_rec.operation_flag = 'M') THEN
1116:
1117: -- For quantity
1118: IF (l_x_item_assoc_rec.quantity = FND_API.G_MISS_NUM) THEN
1119: l_quantity := null;
1120: ELSIF (l_x_item_assoc_rec.quantity is null ) THEN
1121: l_quantity := l_item_assoc_rec.quantity;
1122: ELSE

Line 1127: IF (l_x_item_assoc_rec.uom_code = FND_API.G_MISS_CHAR) THEN

1123: l_quantity := l_x_item_assoc_rec.quantity;
1124: END IF;
1125:
1126: -- For uom code.
1127: IF (l_x_item_assoc_rec.uom_code = FND_API.G_MISS_CHAR) THEN
1128: l_uom_code := null;
1129: ELSIF (l_x_item_assoc_rec.uom_code is null) THEN
1130: l_uom_code := l_item_assoc_rec.uom_code;
1131: ELSE

Line 1158: l_quantity = FND_API.G_MISS_NUM) THEN

1154: THEN
1155: IF (nvl(l_serial_number_control,0) IN (2,5,6)) THEN
1156: IF (l_quantity IS NULL OR
1157: l_quantity = 0 OR
1158: l_quantity = FND_API.G_MISS_NUM) THEN
1159: FND_MESSAGE.Set_Name('AHL','AHL_MC_SRLQTY_NULL');
1160: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1161: FND_MSG_PUB.ADD;
1162: --dbms_output.put_line('Invalid UOM code for the item');

Line 1204: IF p_x_item_grp_rec.DESCRIPTION = FND_API.G_MISS_CHAR THEN

1200:
1201: BEGIN
1202:
1203: -- Set default values.
1204: IF p_x_item_grp_rec.DESCRIPTION = FND_API.G_MISS_CHAR THEN
1205: p_x_item_grp_rec.DESCRIPTION := null;
1206: END IF;
1207: IF p_x_item_grp_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR THEN
1208: p_x_item_grp_rec.ATTRIBUTE_CATEGORY := null;

Line 1207: IF p_x_item_grp_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR THEN

1203: -- Set default values.
1204: IF p_x_item_grp_rec.DESCRIPTION = FND_API.G_MISS_CHAR THEN
1205: p_x_item_grp_rec.DESCRIPTION := null;
1206: END IF;
1207: IF p_x_item_grp_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR THEN
1208: p_x_item_grp_rec.ATTRIBUTE_CATEGORY := null;
1209: END IF;
1210: IF p_x_item_grp_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
1211: p_x_item_grp_rec.ATTRIBUTE1 := null;

Line 1210: IF p_x_item_grp_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN

1206: END IF;
1207: IF p_x_item_grp_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR THEN
1208: p_x_item_grp_rec.ATTRIBUTE_CATEGORY := null;
1209: END IF;
1210: IF p_x_item_grp_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
1211: p_x_item_grp_rec.ATTRIBUTE1 := null;
1212: END IF;
1213: IF p_x_item_grp_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN
1214: p_x_item_grp_rec.ATTRIBUTE2 := null;

Line 1213: IF p_x_item_grp_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN

1209: END IF;
1210: IF p_x_item_grp_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
1211: p_x_item_grp_rec.ATTRIBUTE1 := null;
1212: END IF;
1213: IF p_x_item_grp_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN
1214: p_x_item_grp_rec.ATTRIBUTE2 := null;
1215: END IF;
1216: IF p_x_item_grp_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN
1217: p_x_item_grp_rec.ATTRIBUTE3 := null;

Line 1216: IF p_x_item_grp_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN

1212: END IF;
1213: IF p_x_item_grp_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN
1214: p_x_item_grp_rec.ATTRIBUTE2 := null;
1215: END IF;
1216: IF p_x_item_grp_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN
1217: p_x_item_grp_rec.ATTRIBUTE3 := null;
1218: END IF;
1219: IF p_x_item_grp_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN
1220: p_x_item_grp_rec.ATTRIBUTE4 := null;

Line 1219: IF p_x_item_grp_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN

1215: END IF;
1216: IF p_x_item_grp_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN
1217: p_x_item_grp_rec.ATTRIBUTE3 := null;
1218: END IF;
1219: IF p_x_item_grp_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN
1220: p_x_item_grp_rec.ATTRIBUTE4 := null;
1221: END IF;
1222: IF p_x_item_grp_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN
1223: p_x_item_grp_rec.ATTRIBUTE5 := null;

Line 1222: IF p_x_item_grp_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN

1218: END IF;
1219: IF p_x_item_grp_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN
1220: p_x_item_grp_rec.ATTRIBUTE4 := null;
1221: END IF;
1222: IF p_x_item_grp_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN
1223: p_x_item_grp_rec.ATTRIBUTE5 := null;
1224: END IF;
1225: IF p_x_item_grp_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN
1226: p_x_item_grp_rec.ATTRIBUTE6 := null;

Line 1225: IF p_x_item_grp_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN

1221: END IF;
1222: IF p_x_item_grp_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN
1223: p_x_item_grp_rec.ATTRIBUTE5 := null;
1224: END IF;
1225: IF p_x_item_grp_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN
1226: p_x_item_grp_rec.ATTRIBUTE6 := null;
1227: END IF;
1228: IF p_x_item_grp_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN
1229: p_x_item_grp_rec.ATTRIBUTE7 := null;

Line 1228: IF p_x_item_grp_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN

1224: END IF;
1225: IF p_x_item_grp_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN
1226: p_x_item_grp_rec.ATTRIBUTE6 := null;
1227: END IF;
1228: IF p_x_item_grp_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN
1229: p_x_item_grp_rec.ATTRIBUTE7 := null;
1230: END IF;
1231: IF p_x_item_grp_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN
1232: p_x_item_grp_rec.ATTRIBUTE8 := null;

Line 1231: IF p_x_item_grp_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN

1227: END IF;
1228: IF p_x_item_grp_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN
1229: p_x_item_grp_rec.ATTRIBUTE7 := null;
1230: END IF;
1231: IF p_x_item_grp_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN
1232: p_x_item_grp_rec.ATTRIBUTE8 := null;
1233: END IF;
1234: IF p_x_item_grp_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN
1235: p_x_item_grp_rec.ATTRIBUTE9 := null;

Line 1234: IF p_x_item_grp_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN

1230: END IF;
1231: IF p_x_item_grp_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN
1232: p_x_item_grp_rec.ATTRIBUTE8 := null;
1233: END IF;
1234: IF p_x_item_grp_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN
1235: p_x_item_grp_rec.ATTRIBUTE9 := null;
1236: END IF;
1237: IF p_x_item_grp_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN
1238: p_x_item_grp_rec.ATTRIBUTE10 := null;

Line 1237: IF p_x_item_grp_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN

1233: END IF;
1234: IF p_x_item_grp_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN
1235: p_x_item_grp_rec.ATTRIBUTE9 := null;
1236: END IF;
1237: IF p_x_item_grp_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN
1238: p_x_item_grp_rec.ATTRIBUTE10 := null;
1239: END IF;
1240: IF p_x_item_grp_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN
1241: p_x_item_grp_rec.ATTRIBUTE11 := null;

Line 1240: IF p_x_item_grp_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN

1236: END IF;
1237: IF p_x_item_grp_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN
1238: p_x_item_grp_rec.ATTRIBUTE10 := null;
1239: END IF;
1240: IF p_x_item_grp_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN
1241: p_x_item_grp_rec.ATTRIBUTE11 := null;
1242: END IF;
1243: IF p_x_item_grp_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN
1244: p_x_item_grp_rec.ATTRIBUTE12 := null;

Line 1243: IF p_x_item_grp_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN

1239: END IF;
1240: IF p_x_item_grp_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN
1241: p_x_item_grp_rec.ATTRIBUTE11 := null;
1242: END IF;
1243: IF p_x_item_grp_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN
1244: p_x_item_grp_rec.ATTRIBUTE12 := null;
1245: END IF;
1246: IF p_x_item_grp_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN
1247: p_x_item_grp_rec.ATTRIBUTE13 := null;

Line 1246: IF p_x_item_grp_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN

1242: END IF;
1243: IF p_x_item_grp_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN
1244: p_x_item_grp_rec.ATTRIBUTE12 := null;
1245: END IF;
1246: IF p_x_item_grp_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN
1247: p_x_item_grp_rec.ATTRIBUTE13 := null;
1248: END IF;
1249: IF p_x_item_grp_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN
1250: p_x_item_grp_rec.ATTRIBUTE14 := null;

Line 1249: IF p_x_item_grp_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN

1245: END IF;
1246: IF p_x_item_grp_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN
1247: p_x_item_grp_rec.ATTRIBUTE13 := null;
1248: END IF;
1249: IF p_x_item_grp_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN
1250: p_x_item_grp_rec.ATTRIBUTE14 := null;
1251: END IF;
1252: IF p_x_item_grp_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
1253: p_x_item_grp_rec.ATTRIBUTE15 := null;

Line 1252: IF p_x_item_grp_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN

1248: END IF;
1249: IF p_x_item_grp_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN
1250: p_x_item_grp_rec.ATTRIBUTE14 := null;
1251: END IF;
1252: IF p_x_item_grp_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
1253: p_x_item_grp_rec.ATTRIBUTE15 := null;
1254: END IF;
1255:
1256:

Line 1313: IF (l_item_assoc_rec.REVISION = FND_API.G_MISS_CHAR) THEN

1309: l_row_id VARCHAR2(30);
1310: BEGIN
1311:
1312: -- Replace G_MISS values with nulls.
1313: IF (l_item_assoc_rec.REVISION = FND_API.G_MISS_CHAR) THEN
1314: l_item_assoc_rec.REVISION := null;
1315: END IF;
1316: IF (l_item_assoc_rec.QUANTITY = FND_API.G_MISS_NUM) THEN
1317: l_item_assoc_rec.QUANTITY := null;

Line 1316: IF (l_item_assoc_rec.QUANTITY = FND_API.G_MISS_NUM) THEN

1312: -- Replace G_MISS values with nulls.
1313: IF (l_item_assoc_rec.REVISION = FND_API.G_MISS_CHAR) THEN
1314: l_item_assoc_rec.REVISION := null;
1315: END IF;
1316: IF (l_item_assoc_rec.QUANTITY = FND_API.G_MISS_NUM) THEN
1317: l_item_assoc_rec.QUANTITY := null;
1318: l_item_assoc_rec.UOM_CODE := null;
1319: ELSIF (l_item_assoc_rec.QUANTITY IS NULL OR l_item_assoc_rec.QUANTITY = 0) THEN
1320: l_item_assoc_rec.UOM_CODE := null; -- if quantity = 0 then uom must be null.

Line 1322: IF (l_item_assoc_rec.UOM_CODE = FND_API.G_MISS_CHAR) THEN

1318: l_item_assoc_rec.UOM_CODE := null;
1319: ELSIF (l_item_assoc_rec.QUANTITY IS NULL OR l_item_assoc_rec.QUANTITY = 0) THEN
1320: l_item_assoc_rec.UOM_CODE := null; -- if quantity = 0 then uom must be null.
1321: END IF;
1322: IF (l_item_assoc_rec.UOM_CODE = FND_API.G_MISS_CHAR) THEN
1323: l_item_assoc_rec.UOM_CODE := null;
1324: END IF;
1325: IF (l_item_assoc_rec.INTERCHANGE_TYPE_CODE = FND_API.G_MISS_CHAR) THEN
1326: l_item_assoc_rec.INTERCHANGE_TYPE_CODE := null;

Line 1325: IF (l_item_assoc_rec.INTERCHANGE_TYPE_CODE = FND_API.G_MISS_CHAR) THEN

1321: END IF;
1322: IF (l_item_assoc_rec.UOM_CODE = FND_API.G_MISS_CHAR) THEN
1323: l_item_assoc_rec.UOM_CODE := null;
1324: END IF;
1325: IF (l_item_assoc_rec.INTERCHANGE_TYPE_CODE = FND_API.G_MISS_CHAR) THEN
1326: l_item_assoc_rec.INTERCHANGE_TYPE_CODE := null;
1327: END IF;
1328: IF (l_item_assoc_rec.INTERCHANGE_REASON = FND_API.G_MISS_CHAR) THEN
1329: l_item_assoc_rec.INTERCHANGE_REASON := null;

Line 1328: IF (l_item_assoc_rec.INTERCHANGE_REASON = FND_API.G_MISS_CHAR) THEN

1324: END IF;
1325: IF (l_item_assoc_rec.INTERCHANGE_TYPE_CODE = FND_API.G_MISS_CHAR) THEN
1326: l_item_assoc_rec.INTERCHANGE_TYPE_CODE := null;
1327: END IF;
1328: IF (l_item_assoc_rec.INTERCHANGE_REASON = FND_API.G_MISS_CHAR) THEN
1329: l_item_assoc_rec.INTERCHANGE_REASON := null;
1330: END IF;
1331:
1332: IF (l_item_assoc_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR) THEN

Line 1332: IF (l_item_assoc_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR) THEN

1328: IF (l_item_assoc_rec.INTERCHANGE_REASON = FND_API.G_MISS_CHAR) THEN
1329: l_item_assoc_rec.INTERCHANGE_REASON := null;
1330: END IF;
1331:
1332: IF (l_item_assoc_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR) THEN
1333: l_item_assoc_rec.ATTRIBUTE_CATEGORY := null;
1334: END IF;
1335: IF (l_item_assoc_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR) THEN
1336: l_item_assoc_rec.ATTRIBUTE1 := null;

Line 1335: IF (l_item_assoc_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR) THEN

1331:
1332: IF (l_item_assoc_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR) THEN
1333: l_item_assoc_rec.ATTRIBUTE_CATEGORY := null;
1334: END IF;
1335: IF (l_item_assoc_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR) THEN
1336: l_item_assoc_rec.ATTRIBUTE1 := null;
1337: END IF;
1338: IF (l_item_assoc_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR) THEN
1339: l_item_assoc_rec.ATTRIBUTE2 := null;

Line 1338: IF (l_item_assoc_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR) THEN

1334: END IF;
1335: IF (l_item_assoc_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR) THEN
1336: l_item_assoc_rec.ATTRIBUTE1 := null;
1337: END IF;
1338: IF (l_item_assoc_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR) THEN
1339: l_item_assoc_rec.ATTRIBUTE2 := null;
1340: END IF;
1341: IF (l_item_assoc_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR) THEN
1342: l_item_assoc_rec.ATTRIBUTE3 := null;

Line 1341: IF (l_item_assoc_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR) THEN

1337: END IF;
1338: IF (l_item_assoc_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR) THEN
1339: l_item_assoc_rec.ATTRIBUTE2 := null;
1340: END IF;
1341: IF (l_item_assoc_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR) THEN
1342: l_item_assoc_rec.ATTRIBUTE3 := null;
1343: END IF;
1344: IF (l_item_assoc_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR) THEN
1345: l_item_assoc_rec.ATTRIBUTE4 := null;

Line 1344: IF (l_item_assoc_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR) THEN

1340: END IF;
1341: IF (l_item_assoc_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR) THEN
1342: l_item_assoc_rec.ATTRIBUTE3 := null;
1343: END IF;
1344: IF (l_item_assoc_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR) THEN
1345: l_item_assoc_rec.ATTRIBUTE4 := null;
1346: END IF;
1347: IF (l_item_assoc_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR) THEN
1348: l_item_assoc_rec.ATTRIBUTE5 := null;

Line 1347: IF (l_item_assoc_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR) THEN

1343: END IF;
1344: IF (l_item_assoc_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR) THEN
1345: l_item_assoc_rec.ATTRIBUTE4 := null;
1346: END IF;
1347: IF (l_item_assoc_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR) THEN
1348: l_item_assoc_rec.ATTRIBUTE5 := null;
1349: END IF;
1350: IF (l_item_assoc_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR) THEN
1351: l_item_assoc_rec.ATTRIBUTE6 := null;

Line 1350: IF (l_item_assoc_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR) THEN

1346: END IF;
1347: IF (l_item_assoc_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR) THEN
1348: l_item_assoc_rec.ATTRIBUTE5 := null;
1349: END IF;
1350: IF (l_item_assoc_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR) THEN
1351: l_item_assoc_rec.ATTRIBUTE6 := null;
1352: END IF;
1353: IF (l_item_assoc_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR) THEN
1354: l_item_assoc_rec.ATTRIBUTE7 := null;

Line 1353: IF (l_item_assoc_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR) THEN

1349: END IF;
1350: IF (l_item_assoc_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR) THEN
1351: l_item_assoc_rec.ATTRIBUTE6 := null;
1352: END IF;
1353: IF (l_item_assoc_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR) THEN
1354: l_item_assoc_rec.ATTRIBUTE7 := null;
1355: END IF;
1356: IF (l_item_assoc_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR) THEN
1357: l_item_assoc_rec.ATTRIBUTE8 := null;

Line 1356: IF (l_item_assoc_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR) THEN

1352: END IF;
1353: IF (l_item_assoc_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR) THEN
1354: l_item_assoc_rec.ATTRIBUTE7 := null;
1355: END IF;
1356: IF (l_item_assoc_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR) THEN
1357: l_item_assoc_rec.ATTRIBUTE8 := null;
1358: END IF;
1359: IF (l_item_assoc_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR) THEN
1360: l_item_assoc_rec.ATTRIBUTE9 := null;

Line 1359: IF (l_item_assoc_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR) THEN

1355: END IF;
1356: IF (l_item_assoc_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR) THEN
1357: l_item_assoc_rec.ATTRIBUTE8 := null;
1358: END IF;
1359: IF (l_item_assoc_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR) THEN
1360: l_item_assoc_rec.ATTRIBUTE9 := null;
1361: END IF;
1362: IF (l_item_assoc_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR) THEN
1363: l_item_assoc_rec.ATTRIBUTE10 := null;

Line 1362: IF (l_item_assoc_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR) THEN

1358: END IF;
1359: IF (l_item_assoc_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR) THEN
1360: l_item_assoc_rec.ATTRIBUTE9 := null;
1361: END IF;
1362: IF (l_item_assoc_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR) THEN
1363: l_item_assoc_rec.ATTRIBUTE10 := null;
1364: END IF;
1365: IF (l_item_assoc_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR) THEN
1366: l_item_assoc_rec.ATTRIBUTE11 := null;

Line 1365: IF (l_item_assoc_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR) THEN

1361: END IF;
1362: IF (l_item_assoc_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR) THEN
1363: l_item_assoc_rec.ATTRIBUTE10 := null;
1364: END IF;
1365: IF (l_item_assoc_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR) THEN
1366: l_item_assoc_rec.ATTRIBUTE11 := null;
1367: END IF;
1368: IF (l_item_assoc_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR) THEN
1369: l_item_assoc_rec.ATTRIBUTE12 := null;

Line 1368: IF (l_item_assoc_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR) THEN

1364: END IF;
1365: IF (l_item_assoc_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR) THEN
1366: l_item_assoc_rec.ATTRIBUTE11 := null;
1367: END IF;
1368: IF (l_item_assoc_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR) THEN
1369: l_item_assoc_rec.ATTRIBUTE12 := null;
1370: END IF;
1371: IF (l_item_assoc_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR) THEN
1372: l_item_assoc_rec.ATTRIBUTE13 := null;

Line 1371: IF (l_item_assoc_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR) THEN

1367: END IF;
1368: IF (l_item_assoc_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR) THEN
1369: l_item_assoc_rec.ATTRIBUTE12 := null;
1370: END IF;
1371: IF (l_item_assoc_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR) THEN
1372: l_item_assoc_rec.ATTRIBUTE13 := null;
1373: END IF;
1374: IF (l_item_assoc_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR) THEN
1375: l_item_assoc_rec.ATTRIBUTE14 := null;

Line 1374: IF (l_item_assoc_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR) THEN

1370: END IF;
1371: IF (l_item_assoc_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR) THEN
1372: l_item_assoc_rec.ATTRIBUTE13 := null;
1373: END IF;
1374: IF (l_item_assoc_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR) THEN
1375: l_item_assoc_rec.ATTRIBUTE14 := null;
1376: END IF;
1377: IF (l_item_assoc_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR) THEN
1378: l_item_assoc_rec.ATTRIBUTE15 := null;

Line 1377: IF (l_item_assoc_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR) THEN

1373: END IF;
1374: IF (l_item_assoc_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR) THEN
1375: l_item_assoc_rec.ATTRIBUTE14 := null;
1376: END IF;
1377: IF (l_item_assoc_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR) THEN
1378: l_item_assoc_rec.ATTRIBUTE15 := null;
1379: END IF;
1380: --Gets the sequence Number
1381: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO

Line 1490: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1486: CLOSE Item_assoc_csr;
1487: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
1488: FND_MSG_PUB.ADD;
1489: --dbms_output.put_line('Item Assoc does not exist');
1490: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1491: END IF;
1492:
1493: -- Check Object version number.
1494: IF (l_old_item_assoc_rec.object_version_number <> l_item_assoc_rec.object_version_number) THEN

Line 1498: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1494: IF (l_old_item_assoc_rec.object_version_number <> l_item_assoc_rec.object_version_number) THEN
1495: CLOSE Item_assoc_csr;
1496: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1497: FND_MSG_PUB.ADD;
1498: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1499: END IF;
1500:
1501: -- Check for changed columns.
1502:

Line 1505: ELSIF (l_item_assoc_rec.REVISION = FND_API.G_MISS_CHAR) THEN

1501: -- Check for changed columns.
1502:
1503: IF (l_item_assoc_rec.REVISION is NULL) THEN
1504: l_item_assoc_rec.REVISION := l_old_item_assoc_rec.REVISION;
1505: ELSIF (l_item_assoc_rec.REVISION = FND_API.G_MISS_CHAR) THEN
1506: l_item_assoc_rec.REVISION := NULL;
1507: END IF;
1508:
1509: IF (l_item_assoc_rec.PRIORITY is NULL) THEN

Line 1511: ELSIF (l_item_assoc_rec.PRIORITY = FND_API.G_MISS_NUM) THEN

1507: END IF;
1508:
1509: IF (l_item_assoc_rec.PRIORITY is NULL) THEN
1510: l_item_assoc_rec.PRIORITY := l_old_item_assoc_rec.PRIORITY;
1511: ELSIF (l_item_assoc_rec.PRIORITY = FND_API.G_MISS_NUM) THEN
1512: l_item_assoc_rec.PRIORITY := NULL;
1513: END IF;
1514:
1515: IF (l_item_assoc_rec.QUANTITY is NULL) THEN

Line 1517: ELSIF (l_item_assoc_rec.QUANTITY = FND_API.G_MISS_NUM) THEN

1513: END IF;
1514:
1515: IF (l_item_assoc_rec.QUANTITY is NULL) THEN
1516: l_item_assoc_rec.QUANTITY := l_old_item_assoc_rec.QUANTITY;
1517: ELSIF (l_item_assoc_rec.QUANTITY = FND_API.G_MISS_NUM) THEN
1518: l_item_assoc_rec.QUANTITY := NULL;
1519: ELSIF (l_item_assoc_rec.QUANTITY = 0) THEN
1520: l_item_assoc_rec.UOM_CODE := null;
1521: END IF;

Line 1525: ELSIF (l_item_assoc_rec.UOM_CODE = FND_API.G_MISS_CHAR) THEN

1521: END IF;
1522:
1523: IF (l_item_assoc_rec.UOM_CODE is NULL) THEN
1524: l_item_assoc_rec.UOM_CODE := l_old_item_assoc_rec.UOM_CODE;
1525: ELSIF (l_item_assoc_rec.UOM_CODE = FND_API.G_MISS_CHAR) THEN
1526: l_item_assoc_rec.UOM_CODE := NULL;
1527: END IF;
1528:
1529: IF (l_item_assoc_rec.INTERCHANGE_TYPE_CODE is NULL) THEN

Line 1531: ELSIF (l_item_assoc_rec.INTERCHANGE_TYPE_CODE = FND_API.G_MISS_CHAR) THEN

1527: END IF;
1528:
1529: IF (l_item_assoc_rec.INTERCHANGE_TYPE_CODE is NULL) THEN
1530: l_item_assoc_rec.INTERCHANGE_TYPE_CODE := l_old_item_assoc_rec.INTERCHANGE_TYPE_CODE;
1531: ELSIF (l_item_assoc_rec.INTERCHANGE_TYPE_CODE = FND_API.G_MISS_CHAR) THEN
1532: l_item_assoc_rec.INTERCHANGE_TYPE_CODE := NULL;
1533: END IF;
1534:
1535: IF (l_item_assoc_rec.INTERCHANGE_REASON is NULL) THEN

Line 1537: ELSIF (l_item_assoc_rec.INTERCHANGE_REASON = FND_API.G_MISS_CHAR) THEN

1533: END IF;
1534:
1535: IF (l_item_assoc_rec.INTERCHANGE_REASON is NULL) THEN
1536: l_item_assoc_rec.INTERCHANGE_REASON := l_old_item_assoc_rec.INTERCHANGE_REASON;
1537: ELSIF (l_item_assoc_rec.INTERCHANGE_REASON = FND_API.G_MISS_CHAR) THEN
1538: l_item_assoc_rec.INTERCHANGE_REASON := NULL;
1539: END IF;
1540:
1541:

Line 1544: ELSIF (l_item_assoc_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR) THEN

1540:
1541:
1542: IF (l_item_assoc_rec.ATTRIBUTE_CATEGORY is NULL) THEN
1543: l_item_assoc_rec.ATTRIBUTE_CATEGORY := l_old_item_assoc_rec.ATTRIBUTE_CATEGORY;
1544: ELSIF (l_item_assoc_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR) THEN
1545: l_item_assoc_rec.ATTRIBUTE_CATEGORY := NULL;
1546: END IF;
1547:
1548: IF (l_item_assoc_rec.ATTRIBUTE1 is NULL) THEN

Line 1550: ELSIF (l_item_assoc_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR) THEN

1546: END IF;
1547:
1548: IF (l_item_assoc_rec.ATTRIBUTE1 is NULL) THEN
1549: l_item_assoc_rec.ATTRIBUTE1 := l_old_item_assoc_rec.ATTRIBUTE1;
1550: ELSIF (l_item_assoc_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR) THEN
1551: l_item_assoc_rec.ATTRIBUTE1 := NULL;
1552: END IF;
1553:
1554: IF (l_item_assoc_rec.ATTRIBUTE2 is NULL) THEN

Line 1556: ELSIF (l_item_assoc_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR) THEN

1552: END IF;
1553:
1554: IF (l_item_assoc_rec.ATTRIBUTE2 is NULL) THEN
1555: l_item_assoc_rec.ATTRIBUTE2 := l_old_item_assoc_rec.ATTRIBUTE2;
1556: ELSIF (l_item_assoc_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR) THEN
1557: l_item_assoc_rec.ATTRIBUTE2 := NULL;
1558: END IF;
1559:
1560: IF (l_item_assoc_rec.ATTRIBUTE3 is NULL) THEN

Line 1562: ELSIF (l_item_assoc_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR) THEN

1558: END IF;
1559:
1560: IF (l_item_assoc_rec.ATTRIBUTE3 is NULL) THEN
1561: l_item_assoc_rec.ATTRIBUTE3 := l_old_item_assoc_rec.ATTRIBUTE3;
1562: ELSIF (l_item_assoc_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR) THEN
1563: l_item_assoc_rec.ATTRIBUTE3 := NULL;
1564: END IF;
1565:
1566: IF (l_item_assoc_rec.ATTRIBUTE4 is NULL) THEN

Line 1568: ELSIF (l_item_assoc_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR) THEN

1564: END IF;
1565:
1566: IF (l_item_assoc_rec.ATTRIBUTE4 is NULL) THEN
1567: l_item_assoc_rec.ATTRIBUTE4 := l_old_item_assoc_rec.ATTRIBUTE4;
1568: ELSIF (l_item_assoc_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR) THEN
1569: l_item_assoc_rec.ATTRIBUTE4 := NULL;
1570: END IF;
1571:
1572: IF (l_item_assoc_rec.ATTRIBUTE6 is NULL) THEN

Line 1574: ELSIF (l_item_assoc_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR) THEN

1570: END IF;
1571:
1572: IF (l_item_assoc_rec.ATTRIBUTE6 is NULL) THEN
1573: l_item_assoc_rec.ATTRIBUTE6 := l_old_item_assoc_rec.ATTRIBUTE6;
1574: ELSIF (l_item_assoc_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR) THEN
1575: l_item_assoc_rec.ATTRIBUTE6 := NULL;
1576: END IF;
1577:
1578: IF (l_item_assoc_rec.ATTRIBUTE7 is NULL) THEN

Line 1580: ELSIF (l_item_assoc_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR) THEN

1576: END IF;
1577:
1578: IF (l_item_assoc_rec.ATTRIBUTE7 is NULL) THEN
1579: l_item_assoc_rec.ATTRIBUTE7 := l_old_item_assoc_rec.ATTRIBUTE7;
1580: ELSIF (l_item_assoc_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR) THEN
1581: l_item_assoc_rec.ATTRIBUTE7 := NULL;
1582: END IF;
1583:
1584: IF (l_item_assoc_rec.ATTRIBUTE8 is NULL) THEN

Line 1586: ELSIF (l_item_assoc_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR) THEN

1582: END IF;
1583:
1584: IF (l_item_assoc_rec.ATTRIBUTE8 is NULL) THEN
1585: l_item_assoc_rec.ATTRIBUTE8 := l_old_item_assoc_rec.ATTRIBUTE8;
1586: ELSIF (l_item_assoc_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR) THEN
1587: l_item_assoc_rec.ATTRIBUTE8 := NULL;
1588: END IF;
1589:
1590: IF (l_item_assoc_rec.ATTRIBUTE9 is NULL) THEN

Line 1592: ELSIF (l_item_assoc_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR) THEN

1588: END IF;
1589:
1590: IF (l_item_assoc_rec.ATTRIBUTE9 is NULL) THEN
1591: l_item_assoc_rec.ATTRIBUTE9 := l_old_item_assoc_rec.ATTRIBUTE9;
1592: ELSIF (l_item_assoc_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR) THEN
1593: l_item_assoc_rec.ATTRIBUTE9 := NULL;
1594: END IF;
1595:
1596: IF (l_item_assoc_rec.ATTRIBUTE10 is NULL) THEN

Line 1598: ELSIF (l_item_assoc_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR) THEN

1594: END IF;
1595:
1596: IF (l_item_assoc_rec.ATTRIBUTE10 is NULL) THEN
1597: l_item_assoc_rec.ATTRIBUTE10 := l_old_item_assoc_rec.ATTRIBUTE10;
1598: ELSIF (l_item_assoc_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR) THEN
1599: l_item_assoc_rec.ATTRIBUTE10 := NULL;
1600: END IF;
1601:
1602: IF (l_item_assoc_rec.ATTRIBUTE11 is NULL) THEN

Line 1604: ELSIF (l_item_assoc_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR) THEN

1600: END IF;
1601:
1602: IF (l_item_assoc_rec.ATTRIBUTE11 is NULL) THEN
1603: l_item_assoc_rec.ATTRIBUTE11 := l_old_item_assoc_rec.ATTRIBUTE11;
1604: ELSIF (l_item_assoc_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR) THEN
1605: l_item_assoc_rec.ATTRIBUTE11 := NULL;
1606: END IF;
1607:
1608: IF (l_item_assoc_rec.ATTRIBUTE12 is NULL) THEN

Line 1610: ELSIF (l_item_assoc_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR) THEN

1606: END IF;
1607:
1608: IF (l_item_assoc_rec.ATTRIBUTE12 is NULL) THEN
1609: l_item_assoc_rec.ATTRIBUTE12 := l_old_item_assoc_rec.ATTRIBUTE12;
1610: ELSIF (l_item_assoc_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR) THEN
1611: l_item_assoc_rec.ATTRIBUTE12 := NULL;
1612: END IF;
1613:
1614: IF (l_item_assoc_rec.ATTRIBUTE13 is NULL) THEN

Line 1616: ELSIF (l_item_assoc_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR) THEN

1612: END IF;
1613:
1614: IF (l_item_assoc_rec.ATTRIBUTE13 is NULL) THEN
1615: l_item_assoc_rec.ATTRIBUTE13 := l_old_item_assoc_rec.ATTRIBUTE13;
1616: ELSIF (l_item_assoc_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR) THEN
1617: l_item_assoc_rec.ATTRIBUTE13 := NULL;
1618: END IF;
1619:
1620: IF (l_item_assoc_rec.ATTRIBUTE14 is NULL) THEN

Line 1622: ELSIF (l_item_assoc_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR) THEN

1618: END IF;
1619:
1620: IF (l_item_assoc_rec.ATTRIBUTE14 is NULL) THEN
1621: l_item_assoc_rec.ATTRIBUTE14 := l_old_item_assoc_rec.ATTRIBUTE14;
1622: ELSIF (l_item_assoc_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR) THEN
1623: l_item_assoc_rec.ATTRIBUTE14 := NULL;
1624: END IF;
1625:
1626: IF (l_item_assoc_rec.ATTRIBUTE15 is NULL) THEN

Line 1628: ELSIF (l_item_assoc_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR) THEN

1624: END IF;
1625:
1626: IF (l_item_assoc_rec.ATTRIBUTE15 is NULL) THEN
1627: l_item_assoc_rec.ATTRIBUTE15 := l_old_item_assoc_rec.ATTRIBUTE15;
1628: ELSIF (l_item_assoc_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR) THEN
1629: l_item_assoc_rec.ATTRIBUTE15 := NULL;
1630: END IF;
1631:
1632: /*

Line 1635: ELSIF (l_item_assoc_rec.SOURCE_LANG = FND_API.G_MISS_CHAR) THEN

1631:
1632: /*
1633: IF (l_item_assoc_rec.SOURCE_LANG is NULL) THEN
1634: l_item_assoc_rec.SOURCE_LANG := l_old_item_assoc_rec.SOURCE_LANG;
1635: ELSIF (l_item_assoc_rec.SOURCE_LANG = FND_API.G_MISS_CHAR) THEN
1636: l_item_assoc_rec.SOURCE_LANG := NULL;
1637: END IF;
1638: */
1639:

Line 1700: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1696: IF (Item_assoc_csr%NOTFOUND) THEN
1697: CLOSE Item_assoc_csr;
1698: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
1699: FND_MSG_PUB.ADD;
1700: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702:
1703: -- Check Object version number.
1704: IF (l_object_version_number <> p_item_assoc_rec.object_version_number) THEN

Line 1708: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1704: IF (l_object_version_number <> p_item_assoc_rec.object_version_number) THEN
1705: CLOSE Item_assoc_csr;
1706: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1707: FND_MSG_PUB.ADD;
1708: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1709: END IF;
1710:
1711: -- Delete record.
1712: DELETE ahl_item_associations_b

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

1731: -- Parameters :
1732: -- End of Comments --
1733:
1734: PROCEDURE Create_Item_group (p_api_version IN NUMBER,
1735: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1736: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1737: x_return_status OUT NOCOPY VARCHAR2,
1738: x_msg_count OUT NOCOPY NUMBER,
1739: x_msg_data OUT NOCOPY VARCHAR2,

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

1732: -- End of Comments --
1733:
1734: PROCEDURE Create_Item_group (p_api_version IN NUMBER,
1735: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1736: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1737: x_return_status OUT NOCOPY VARCHAR2,
1738: x_msg_count OUT NOCOPY NUMBER,
1739: x_msg_data OUT NOCOPY VARCHAR2,
1740: p_x_item_group_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,

Line 1762: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

1758: SAVEPOINT Create_Item_group_Pvt;
1759:
1760:
1761: -- Standard call to check for call compatibility
1762: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1763: G_PKG_NAME) THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END IF;
1766:

Line 1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1760:
1761: -- Standard call to check for call compatibility
1762: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1763: G_PKG_NAME) THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END IF;
1766:
1767: -- Initialize message list if p_init_msg_list is set to TRUE
1768: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1768: IF FND_API.To_Boolean(p_init_msg_list) THEN

1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END IF;
1766:
1767: -- Initialize message list if p_init_msg_list is set to TRUE
1768: IF FND_API.To_Boolean(p_init_msg_list) THEN
1769: FND_MSG_PUB.Initialize;
1770: END IF;
1771:
1772: -- Initialize API return status to success

Line 1773: x_return_status := FND_API.G_RET_STS_SUCCESS;

1769: FND_MSG_PUB.Initialize;
1770: END IF;
1771:
1772: -- Initialize API return status to success
1773: x_return_status := FND_API.G_RET_STS_SUCCESS;
1774:
1775: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1776: THEN
1777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1823: RAISE FND_API.G_EXC_ERROR;

1819:
1820: -- Check Error Message stack.
1821: x_msg_count := FND_MSG_PUB.count_msg;
1822: IF x_msg_count > 0 THEN
1823: RAISE FND_API.G_EXC_ERROR;
1824: END IF;
1825:
1826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1827: THEN

Line 1878: p_encoded => fnd_api.g_false);

1874: -- Standard call to get message count and if count is 1, get message info
1875: FND_MSG_PUB.Count_And_Get
1876: ( p_count => x_msg_count,
1877: p_data => x_msg_data,
1878: p_encoded => fnd_api.g_false);
1879:
1880: EXCEPTION
1881: WHEN FND_API.G_EXC_ERROR THEN
1882: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1881: WHEN FND_API.G_EXC_ERROR THEN

1877: p_data => x_msg_data,
1878: p_encoded => fnd_api.g_false);
1879:
1880: EXCEPTION
1881: WHEN FND_API.G_EXC_ERROR THEN
1882: x_return_status := FND_API.G_RET_STS_ERROR;
1883: Rollback to Create_Item_group_pvt;
1884: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1885: p_data => x_msg_data,

Line 1882: x_return_status := FND_API.G_RET_STS_ERROR;

1878: p_encoded => fnd_api.g_false);
1879:
1880: EXCEPTION
1881: WHEN FND_API.G_EXC_ERROR THEN
1882: x_return_status := FND_API.G_RET_STS_ERROR;
1883: Rollback to Create_Item_group_pvt;
1884: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1885: p_data => x_msg_data,
1886: p_encoded => fnd_api.g_false);

Line 1886: p_encoded => fnd_api.g_false);

1882: x_return_status := FND_API.G_RET_STS_ERROR;
1883: Rollback to Create_Item_group_pvt;
1884: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1885: p_data => x_msg_data,
1886: p_encoded => fnd_api.g_false);
1887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1888: THEN
1889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1890: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Error in create_item_group private');

Line 1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1891: END IF;
1892:
1893:
1894:
1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1897: Rollback to Create_Item_group_pvt;
1898: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1899: p_data => x_msg_data,

Line 1896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1892:
1893:
1894:
1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1897: Rollback to Create_Item_group_pvt;
1898: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1899: p_data => x_msg_data,
1900: p_encoded => fnd_api.g_false);

Line 1900: p_encoded => fnd_api.g_false);

1896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1897: Rollback to Create_Item_group_pvt;
1898: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1899: p_data => x_msg_data,
1900: p_encoded => fnd_api.g_false);
1901: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
1902: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1903: THEN
1904: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1906: END IF;
1907:
1908:
1909: WHEN OTHERS THEN
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1911: Rollback to Create_Item_group_pvt;
1912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1913: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1914: p_procedure_name => 'Create_Item_group',

Line 1919: p_encoded => fnd_api.g_false);

1915: p_error_text => SQLERRM);
1916: END IF;
1917: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1918: p_data => x_msg_data,
1919: p_encoded => fnd_api.g_false);
1920: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
1921:
1922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1923: THEN

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

1938: -- Parameters :
1939: -- Standard IN Parameters :
1940:
1941: PROCEDURE Modify_Item_group (p_api_version IN NUMBER,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: x_return_status OUT NOCOPY VARCHAR2,
1945: x_msg_count OUT NOCOPY NUMBER,
1946: x_msg_data OUT NOCOPY VARCHAR2,

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

1939: -- Standard IN Parameters :
1940:
1941: PROCEDURE Modify_Item_group (p_api_version IN NUMBER,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: x_return_status OUT NOCOPY VARCHAR2,
1945: x_msg_count OUT NOCOPY NUMBER,
1946: x_msg_data OUT NOCOPY VARCHAR2,
1947: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,

Line 2021: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

2017: -- Standard start of API savepoint
2018: SAVEPOINT Modify_Item_group_Pvt;
2019:
2020: -- Standard call to check for call compatibility
2021: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2022: G_PKG_NAME) THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:

Line 2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2019:
2020: -- Standard call to check for call compatibility
2021: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2022: G_PKG_NAME) THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:
2026: -- Initialize message list if p_init_msg_list is set to TRUE
2027: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2027: IF FND_API.To_Boolean(p_init_msg_list) THEN

2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:
2026: -- Initialize message list if p_init_msg_list is set to TRUE
2027: IF FND_API.To_Boolean(p_init_msg_list) THEN
2028: FND_MSG_PUB.Initialize;
2029: END IF;
2030:
2031: -- Initialize API return status to success

Line 2032: x_return_status := FND_API.G_RET_STS_SUCCESS;

2028: FND_MSG_PUB.Initialize;
2029: END IF;
2030:
2031: -- Initialize API return status to success
2032: x_return_status := FND_API.G_RET_STS_SUCCESS;
2033:
2034: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2036: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Begin of Modify_Item_group');

Line 2047: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2043: CLOSE Item_group_csr;
2044: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_NOT_EXISTS');
2045: FND_MSG_PUB.ADD;
2046: --dbms_output.put_line('Item Group does not exist');
2047: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2048: END IF;
2049:
2050: -- SATHAPLI::Enigma Phase II integration, 01-Mar-2010, bypass the following check for Enigma sourced item groups
2051: -- Check Object version number.

Line 2058: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2054: l_old_item_group_rec.object_version_number <> NVL(p_item_group_rec.object_version_number,0)) THEN
2055: CLOSE Item_group_csr;
2056: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2057: FND_MSG_PUB.ADD;
2058: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2059: END IF;
2060:
2061: -- Check name
2062: -- TAMAL -- IG Amendments --

Line 2070: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2066: x_msg_count := FND_MSG_PUB.count_msg;
2067: IF x_msg_count > 0
2068: THEN
2069: CLOSE Item_group_csr;
2070: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2071: END IF;
2072: l_old_item_group_rec.name := l_item_group_rec.name;
2073: -- TAMAL -- IG Amendments --
2074: ELSIF (l_old_item_group_rec.name <> p_item_group_rec.name )

Line 2079: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2075: THEN
2076: CLOSE Item_group_csr;
2077: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');
2078: FND_MSG_PUB.ADD;
2079: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2080: END IF;
2081:
2082: -- SATHAPLI::Enigma Phase II integration, 01-Mar-2010, bypass the following check for Enigma sourced item groups
2083: -- IF l_old_item_group_rec.status_code in ('COMPLETE','APPROVAL_PENDING')

Line 2091: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2087: CLOSE Item_group_csr;
2088: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_NOUPDATE');
2089: FND_MESSAGE.Set_Token('STATUS',p_item_group_rec.status_code);
2090: FND_MSG_PUB.ADD;
2091: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2092: --dbms_output.put_line('Item Group cannot be updated if status is Complete or Approval Rejected');
2093: END IF;
2094:
2095: IF (p_item_group_rec.status_code <> FND_API.G_MISS_CHAR) THEN

Line 2095: IF (p_item_group_rec.status_code <> FND_API.G_MISS_CHAR) THEN

2091: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2092: --dbms_output.put_line('Item Group cannot be updated if status is Complete or Approval Rejected');
2093: END IF;
2094:
2095: IF (p_item_group_rec.status_code <> FND_API.G_MISS_CHAR) THEN
2096:
2097: IF (p_item_group_rec.status_code <> l_old_item_group_rec.status_code)
2098: THEN
2099: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_STAT_NOUPDATE');

Line 2101: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2097: IF (p_item_group_rec.status_code <> l_old_item_group_rec.status_code)
2098: THEN
2099: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_STAT_NOUPDATE');
2100: FND_MSG_PUB.ADD;
2101: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2102: --dbms_output.put_line('Item Group Status cannot be updated');
2103: END IF;
2104: END IF;
2105:

Line 2106: IF (p_item_group_rec.type_code <> FND_API.G_MISS_CHAR) THEN

2102: --dbms_output.put_line('Item Group Status cannot be updated');
2103: END IF;
2104: END IF;
2105:
2106: IF (p_item_group_rec.type_code <> FND_API.G_MISS_CHAR) THEN
2107: IF (p_item_group_rec.type_code <> l_old_item_group_rec.type_code)
2108: THEN
2109: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');
2110: FND_MSG_PUB.ADD;

Line 2111: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2107: IF (p_item_group_rec.type_code <> l_old_item_group_rec.type_code)
2108: THEN
2109: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');
2110: FND_MSG_PUB.ADD;
2111: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2112: --dbms_output.put_line('Item Group Type cannot be updated');
2113: END IF;
2114:
2115: END IF;

Line 2135: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2131: FND_MESSAGE.Set_Token('ITEM_GRP',p_item_group_rec.item_group_id);
2132: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_id);
2133: FND_MSG_PUB.ADD;
2134: --dbms_output.put_line('Item Association record does not match Item Group');
2135: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2136: END IF;
2137:
2138: Validate_Item_Assoc(p_name => p_item_group_rec.name,
2139: p_type_code => p_item_group_rec.type_code,

Line 2158: RAISE FND_API.G_EXC_ERROR;

2154:
2155: -- Check Error Message stack.
2156: x_msg_count := FND_MSG_PUB.count_msg;
2157: IF x_msg_count > 0 THEN
2158: RAISE FND_API.G_EXC_ERROR;
2159: END IF;
2160:
2161: IF (l_item_group_rec.operation_flag = 'M') THEN
2162:

Line 2171: ELSIF (l_item_group_rec.DESCRIPTION = FND_API.G_MISS_CHAR) THEN

2167: END IF;
2168:
2169: IF (l_item_group_rec.DESCRIPTION is NULL) THEN
2170: l_item_group_rec.DESCRIPTION := l_old_item_group_rec.DESCRIPTION;
2171: ELSIF (l_item_group_rec.DESCRIPTION = FND_API.G_MISS_CHAR) THEN
2172: l_item_group_rec.DESCRIPTION := NULL;
2173: END IF;
2174:
2175: IF (l_item_group_rec.ATTRIBUTE_CATEGORY is NULL) THEN

Line 2177: ELSIF (l_item_group_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR) THEN

2173: END IF;
2174:
2175: IF (l_item_group_rec.ATTRIBUTE_CATEGORY is NULL) THEN
2176: l_item_group_rec.ATTRIBUTE_CATEGORY := l_old_item_group_rec.ATTRIBUTE_CATEGORY;
2177: ELSIF (l_item_group_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR) THEN
2178: l_item_group_rec.ATTRIBUTE_CATEGORY := NULL;
2179: END IF;
2180:
2181: IF (l_item_group_rec.ATTRIBUTE1 is NULL) THEN

Line 2183: ELSIF (l_item_group_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR) THEN

2179: END IF;
2180:
2181: IF (l_item_group_rec.ATTRIBUTE1 is NULL) THEN
2182: l_item_group_rec.ATTRIBUTE1 := l_old_item_group_rec.ATTRIBUTE1;
2183: ELSIF (l_item_group_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR) THEN
2184: l_item_group_rec.ATTRIBUTE1 := NULL;
2185: END IF;
2186:
2187: IF (l_item_group_rec.ATTRIBUTE2 is NULL) THEN

Line 2189: ELSIF (l_item_group_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR) THEN

2185: END IF;
2186:
2187: IF (l_item_group_rec.ATTRIBUTE2 is NULL) THEN
2188: l_item_group_rec.ATTRIBUTE2 := l_old_item_group_rec.ATTRIBUTE2;
2189: ELSIF (l_item_group_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR) THEN
2190: l_item_group_rec.ATTRIBUTE2 := NULL;
2191: END IF;
2192:
2193: IF (l_item_group_rec.ATTRIBUTE3 is NULL) THEN

Line 2195: ELSIF (l_item_group_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR) THEN

2191: END IF;
2192:
2193: IF (l_item_group_rec.ATTRIBUTE3 is NULL) THEN
2194: l_item_group_rec.ATTRIBUTE3 := l_old_item_group_rec.ATTRIBUTE3;
2195: ELSIF (l_item_group_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR) THEN
2196: l_item_group_rec.ATTRIBUTE3 := NULL;
2197: END IF;
2198:
2199: IF (l_item_group_rec.ATTRIBUTE4 is NULL) THEN

Line 2201: ELSIF (l_item_group_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR) THEN

2197: END IF;
2198:
2199: IF (l_item_group_rec.ATTRIBUTE4 is NULL) THEN
2200: l_item_group_rec.ATTRIBUTE4 := l_old_item_group_rec.ATTRIBUTE4;
2201: ELSIF (l_item_group_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR) THEN
2202: l_item_group_rec.ATTRIBUTE4 := NULL;
2203: END IF;
2204:
2205: IF (l_item_group_rec.ATTRIBUTE6 is NULL) THEN

Line 2207: ELSIF (l_item_group_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR) THEN

2203: END IF;
2204:
2205: IF (l_item_group_rec.ATTRIBUTE6 is NULL) THEN
2206: l_item_group_rec.ATTRIBUTE6 := l_old_item_group_rec.ATTRIBUTE6;
2207: ELSIF (l_item_group_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR) THEN
2208: l_item_group_rec.ATTRIBUTE6 := NULL;
2209: END IF;
2210:
2211: IF (l_item_group_rec.ATTRIBUTE7 is NULL) THEN

Line 2213: ELSIF (l_item_group_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR) THEN

2209: END IF;
2210:
2211: IF (l_item_group_rec.ATTRIBUTE7 is NULL) THEN
2212: l_item_group_rec.ATTRIBUTE7 := l_old_item_group_rec.ATTRIBUTE7;
2213: ELSIF (l_item_group_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR) THEN
2214: l_item_group_rec.ATTRIBUTE7 := NULL;
2215: END IF;
2216:
2217: IF (l_item_group_rec.ATTRIBUTE8 is NULL) THEN

Line 2219: ELSIF (l_item_group_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR) THEN

2215: END IF;
2216:
2217: IF (l_item_group_rec.ATTRIBUTE8 is NULL) THEN
2218: l_item_group_rec.ATTRIBUTE8 := l_old_item_group_rec.ATTRIBUTE8;
2219: ELSIF (l_item_group_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR) THEN
2220: l_item_group_rec.ATTRIBUTE8 := NULL;
2221: END IF;
2222:
2223: IF (l_item_group_rec.ATTRIBUTE9 is NULL) THEN

Line 2225: ELSIF (l_item_group_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR) THEN

2221: END IF;
2222:
2223: IF (l_item_group_rec.ATTRIBUTE9 is NULL) THEN
2224: l_item_group_rec.ATTRIBUTE9 := l_old_item_group_rec.ATTRIBUTE9;
2225: ELSIF (l_item_group_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR) THEN
2226: l_item_group_rec.ATTRIBUTE9 := NULL;
2227: END IF;
2228:
2229: IF (l_item_group_rec.ATTRIBUTE10 is NULL) THEN

Line 2231: ELSIF (l_item_group_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR) THEN

2227: END IF;
2228:
2229: IF (l_item_group_rec.ATTRIBUTE10 is NULL) THEN
2230: l_item_group_rec.ATTRIBUTE10 := l_old_item_group_rec.ATTRIBUTE10;
2231: ELSIF (l_item_group_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR) THEN
2232: l_item_group_rec.ATTRIBUTE10 := NULL;
2233: END IF;
2234:
2235: IF (l_item_group_rec.ATTRIBUTE11 is NULL) THEN

Line 2237: ELSIF (l_item_group_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR) THEN

2233: END IF;
2234:
2235: IF (l_item_group_rec.ATTRIBUTE11 is NULL) THEN
2236: l_item_group_rec.ATTRIBUTE11 := l_old_item_group_rec.ATTRIBUTE11;
2237: ELSIF (l_item_group_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR) THEN
2238: l_item_group_rec.ATTRIBUTE11 := NULL;
2239: END IF;
2240:
2241: IF (l_item_group_rec.ATTRIBUTE12 is NULL) THEN

Line 2243: ELSIF (l_item_group_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR) THEN

2239: END IF;
2240:
2241: IF (l_item_group_rec.ATTRIBUTE12 is NULL) THEN
2242: l_item_group_rec.ATTRIBUTE12 := l_old_item_group_rec.ATTRIBUTE12;
2243: ELSIF (l_item_group_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR) THEN
2244: l_item_group_rec.ATTRIBUTE12 := NULL;
2245: END IF;
2246:
2247: IF (l_item_group_rec.ATTRIBUTE13 is NULL) THEN

Line 2249: ELSIF (l_item_group_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR) THEN

2245: END IF;
2246:
2247: IF (l_item_group_rec.ATTRIBUTE13 is NULL) THEN
2248: l_item_group_rec.ATTRIBUTE13 := l_old_item_group_rec.ATTRIBUTE13;
2249: ELSIF (l_item_group_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR) THEN
2250: l_item_group_rec.ATTRIBUTE13 := NULL;
2251: END IF;
2252:
2253: IF (l_item_group_rec.ATTRIBUTE14 is NULL) THEN

Line 2255: ELSIF (l_item_group_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR) THEN

2251: END IF;
2252:
2253: IF (l_item_group_rec.ATTRIBUTE14 is NULL) THEN
2254: l_item_group_rec.ATTRIBUTE14 := l_old_item_group_rec.ATTRIBUTE14;
2255: ELSIF (l_item_group_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR) THEN
2256: l_item_group_rec.ATTRIBUTE14 := NULL;
2257: END IF;
2258:
2259: IF (l_item_group_rec.ATTRIBUTE15 is NULL) THEN

Line 2261: ELSIF (l_item_group_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR) THEN

2257: END IF;
2258:
2259: IF (l_item_group_rec.ATTRIBUTE15 is NULL) THEN
2260: l_item_group_rec.ATTRIBUTE15 := l_old_item_group_rec.ATTRIBUTE15;
2261: ELSIF (l_item_group_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR) THEN
2262: l_item_group_rec.ATTRIBUTE15 := NULL;
2263: END IF;
2264:
2265: /*

Line 2268: ELSIF (l_item_group_rec.SOURCE_LANG = FND_API.G_MISS_CHAR) THEN

2264:
2265: /*
2266: IF (l_item_group_rec.SOURCE_LANG is NULL) THEN
2267: l_item_group_rec.SOURCE_LANG := l_old_item_group_rec.SOURCE_LANG;
2268: ELSIF (l_item_group_rec.SOURCE_LANG = FND_API.G_MISS_CHAR) THEN
2269: l_item_group_rec.SOURCE_LANG := NULL;
2270: END IF;
2271: */
2272:

Line 2352: p_init_msg_list => FND_API.G_FALSE,

2348:
2349: AHL_UTIL_UC_PKG.Check_Invalidate_Instance
2350: (
2351: p_api_version => 1.0,
2352: p_init_msg_list => FND_API.G_FALSE,
2353: p_instance_tbl => l_invalid_item_instance_tbl,
2354: p_operator => 'D',
2355: x_return_status => x_return_status,
2356: x_msg_count => x_msg_count,

Line 2361: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2357: x_msg_data => x_msg_data
2358: );
2359: END IF;
2360:
2361: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: END IF;

Line 2362: RAISE FND_API.G_EXC_ERROR;

2358: );
2359: END IF;
2360:
2361: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: END IF;
2366:

Line 2363: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2359: END IF;
2360:
2361: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: END IF;
2366:
2367: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL

Line 2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2360:
2361: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: END IF;
2366:
2367: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL
2368:

Line 2417: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2413: x_msg_data => x_msg_data
2414: );
2415: END IF;
2416:
2417: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2418: RAISE FND_API.G_EXC_ERROR;
2419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2421: END IF;

Line 2418: RAISE FND_API.G_EXC_ERROR;

2414: );
2415: END IF;
2416:
2417: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2418: RAISE FND_API.G_EXC_ERROR;
2419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2421: END IF;
2422:

Line 2419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2415: END IF;
2416:
2417: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2418: RAISE FND_API.G_EXC_ERROR;
2419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2421: END IF;
2422:
2423: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL

Line 2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2416:
2417: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2418: RAISE FND_API.G_EXC_ERROR;
2419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2421: END IF;
2422:
2423: END IF; -- end of l_old_item_group_rec.source_item_group_id IS NOT NULL
2424:

Line 2440: p_encoded => fnd_api.g_false);

2436: -- Standard call to get message count and if count is 1, get message info
2437: FND_MSG_PUB.Count_And_Get
2438: ( p_count => x_msg_count,
2439: p_data => x_msg_data,
2440: p_encoded => fnd_api.g_false);
2441:
2442: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2444: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group',

Line 2450: WHEN FND_API.G_EXC_ERROR THEN

2446: END IF;
2447:
2448:
2449: EXCEPTION
2450: WHEN FND_API.G_EXC_ERROR THEN
2451: x_return_status := FND_API.G_RET_STS_ERROR;
2452: Rollback to Modify_Item_group_pvt;
2453: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2454: p_data => x_msg_data,

Line 2451: x_return_status := FND_API.G_RET_STS_ERROR;

2447:
2448:
2449: EXCEPTION
2450: WHEN FND_API.G_EXC_ERROR THEN
2451: x_return_status := FND_API.G_RET_STS_ERROR;
2452: Rollback to Modify_Item_group_pvt;
2453: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2454: p_data => x_msg_data,
2455: p_encoded => fnd_api.g_false);

Line 2455: p_encoded => fnd_api.g_false);

2451: x_return_status := FND_API.G_RET_STS_ERROR;
2452: Rollback to Modify_Item_group_pvt;
2453: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2454: p_data => x_msg_data,
2455: p_encoded => fnd_api.g_false);
2456: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2457:
2458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2460: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Error in Modify_Item_group');
2461: END IF;
2462:
2463:
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2466: Rollback to Modify_Item_group_pvt;
2467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2468: p_data => x_msg_data,

Line 2465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2461: END IF;
2462:
2463:
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2466: Rollback to Modify_Item_group_pvt;
2467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2468: p_data => x_msg_data,
2469: p_encoded => fnd_api.g_false);

Line 2469: p_encoded => fnd_api.g_false);

2465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2466: Rollback to Modify_Item_group_pvt;
2467: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2468: p_data => x_msg_data,
2469: p_encoded => fnd_api.g_false);
2470: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2471: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2473: 'ahl.plsql.ahl_mc_itemgroup_pvt.Modify_Item_group', 'Unexpected error in Modify_Item_group');

Line 2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2474: END IF;
2475:
2476:
2477: WHEN OTHERS THEN
2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2479: Rollback to Modify_Item_group_pvt;
2480: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2481: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2482: p_procedure_name => 'Modify_Item_Group',

Line 2487: p_encoded => fnd_api.g_false);

2483: p_error_text => SUBSTR(SQLERRM,1,240));
2484: END IF;
2485: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2486: p_data => x_msg_data,
2487: p_encoded => fnd_api.g_false);
2488: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
2489:
2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

2505: -- Pre-reqs :
2506: -- Parameters :
2507: -- Standard IN Parameters :
2508: PROCEDURE Remove_Item_group(p_api_version IN NUMBER,
2509: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2511: x_return_status OUT NOCOPY VARCHAR2,
2512: x_msg_count OUT NOCOPY NUMBER,
2513: x_msg_data OUT NOCOPY VARCHAR2,

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

2506: -- Parameters :
2507: -- Standard IN Parameters :
2508: PROCEDURE Remove_Item_group(p_api_version IN NUMBER,
2509: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2510: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2511: x_return_status OUT NOCOPY VARCHAR2,
2512: x_msg_count OUT NOCOPY NUMBER,
2513: x_msg_data OUT NOCOPY VARCHAR2,
2514: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type

Line 2572: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

2568: -- Standard start of API savepoint
2569: SAVEPOINT Remove_Item_group_Pvt;
2570:
2571: -- Standard call to check for call compatibility
2572: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2573: G_PKG_NAME) THEN
2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2575: END IF;
2576:

Line 2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2570:
2571: -- Standard call to check for call compatibility
2572: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
2573: G_PKG_NAME) THEN
2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2575: END IF;
2576:
2577: -- Initialize message list if p_init_msg_list is set to TRUE
2578: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2578: IF FND_API.To_Boolean(p_init_msg_list) THEN

2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2575: END IF;
2576:
2577: -- Initialize message list if p_init_msg_list is set to TRUE
2578: IF FND_API.To_Boolean(p_init_msg_list) THEN
2579: FND_MSG_PUB.Initialize;
2580: END IF;
2581:
2582: -- Initialize API return status to success

Line 2583: x_return_status := FND_API.G_RET_STS_SUCCESS;

2579: FND_MSG_PUB.Initialize;
2580: END IF;
2581:
2582: -- Initialize API return status to success
2583: x_return_status := FND_API.G_RET_STS_SUCCESS;
2584:
2585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2586: THEN
2587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2601: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2597: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');
2598: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2599: FND_MSG_PUB.ADD;
2600: --dbms_output.put_line('Item Group does not exist');
2601: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2602: END IF;
2603:
2604: -- Check Object version number.
2605: IF (l_item_group_rec.object_version_number <> p_item_group_rec.object_version_number) THEN

Line 2609: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2605: IF (l_item_group_rec.object_version_number <> p_item_group_rec.object_version_number) THEN
2606: CLOSE Item_group_csr;
2607: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2608: FND_MSG_PUB.ADD;
2609: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2610: END IF;
2611:
2612: -- Check if this item group has any positions associated.
2613: OPEN ahl_relationships_csr(p_item_group_rec.item_group_id);

Line 2620: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2616: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_POSN_EXISTS');
2617: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2618: FND_MSG_PUB.ADD;
2619: --dbms_output.put_line('Positions exist for this item group');
2620: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2621: END IF;
2622:
2623: CLOSE ahl_relationships_csr;
2624:

Line 2633: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2629: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_COMP_EXISTS');
2630: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2631: FND_MSG_PUB.ADD;
2632: --dbms_output.put_line('Positions exist for this item group');
2633: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2634: END IF;
2635:
2636: CLOSE ahl_item_comp_csr;
2637:

Line 2645: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2641: IF l_item_group_rec.status_code ='APPROVAL_PENDING'
2642: THEN
2643: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_APPR_PEND');
2644: FND_MSG_PUB.ADD;
2645: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2646: END IF;
2647:
2648:
2649: IF l_item_group_rec.status_code ='REMOVED'

Line 2653: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2649: IF l_item_group_rec.status_code ='REMOVED'
2650: THEN
2651: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_REMOVED');
2652: FND_MSG_PUB.ADD;
2653: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2654: END IF;
2655:
2656:
2657: IF l_item_group_rec.status_code IN ('DRAFT' ,'APPROVAL_REJECTED')

Line 2720: p_encoded => fnd_api.g_false);

2716: -- Standard call to get message count and if count is 1, get message info
2717: FND_MSG_PUB.Count_And_Get
2718: ( p_count => x_msg_count,
2719: p_data => x_msg_data,
2720: p_encoded => fnd_api.g_false);
2721:
2722: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2723: THEN
2724: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2731: WHEN FND_API.G_EXC_ERROR THEN

2727:
2728:
2729:
2730: EXCEPTION
2731: WHEN FND_API.G_EXC_ERROR THEN
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733: Rollback to Remove_Item_group_pvt;
2734: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2735: p_data => x_msg_data,

Line 2732: x_return_status := FND_API.G_RET_STS_ERROR;

2728:
2729:
2730: EXCEPTION
2731: WHEN FND_API.G_EXC_ERROR THEN
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733: Rollback to Remove_Item_group_pvt;
2734: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2735: p_data => x_msg_data,
2736: p_encoded => fnd_api.g_false);

Line 2736: p_encoded => fnd_api.g_false);

2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733: Rollback to Remove_Item_group_pvt;
2734: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2735: p_data => x_msg_data,
2736: p_encoded => fnd_api.g_false);
2737:
2738: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2739: THEN
2740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2741: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Error in Remove_Item_group');
2742: END IF;
2743:
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2746: Rollback to Remove_Item_group_pvt;
2747: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2748: p_data => x_msg_data,

Line 2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2741: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Error in Remove_Item_group');
2742: END IF;
2743:
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2746: Rollback to Remove_Item_group_pvt;
2747: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2748: p_data => x_msg_data,
2749: p_encoded => fnd_api.g_false);

Line 2749: p_encoded => fnd_api.g_false);

2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2746: Rollback to Remove_Item_group_pvt;
2747: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2748: p_data => x_msg_data,
2749: p_encoded => fnd_api.g_false);
2750: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2751: THEN
2752: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2753: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unexpected error in Remove_Item_group');

Line 2758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2754: END IF;
2755:
2756:
2757: WHEN OTHERS THEN
2758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2759: Rollback to Remove_Item_group_pvt;
2760: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2761: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2762: p_procedure_name => 'Remove_Item_Group',

Line 2767: p_encoded => fnd_api.g_false);

2763: p_error_text => SUBSTR(SQLERRM,1,240));
2764: END IF;
2765: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2766: p_data => x_msg_data,
2767: p_encoded => fnd_api.g_false);
2768: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2769: THEN
2770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2771: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Unknown error in Remove_Item_group');

Line 2788: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

2784: -- Pre-reqs :
2785: -- Parameters :
2786: -- Standard IN Parameters :
2787: -- p_api_version IN NUMBER Required
2788: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2789: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2790: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2791: --
2792: -- Standard OUT Parameters :

Line 2789: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

2785: -- Parameters :
2786: -- Standard IN Parameters :
2787: -- p_api_version IN NUMBER Required
2788: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2789: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2790: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2791: --
2792: -- Standard OUT Parameters :
2793: -- x_return_status OUT VARCHAR2 Required

Line 2790: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

2786: -- Standard IN Parameters :
2787: -- p_api_version IN NUMBER Required
2788: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2789: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2790: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2791: --
2792: -- Standard OUT Parameters :
2793: -- x_return_status OUT VARCHAR2 Required
2794: -- x_msg_count OUT NUMBER Required

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

2801: -- Enhancement 115.10
2802: -- End of Comments --
2803: PROCEDURE Initiate_Itemgroup_Appr (
2804: p_api_version IN NUMBER,
2805: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2806: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2807: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2808: p_default IN VARCHAR2 := FND_API.G_FALSE,
2809: p_module_type IN VARCHAR2,

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

2802: -- End of Comments --
2803: PROCEDURE Initiate_Itemgroup_Appr (
2804: p_api_version IN NUMBER,
2805: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2806: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2807: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2808: p_default IN VARCHAR2 := FND_API.G_FALSE,
2809: p_module_type IN VARCHAR2,
2810: x_return_status OUT NOCOPY VARCHAR2,

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

2803: PROCEDURE Initiate_Itemgroup_Appr (
2804: p_api_version IN NUMBER,
2805: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2806: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2807: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2808: p_default IN VARCHAR2 := FND_API.G_FALSE,
2809: p_module_type IN VARCHAR2,
2810: x_return_status OUT NOCOPY VARCHAR2,
2811: x_msg_count OUT NOCOPY NUMBER,

Line 2808: p_default IN VARCHAR2 := FND_API.G_FALSE,

2804: p_api_version IN NUMBER,
2805: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2806: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2807: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2808: p_default IN VARCHAR2 := FND_API.G_FALSE,
2809: p_module_type IN VARCHAR2,
2810: x_return_status OUT NOCOPY VARCHAR2,
2811: x_msg_count OUT NOCOPY NUMBER,
2812: x_msg_data OUT NOCOPY VARCHAR2,

Line 2832: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

2828: l_return_status VARCHAR2(50);
2829: l_msg_count NUMBER;
2830: l_msg_data VARCHAR2(2000);
2831: l_activity_id NUMBER:=p_source_item_group_id;
2832: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
2833: l_object_Version_number NUMBER:=nvl(p_object_Version_number,0);
2834:
2835: l_upd_status VARCHAR2(50);
2836: l_rev_status VARCHAR2(50);

Line 2891: IF FND_API.to_boolean(l_init_msg_list) THEN

2887: SAVEPOINT Initiate_Itemgroup_Appr;
2888:
2889: -- Standard call to check for call compatibility.
2890:
2891: IF FND_API.to_boolean(l_init_msg_list) THEN
2892: FND_MSG_PUB.initialize;
2893: END IF;
2894:
2895: -- Initialize API return status to success

Line 2897: x_return_status :=FND_API.G_RET_STS_SUCCESS;

2893: END IF;
2894:
2895: -- Initialize API return status to success
2896:
2897: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2898:
2899: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2900: THEN
2901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2918: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM

2914: x_return_status=>l_return_status,
2915: x_msg_count =>l_msg_count,
2916: x_msg_data =>l_msg_data);
2917:
2918: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM
2919: THEN
2920: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJ_VERSION_NULL');
2921: FND_MSG_PUB.ADD;
2922: END IF;

Line 2924: IF p_source_item_group_id is null or p_source_item_group_id = FND_API.G_MISS_NUM

2920: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJ_VERSION_NULL');
2921: FND_MSG_PUB.ADD;
2922: END IF;
2923:
2924: IF p_source_item_group_id is null or p_source_item_group_id = FND_API.G_MISS_NUM
2925: THEN
2926: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
2927: FND_MSG_PUB.ADD;
2928: ELSE

Line 2943: RAISE FND_API.G_EXC_ERROR;

2939: THEN
2940: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_MOD_NAME');
2941: FND_MSG_PUB.ADD;
2942: CLOSE Item_group_name;
2943: RAISE FND_API.G_EXC_ERROR;
2944: END IF;
2945: CLOSE Item_group_name;
2946: END IF;
2947:

Line 3000: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2996:
2997: IF l_msg_count > 0
2998: THEN
2999: X_msg_count := l_msg_count;
3000: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3001: RAISE FND_API.G_EXC_ERROR;
3002: END IF;
3003:
3004:

Line 3001: RAISE FND_API.G_EXC_ERROR;

2997: IF l_msg_count > 0
2998: THEN
2999: X_msg_count := l_msg_count;
3000: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3001: RAISE FND_API.G_EXC_ERROR;
3002: END IF;
3003:
3004:
3005: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 3023: RAISE FND_API.G_EXC_ERROR;

3019: IF sql%rowcount=0
3020: THEN
3021: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
3022: FND_MSG_PUB.ADD;
3023: RAISE FND_API.G_EXC_ERROR;
3024: END IF;
3025:
3026: IF l_ACTIVE='Y'
3027: THEN

Line 3078: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3074:
3075: IF l_msg_count > 0
3076: THEN
3077: X_msg_count := l_msg_count;
3078: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081:
3082:

Line 3079: RAISE FND_API.G_EXC_ERROR;

3075: IF l_msg_count > 0
3076: THEN
3077: X_msg_count := l_msg_count;
3078: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081:
3082:
3083: -- Standard check of p_commit

Line 3084: IF FND_API.TO_BOOLEAN(p_commit) THEN

3080: END IF;
3081:
3082:
3083: -- Standard check of p_commit
3084: IF FND_API.TO_BOOLEAN(p_commit) THEN
3085: COMMIT WORK;
3086: END IF;
3087:
3088: -- Standard call to get message count and if count is 1, get message info

Line 3092: p_encoded => fnd_api.g_false);

3088: -- Standard call to get message count and if count is 1, get message info
3089: FND_MSG_PUB.Count_And_Get
3090: ( p_count => x_msg_count,
3091: p_data => x_msg_data,
3092: p_encoded => fnd_api.g_false);
3093:
3094: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3095: THEN
3096: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3102: WHEN FND_API.G_EXC_ERROR THEN

3098: END IF;
3099:
3100:
3101: EXCEPTION
3102: WHEN FND_API.G_EXC_ERROR THEN
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104: Rollback to Initiate_Itemgroup_Appr;
3105: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3106: p_data => x_msg_data,

Line 3103: x_return_status := FND_API.G_RET_STS_ERROR;

3099:
3100:
3101: EXCEPTION
3102: WHEN FND_API.G_EXC_ERROR THEN
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104: Rollback to Initiate_Itemgroup_Appr;
3105: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3106: p_data => x_msg_data,
3107: p_encoded => fnd_api.g_false);

Line 3107: p_encoded => fnd_api.g_false);

3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104: Rollback to Initiate_Itemgroup_Appr;
3105: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3106: p_data => x_msg_data,
3107: p_encoded => fnd_api.g_false);
3108: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3109: THEN
3110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3111: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Error in Initiate_Itemgroup_Appr');

Line 3116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3112: END IF;
3113:
3114:
3115:
3116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: Rollback to Initiate_Itemgroup_Appr;
3119: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3120: p_data => x_msg_data,

Line 3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3113:
3114:
3115:
3116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: Rollback to Initiate_Itemgroup_Appr;
3119: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3120: p_data => x_msg_data,
3121: p_encoded => fnd_api.g_false);

Line 3121: p_encoded => fnd_api.g_false);

3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: Rollback to Initiate_Itemgroup_Appr;
3119: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3120: p_data => x_msg_data,
3121: p_encoded => fnd_api.g_false);
3122: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3123: THEN
3124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3125: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Unexpected Error in Initiate_Itemgroup_Appr');

Line 3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3126: END IF;
3127:
3128:
3129: WHEN OTHERS THEN
3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3131: Rollback to Initiate_Itemgroup_Appr;
3132: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3133: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3134: p_procedure_name => 'Initiate_Itemgroup_Appr',

Line 3139: p_encoded => fnd_api.g_false);

3135: p_error_text => SUBSTR(SQLERRM,1,240));
3136: END IF;
3137: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3138: p_data => x_msg_data,
3139: p_encoded => fnd_api.g_false);
3140:
3141: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3142: THEN
3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3161: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

3157: -- Pre-reqs :
3158: -- Parameters :
3159: -- Standard IN Parameters :
3160: -- p_api_version IN NUMBER Required
3161: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3162: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3163: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3164: --
3165: -- Standard OUT Parameters :

Line 3162: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

3158: -- Parameters :
3159: -- Standard IN Parameters :
3160: -- p_api_version IN NUMBER Required
3161: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3162: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3163: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3164: --
3165: -- Standard OUT Parameters :
3166: -- x_return_status OUT VARCHAR2 Required

Line 3163: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

3159: -- Standard IN Parameters :
3160: -- p_api_version IN NUMBER Required
3161: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3162: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3163: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3164: --
3165: -- Standard OUT Parameters :
3166: -- x_return_status OUT VARCHAR2 Required
3167: -- x_msg_count OUT NUMBER Required

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

3174: -- End of Comments --
3175:
3176: PROCEDURE Create_ItemGroup_Revision (
3177: p_api_version IN NUMBER,
3178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3181: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
3182: P_MODULE_TYPE IN VARCHAR2,

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

3175:
3176: PROCEDURE Create_ItemGroup_Revision (
3177: p_api_version IN NUMBER,
3178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3181: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
3182: P_MODULE_TYPE IN VARCHAR2,
3183: x_return_status OUT NOCOPY VARCHAR2,

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

3176: PROCEDURE Create_ItemGroup_Revision (
3177: p_api_version IN NUMBER,
3178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3181: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
3182: P_MODULE_TYPE IN VARCHAR2,
3183: x_return_status OUT NOCOPY VARCHAR2,
3184: x_msg_count OUT NOCOPY NUMBER,

Line 3181: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,

3177: p_api_version IN NUMBER,
3178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3179: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3181: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
3182: P_MODULE_TYPE IN VARCHAR2,
3183: x_return_status OUT NOCOPY VARCHAR2,
3184: x_msg_count OUT NOCOPY NUMBER,
3185: x_msg_data OUT NOCOPY VARCHAR2,

Line 3264: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

3260: status_code <> 'COMPLETE';
3261:
3262: l_dummy VARCHAR2(1);
3263: l_msg_count Number;
3264: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
3265: l_itemgroup_det get_itemgroup_det%rowtype;
3266: l_item_group_id Number;
3267: l_last_update_login NUMBER;
3268: l_last_updated_by NUMBER;

Line 3288: IF FND_API.to_boolean(l_init_msg_list) THEN

3284: SAVEPOINT Create_ItemGroup_Revision;
3285:
3286: -- Standard call to check for call compatibility.
3287:
3288: IF FND_API.to_boolean(l_init_msg_list) THEN
3289: FND_MSG_PUB.initialize;
3290: END IF;
3291:
3292: -- Initialize API return status to success

Line 3294: x_return_status :=FND_API.G_RET_STS_SUCCESS;

3290: END IF;
3291:
3292: -- Initialize API return status to success
3293:
3294: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3295:
3296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3297: THEN
3298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3343: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3339:
3340: IF l_msg_count > 0
3341: THEN
3342: X_msg_count := l_msg_count;
3343: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3344: RAISE FND_API.G_EXC_ERROR;
3345: END IF;
3346:
3347: -- Sequence Number for the New Revision.

Line 3344: RAISE FND_API.G_EXC_ERROR;

3340: IF l_msg_count > 0
3341: THEN
3342: X_msg_count := l_msg_count;
3343: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3344: RAISE FND_API.G_EXC_ERROR;
3345: END IF;
3346:
3347: -- Sequence Number for the New Revision.
3348:

Line 3486: IF FND_API.TO_BOOLEAN(p_commit) THEN

3482: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'End of Loop');
3483: END IF;
3484:
3485: -- Standard check of p_commit
3486: IF FND_API.TO_BOOLEAN(p_commit) THEN
3487: COMMIT WORK;
3488: END IF;
3489:
3490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 3499: WHEN FND_API.G_EXC_ERROR THEN

3495:
3496:
3497:
3498: EXCEPTION
3499: WHEN FND_API.G_EXC_ERROR THEN
3500: x_return_status := FND_API.G_RET_STS_ERROR;
3501: Rollback to Create_ItemGroup_Revision;
3502: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3503: p_data => x_msg_data,

Line 3500: x_return_status := FND_API.G_RET_STS_ERROR;

3496:
3497:
3498: EXCEPTION
3499: WHEN FND_API.G_EXC_ERROR THEN
3500: x_return_status := FND_API.G_RET_STS_ERROR;
3501: Rollback to Create_ItemGroup_Revision;
3502: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3503: p_data => x_msg_data,
3504: p_encoded => fnd_api.g_false);

Line 3504: p_encoded => fnd_api.g_false);

3500: x_return_status := FND_API.G_RET_STS_ERROR;
3501: Rollback to Create_ItemGroup_Revision;
3502: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3503: p_data => x_msg_data,
3504: p_encoded => fnd_api.g_false);
3505: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3506: THEN
3507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3508: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Error in Create_ItemGroup_Revision');

Line 3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3508: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Error in Create_ItemGroup_Revision');
3509: END IF;
3510:
3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514: Rollback to Create_ItemGroup_Revision;
3515: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3516: p_data => x_msg_data,

Line 3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3509: END IF;
3510:
3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514: Rollback to Create_ItemGroup_Revision;
3515: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3516: p_data => x_msg_data,
3517: p_encoded => fnd_api.g_false);

Line 3517: p_encoded => fnd_api.g_false);

3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514: Rollback to Create_ItemGroup_Revision;
3515: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3516: p_data => x_msg_data,
3517: p_encoded => fnd_api.g_false);
3518: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3519: THEN
3520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3521: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unecpected Error in Create_ItemGroup_Revision');

Line 3526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3522: END IF;
3523:
3524:
3525: WHEN OTHERS THEN
3526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3527: Rollback to Create_ItemGroup_Revision;
3528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3529: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3530: p_procedure_name => 'Create_ItemGroup_Revision',

Line 3535: p_encoded => fnd_api.g_false);

3531: p_error_text => SUBSTR(SQLERRM,1,240));
3532: END IF;
3533: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3534: p_data => x_msg_data,
3535: p_encoded => fnd_api.g_false);
3536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3537: THEN
3538: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3539: 'ahl.plsql.ahl_mc_itemgroup_pvt.Create_ItemGroup_Revision', 'Unknown Error in Create_ItemGroup_Revision');

Line 3791: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

3787: -- Pre-reqs :
3788: -- Parameters :
3789: -- Standard IN Parameters :
3790: -- p_api_version IN NUMBER Required
3791: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3792: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3793: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3794: --
3795: -- Standard OUT Parameters :

Line 3792: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

3788: -- Parameters :
3789: -- Standard IN Parameters :
3790: -- p_api_version IN NUMBER Required
3791: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3792: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3793: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3794: --
3795: -- Standard OUT Parameters :
3796: -- x_return_status OUT VARCHAR2 Required

Line 3793: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

3789: -- Standard IN Parameters :
3790: -- p_api_version IN NUMBER Required
3791: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3792: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3793: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3794: --
3795: -- Standard OUT Parameters :
3796: -- x_return_status OUT VARCHAR2 Required
3797: -- x_msg_count OUT NUMBER Required

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

3805: -- End of Comments --
3806:
3807: PROCEDURE Approve_ItemGroups (
3808: p_api_version IN NUMBER,
3809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3810: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3812: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
3813: P_MODULE_TYPE IN VARCHAR2,

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

3806:
3807: PROCEDURE Approve_ItemGroups (
3808: p_api_version IN NUMBER,
3809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3810: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3812: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
3813: P_MODULE_TYPE IN VARCHAR2,
3814: x_return_status OUT NOCOPY VARCHAR2,

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

3807: PROCEDURE Approve_ItemGroups (
3808: p_api_version IN NUMBER,
3809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3810: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3812: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
3813: P_MODULE_TYPE IN VARCHAR2,
3814: x_return_status OUT NOCOPY VARCHAR2,
3815: x_msg_count OUT NOCOPY NUMBER,

Line 3812: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,

3808: p_api_version IN NUMBER,
3809: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3810: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3811: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3812: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
3813: P_MODULE_TYPE IN VARCHAR2,
3814: x_return_status OUT NOCOPY VARCHAR2,
3815: x_msg_count OUT NOCOPY NUMBER,
3816: x_msg_data OUT NOCOPY VARCHAR2,

Line 3892: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

3888:
3889:
3890: l_status VARCHAR2(30);
3891: l_msg_count Number;
3892: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
3893: l_rowid VARCHAR2(30);
3894: l_action varchar2(2);
3895:
3896: -- SATHAPLI::Bug# 4328454 fix

Line 3912: IF FND_API.to_boolean(l_init_msg_list) THEN

3908:
3909:
3910: -- Standard call to check for call compatibility.
3911:
3912: IF FND_API.to_boolean(l_init_msg_list) THEN
3913: FND_MSG_PUB.initialize;
3914: END IF;
3915:
3916: -- Initialize API return status to success

Line 3918: x_return_status :=FND_API.G_RET_STS_SUCCESS;

3914: END IF;
3915:
3916: -- Initialize API return status to success
3917:
3918: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3919:
3920: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3921: THEN
3922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 3949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3945:
3946: IF l_msg_count > 0
3947: THEN
3948: X_msg_count := l_msg_count;
3949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3950: RAISE FND_API.G_EXC_ERROR;
3951: END IF;
3952:
3953:

Line 3950: RAISE FND_API.G_EXC_ERROR;

3946: IF l_msg_count > 0
3947: THEN
3948: X_msg_count := l_msg_count;
3949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3950: RAISE FND_API.G_EXC_ERROR;
3951: END IF;
3952:
3953:
3954: IF p_appr_status='APPROVED'

Line 4181: WHEN FND_API.G_EXC_ERROR THEN

4177:
4178:
4179:
4180: EXCEPTION
4181: WHEN FND_API.G_EXC_ERROR THEN
4182: x_return_status := FND_API.G_RET_STS_ERROR;
4183: Rollback to Approve_ItemGroups;
4184: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4185: p_data => x_msg_data,

Line 4182: x_return_status := FND_API.G_RET_STS_ERROR;

4178:
4179:
4180: EXCEPTION
4181: WHEN FND_API.G_EXC_ERROR THEN
4182: x_return_status := FND_API.G_RET_STS_ERROR;
4183: Rollback to Approve_ItemGroups;
4184: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4185: p_data => x_msg_data,
4186: p_encoded => fnd_api.g_false);

Line 4186: p_encoded => fnd_api.g_false);

4182: x_return_status := FND_API.G_RET_STS_ERROR;
4183: Rollback to Approve_ItemGroups;
4184: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4185: p_data => x_msg_data,
4186: p_encoded => fnd_api.g_false);
4187:
4188: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4189: THEN
4190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4191: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Error in Approve_ItemGroups');
4192: END IF;
4193:
4194:
4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4197: Rollback to Approve_ItemGroups;
4198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4199: p_data => x_msg_data,

Line 4196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4192: END IF;
4193:
4194:
4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4197: Rollback to Approve_ItemGroups;
4198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4199: p_data => x_msg_data,
4200: p_encoded => fnd_api.g_false);

Line 4200: p_encoded => fnd_api.g_false);

4196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4197: Rollback to Approve_ItemGroups;
4198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4199: p_data => x_msg_data,
4200: p_encoded => fnd_api.g_false);
4201:
4202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4203: THEN
4204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 4209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4205: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Unexpected Error in Approve_ItemGroups');
4206: END IF;
4207:
4208: WHEN OTHERS THEN
4209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4210: Rollback to Approve_ItemGroups;
4211: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4212: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4213: p_procedure_name => 'Approve_ItemGroups',

Line 4218: p_encoded => fnd_api.g_false);

4214: p_error_text => SUBSTR(SQLERRM,1,240));
4215: END IF;
4216: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4217: p_data => x_msg_data,
4218: p_encoded => fnd_api.g_false);
4219:
4220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4221: THEN
4222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

4231:
4232: PROCEDURE Modify_Position_Assos
4233: (
4234: p_api_version IN NUMBER,
4235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4238: p_module_type IN VARCHAR2,
4239: x_return_status OUT NOCOPY VARCHAR2,

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

4232: PROCEDURE Modify_Position_Assos
4233: (
4234: p_api_version IN NUMBER,
4235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4238: p_module_type IN VARCHAR2,
4239: x_return_status OUT NOCOPY VARCHAR2,
4240: x_msg_count OUT NOCOPY NUMBER,

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

4233: (
4234: p_api_version IN NUMBER,
4235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4238: p_module_type IN VARCHAR2,
4239: x_return_status OUT NOCOPY VARCHAR2,
4240: x_msg_count OUT NOCOPY NUMBER,
4241: x_msg_data OUT NOCOPY VARCHAR2,

Line 4283: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

4279: -- Standard start of API savepoint
4280: SAVEPOINT Modify_Position_Assos_SP;
4281:
4282: -- Standard call to check for call compatibility
4283: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
4284: THEN
4285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4286: END IF;
4287:

Line 4285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4281:
4282: -- Standard call to check for call compatibility
4283: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
4284: THEN
4285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4286: END IF;
4287:
4288: -- Initialize message list if p_init_msg_list is set to TRUE
4289: IF FND_API.TO_BOOLEAN(p_init_msg_list)

Line 4289: IF FND_API.TO_BOOLEAN(p_init_msg_list)

4285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4286: END IF;
4287:
4288: -- Initialize message list if p_init_msg_list is set to TRUE
4289: IF FND_API.TO_BOOLEAN(p_init_msg_list)
4290: THEN
4291: FND_MSG_PUB.Initialize;
4292: END IF;
4293:

Line 4295: x_return_status := FND_API.G_RET_STS_SUCCESS;

4291: FND_MSG_PUB.Initialize;
4292: END IF;
4293:
4294: -- Initialize API return status to success
4295: x_return_status := FND_API.G_RET_STS_SUCCESS;
4296:
4297: -- API body starts here
4298: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4299: THEN

Line 4317: RAISE FND_API.G_EXC_ERROR;

4313: THEN
4314: CLOSE get_itemgroup_details;
4315: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_DELETED');
4316: FND_MSG_PUB.ADD;
4317: RAISE FND_API.G_EXC_ERROR;
4318: ELSIF (l_obj_ver_num <> p_object_version_number)
4319: THEN
4320: CLOSE get_itemgroup_details;
4321: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');

Line 4323: RAISE FND_API.G_EXC_ERROR;

4319: THEN
4320: CLOSE get_itemgroup_details;
4321: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
4322: FND_MSG_PUB.ADD;
4323: RAISE FND_API.G_EXC_ERROR;
4324: ELSIF (l_status <> 'DRAFT' or nvl(l_source_id, 0) <= 0)
4325: THEN
4326: CLOSE get_itemgroup_details;
4327: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOUPDATE');

Line 4329: RAISE FND_API.G_EXC_ERROR;

4325: THEN
4326: CLOSE get_itemgroup_details;
4327: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOUPDATE');
4328: FND_MSG_PUB.ADD;
4329: RAISE FND_API.G_EXC_ERROR;
4330: END IF;
4331: CLOSE get_itemgroup_details;
4332:
4333: -- All above validations have passed

Line 4365: RAISE FND_API.G_EXC_ERROR;

4361:
4362: -- Check Error Message stack.
4363: x_msg_count := FND_MSG_PUB.count_msg;
4364: IF x_msg_count > 0 THEN
4365: RAISE FND_API.G_EXC_ERROR;
4366: END IF;
4367: END IF;
4368:
4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 4383: RAISE FND_API.G_EXC_ERROR;

4379:
4380: -- Check Error Message stack.
4381: x_msg_count := FND_MSG_PUB.count_msg;
4382: IF x_msg_count > 0 THEN
4383: RAISE FND_API.G_EXC_ERROR;
4384: END IF;
4385:
4386: -- Standard check for p_commit
4387: IF FND_API.TO_BOOLEAN (p_commit)

Line 4387: IF FND_API.TO_BOOLEAN (p_commit)

4383: RAISE FND_API.G_EXC_ERROR;
4384: END IF;
4385:
4386: -- Standard check for p_commit
4387: IF FND_API.TO_BOOLEAN (p_commit)
4388: THEN
4389: COMMIT WORK;
4390: END IF;
4391:

Line 4397: p_encoded => FND_API.G_FALSE

4393: FND_MSG_PUB.count_and_get
4394: (
4395: p_count => x_msg_count,
4396: p_data => x_msg_data,
4397: p_encoded => FND_API.G_FALSE
4398: );
4399:
4400: EXCEPTION
4401: WHEN FND_API.G_EXC_ERROR THEN

Line 4401: WHEN FND_API.G_EXC_ERROR THEN

4397: p_encoded => FND_API.G_FALSE
4398: );
4399:
4400: EXCEPTION
4401: WHEN FND_API.G_EXC_ERROR THEN
4402: x_return_status := FND_API.G_RET_STS_ERROR;
4403: Rollback to Modify_Position_Assos_SP;
4404: FND_MSG_PUB.count_and_get
4405: (

Line 4402: x_return_status := FND_API.G_RET_STS_ERROR;

4398: );
4399:
4400: EXCEPTION
4401: WHEN FND_API.G_EXC_ERROR THEN
4402: x_return_status := FND_API.G_RET_STS_ERROR;
4403: Rollback to Modify_Position_Assos_SP;
4404: FND_MSG_PUB.count_and_get
4405: (
4406: p_count => x_msg_count,

Line 4408: p_encoded => FND_API.G_FALSE

4404: FND_MSG_PUB.count_and_get
4405: (
4406: p_count => x_msg_count,
4407: p_data => x_msg_data,
4408: p_encoded => FND_API.G_FALSE
4409: );
4410:
4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4407: p_data => x_msg_data,
4408: p_encoded => FND_API.G_FALSE
4409: );
4410:
4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4413: Rollback to Modify_Position_Assos_SP;
4414: FND_MSG_PUB.count_and_get
4415: (

Line 4412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4408: p_encoded => FND_API.G_FALSE
4409: );
4410:
4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4413: Rollback to Modify_Position_Assos_SP;
4414: FND_MSG_PUB.count_and_get
4415: (
4416: p_count => x_msg_count,

Line 4418: p_encoded => FND_API.G_FALSE

4414: FND_MSG_PUB.count_and_get
4415: (
4416: p_count => x_msg_count,
4417: p_data => x_msg_data,
4418: p_encoded => FND_API.G_FALSE
4419: );
4420:
4421: WHEN OTHERS THEN
4422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4418: p_encoded => FND_API.G_FALSE
4419: );
4420:
4421: WHEN OTHERS THEN
4422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4423: Rollback to Modify_Position_Assos_SP;
4424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4425: THEN
4426: FND_MSG_PUB.add_exc_msg

Line 4437: p_encoded => FND_API.G_FALSE

4433: FND_MSG_PUB.count_and_get
4434: (
4435: p_count => x_msg_count,
4436: p_data => x_msg_data,
4437: p_encoded => FND_API.G_FALSE
4438: );
4439:
4440: END Modify_Position_Assos;
4441: