95: ) RETURNING UF_DETAIL_ID INTO X_UF_DETAIL_ID;
96: EXCEPTION
97: WHEN OTHERS THEN
98: IF(SQLCODE = -1) THEN
99: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_DUP_DET');
100: FND_MESSAGE.Set_Token('START_DATE',x_start_date);
101: FND_MESSAGE.Set_Token('END_DATE',x_end_date);
102: FND_MESSAGE.Set_Token('UOM_CODE',x_uom_code);
103: FND_MESSAGE.Set_Token('USAGE_PER_DAY',x_usage_per_day);
96: EXCEPTION
97: WHEN OTHERS THEN
98: IF(SQLCODE = -1) THEN
99: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_DUP_DET');
100: FND_MESSAGE.Set_Token('START_DATE',x_start_date);
101: FND_MESSAGE.Set_Token('END_DATE',x_end_date);
102: FND_MESSAGE.Set_Token('UOM_CODE',x_uom_code);
103: FND_MESSAGE.Set_Token('USAGE_PER_DAY',x_usage_per_day);
104: FND_MSG_PUB.ADD;
97: WHEN OTHERS THEN
98: IF(SQLCODE = -1) THEN
99: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_DUP_DET');
100: FND_MESSAGE.Set_Token('START_DATE',x_start_date);
101: FND_MESSAGE.Set_Token('END_DATE',x_end_date);
102: FND_MESSAGE.Set_Token('UOM_CODE',x_uom_code);
103: FND_MESSAGE.Set_Token('USAGE_PER_DAY',x_usage_per_day);
104: FND_MSG_PUB.ADD;
105: ELSE
98: IF(SQLCODE = -1) THEN
99: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_DUP_DET');
100: FND_MESSAGE.Set_Token('START_DATE',x_start_date);
101: FND_MESSAGE.Set_Token('END_DATE',x_end_date);
102: FND_MESSAGE.Set_Token('UOM_CODE',x_uom_code);
103: FND_MESSAGE.Set_Token('USAGE_PER_DAY',x_usage_per_day);
104: FND_MSG_PUB.ADD;
105: ELSE
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_DUP_DET');
100: FND_MESSAGE.Set_Token('START_DATE',x_start_date);
101: FND_MESSAGE.Set_Token('END_DATE',x_end_date);
102: FND_MESSAGE.Set_Token('UOM_CODE',x_uom_code);
103: FND_MESSAGE.Set_Token('USAGE_PER_DAY',x_usage_per_day);
104: FND_MSG_PUB.ADD;
105: ELSE
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;