1397:
1398: IF c_info_type_id%NOTFOUND
1399: THEN
1400: CLOSE c_info_type_id;
1401: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1402: FND_MESSAGE.RAISE_ERROR;
1403: ELSE
1404: CLOSE c_info_type_id;
1405: END IF;
1398: IF c_info_type_id%NOTFOUND
1399: THEN
1400: CLOSE c_info_type_id;
1401: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1402: FND_MESSAGE.RAISE_ERROR;
1403: ELSE
1404: CLOSE c_info_type_id;
1405: END IF;
1406:
1443: -- There isn't a corresponding info type id
1444: -- Show an error!
1445: --
1446: CLOSE c_info_type_id;
1447: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
1448: FND_MESSAGE.RAISE_ERROR;
1449:
1450: ELSE
1451:
1444: -- Show an error!
1445: --
1446: CLOSE c_info_type_id;
1447: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
1448: FND_MESSAGE.RAISE_ERROR;
1449:
1450: ELSE
1451:
1452: CLOSE c_info_type_id;
1491: -- There isn't a corresponding info type id
1492: -- Show an error!
1493: --
1494: CLOSE c_info_type;
1495: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
1496: FND_MESSAGE.RAISE_ERROR;
1497:
1498: ELSE
1499:
1492: -- Show an error!
1493: --
1494: CLOSE c_info_type;
1495: FND_MESSAGE.SET_NAME('HXC','HXC_NO_BLD_BLK_INFO_TYPE');
1496: FND_MESSAGE.RAISE_ERROR;
1497:
1498: ELSE
1499:
1500: CLOSE c_info_type;
1585: -- We don't know where to put the data
1586: -- Show an error
1587: --
1588: CLOSE csr_segment;
1589: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1590: FND_MESSAGE.RAISE_ERROR;
1591: ELSE
1592: --
1593: -- We need to update the appropriate segment in the correct time
1586: -- Show an error
1587: --
1588: CLOSE csr_segment;
1589: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1590: FND_MESSAGE.RAISE_ERROR;
1591: ELSE
1592: --
1593: -- We need to update the appropriate segment in the correct time
1594: -- attribute record.
3231:
3232: IF c_otm_retrieval_process%NOTFOUND
3233: THEN
3234: CLOSE c_otm_retrieval_process;
3235: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
3236: FND_MESSAGE.RAISE_ERROR;
3237: ELSE
3238: CLOSE c_otm_retrieval_process;
3239: END IF;
3232: IF c_otm_retrieval_process%NOTFOUND
3233: THEN
3234: CLOSE c_otm_retrieval_process;
3235: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
3236: FND_MESSAGE.RAISE_ERROR;
3237: ELSE
3238: CLOSE c_otm_retrieval_process;
3239: END IF;
3240:
3299: IF c_retrieval_process%NOTFOUND
3300: THEN
3301: CLOSE c_retrieval_process;
3302:
3303: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
3304: FND_MESSAGE.RAISE_ERROR;
3305: ELSE
3306: CLOSE c_retrieval_process;
3307: END IF;
3300: THEN
3301: CLOSE c_retrieval_process;
3302:
3303: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
3304: FND_MESSAGE.RAISE_ERROR;
3305: ELSE
3306: CLOSE c_retrieval_process;
3307: END IF;
3308:
5704:
5705: IF c_otm_retrieval_process%NOTFOUND
5706: THEN
5707: CLOSE c_otm_retrieval_process;
5708: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
5709: FND_MESSAGE.RAISE_ERROR;
5710: ELSE
5711: CLOSE c_otm_retrieval_process;
5712: END IF;
5705: IF c_otm_retrieval_process%NOTFOUND
5706: THEN
5707: CLOSE c_otm_retrieval_process;
5708: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
5709: FND_MESSAGE.RAISE_ERROR;
5710: ELSE
5711: CLOSE c_otm_retrieval_process;
5712: END IF;
5713:
5758: IF c_retrieval_process%NOTFOUND
5759: THEN
5760: CLOSE c_retrieval_process;
5761:
5762: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
5763: FND_MESSAGE.RAISE_ERROR;
5764: ELSE
5765: CLOSE c_retrieval_process;
5766: END IF;
5759: THEN
5760: CLOSE c_retrieval_process;
5761:
5762: FND_MESSAGE.SET_NAME('HXC','HXC_NO_RETRIEVAL_PROCESS');
5763: FND_MESSAGE.RAISE_ERROR;
5764: ELSE
5765: CLOSE c_retrieval_process;
5766: END IF;
5767: