87: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
88: ||'No item found with instance id '||p_instance_id
89: ||' and instance number '||p_instance_number);
90: END IF;
91: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
92: FND_MESSAGE.SET_TOKEN('ERROR','No item found with instance id '
93: ||p_instance_id||' and instance number '||p_instance_number);
94: FND_MSG_PUB.Add;
95: RAISE FND_API.G_EXC_ERROR;
88: ||'No item found with instance id '||p_instance_id
89: ||' and instance number '||p_instance_number);
90: END IF;
91: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
92: FND_MESSAGE.SET_TOKEN('ERROR','No item found with instance id '
93: ||p_instance_id||' and instance number '||p_instance_number);
94: FND_MSG_PUB.Add;
95: RAISE FND_API.G_EXC_ERROR;
96: WHEN OTHERS THEN
97: IF (l_debug_level > 1) THEN
98: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
99: ||SQLERRM);
100: END IF;
101: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
102: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;
105: END;
98: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
99: ||SQLERRM);
100: END IF;
101: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
102: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_ERROR;
105: END;
106: ELSE
117: IF (l_debug_level > 1) THEN
118: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
119: ||'No item found with instance number '||p_instance_number);
120: END IF;
121: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
122: FND_MESSAGE.SET_TOKEN('ERROR','No item found with instance number '
123: ||p_instance_number);
124: FND_MSG_PUB.Add;
125: RAISE FND_API.G_EXC_ERROR;
118: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
119: ||'No item found with instance number '||p_instance_number);
120: END IF;
121: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
122: FND_MESSAGE.SET_TOKEN('ERROR','No item found with instance number '
123: ||p_instance_number);
124: FND_MSG_PUB.Add;
125: RAISE FND_API.G_EXC_ERROR;
126: WHEN OTHERS THEN
127: IF (l_debug_level > 1) THEN
128: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
129: ||SQLERRM);
130: END IF;
131: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
132: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
133: FND_MSG_PUB.Add;
134: RAISE FND_API.G_EXC_ERROR;
135: END;
128: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
129: ||SQLERRM);
130: END IF;
131: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
132: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
133: FND_MSG_PUB.Add;
134: RAISE FND_API.G_EXC_ERROR;
135: END;
136: ELSE
137: IF (l_debug_level > 1) THEN
138: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
139: ||'Must specify at least instance id or instance number');
140: END IF;
141: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
142: FND_MESSAGE.SET_TOKEN('ERROR','Must specify at least instance id or instance number');
143: FND_MSG_PUB.Add;
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
138: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
139: ||'Must specify at least instance id or instance number');
140: END IF;
141: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
142: FND_MESSAGE.SET_TOKEN('ERROR','Must specify at least instance id or instance number');
143: FND_MSG_PUB.Add;
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146: