1099:
1100: IF c_info_type_id%NOTFOUND
1101: THEN
1102: CLOSE c_info_type_id;
1103: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1104: FND_MESSAGE.RAISE_ERROR;
1105: ELSE
1106: CLOSE c_info_type_id;
1107: END IF;
1100: IF c_info_type_id%NOTFOUND
1101: THEN
1102: CLOSE c_info_type_id;
1103: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1104: FND_MESSAGE.RAISE_ERROR;
1105: ELSE
1106: CLOSE c_info_type_id;
1107: END IF;
1108:
1145: -- There isn't a corresponding info type id
1146: -- Show an error!
1147: --
1148: CLOSE c_info_type_id;
1149: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
1150: FND_MESSAGE.RAISE_ERROR;
1151:
1152: ELSE
1153:
1146: -- Show an error!
1147: --
1148: CLOSE c_info_type_id;
1149: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
1150: FND_MESSAGE.RAISE_ERROR;
1151:
1152: ELSE
1153:
1154: CLOSE c_info_type_id;
1193: -- There isn't a corresponding info type id
1194: -- Show an error!
1195: --
1196: CLOSE c_info_type;
1197: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
1198: FND_MESSAGE.RAISE_ERROR;
1199:
1200: ELSE
1201:
1194: -- Show an error!
1195: --
1196: CLOSE c_info_type;
1197: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
1198: FND_MESSAGE.RAISE_ERROR;
1199:
1200: ELSE
1201:
1202: CLOSE c_info_type;
1287: -- We don't know where to put the data
1288: -- Show an error
1289: --
1290: CLOSE csr_segment;
1291: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1292: FND_MESSAGE.RAISE_ERROR;
1293: ELSE
1294: --
1295: -- We need to update the appropriate segment in the correct time
1288: -- Show an error
1289: --
1290: CLOSE csr_segment;
1291: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1292: FND_MESSAGE.RAISE_ERROR;
1293: ELSE
1294: --
1295: -- We need to update the appropriate segment in the correct time
1296: -- attribute record.
2931:
2932: IF c_otm_retrieval_process%NOTFOUND
2933: THEN
2934: CLOSE c_otm_retrieval_process;
2935: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
2936: FND_MESSAGE.RAISE_ERROR;
2937: ELSE
2938: CLOSE c_otm_retrieval_process;
2939: END IF;
2932: IF c_otm_retrieval_process%NOTFOUND
2933: THEN
2934: CLOSE c_otm_retrieval_process;
2935: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
2936: FND_MESSAGE.RAISE_ERROR;
2937: ELSE
2938: CLOSE c_otm_retrieval_process;
2939: END IF;
2940:
2999: IF c_retrieval_process%NOTFOUND
3000: THEN
3001: CLOSE c_retrieval_process;
3002:
3003: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
3004: FND_MESSAGE.RAISE_ERROR;
3005: ELSE
3006: CLOSE c_retrieval_process;
3007: END IF;
3000: THEN
3001: CLOSE c_retrieval_process;
3002:
3003: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
3004: FND_MESSAGE.RAISE_ERROR;
3005: ELSE
3006: CLOSE c_retrieval_process;
3007: END IF;
3008:
5285:
5286: IF c_otm_retrieval_process%NOTFOUND
5287: THEN
5288: CLOSE c_otm_retrieval_process;
5289: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
5290: FND_MESSAGE.RAISE_ERROR;
5291: ELSE
5292: CLOSE c_otm_retrieval_process;
5293: END IF;
5286: IF c_otm_retrieval_process%NOTFOUND
5287: THEN
5288: CLOSE c_otm_retrieval_process;
5289: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
5290: FND_MESSAGE.RAISE_ERROR;
5291: ELSE
5292: CLOSE c_otm_retrieval_process;
5293: END IF;
5294:
5339: IF c_retrieval_process%NOTFOUND
5340: THEN
5341: CLOSE c_retrieval_process;
5342:
5343: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
5344: FND_MESSAGE.RAISE_ERROR;
5345: ELSE
5346: CLOSE c_retrieval_process;
5347: END IF;
5340: THEN
5341: CLOSE c_retrieval_process;
5342:
5343: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
5344: FND_MESSAGE.RAISE_ERROR;
5345: ELSE
5346: CLOSE c_retrieval_process;
5347: END IF;
5348: