DBA Data[Home] [Help]

APPS.CSI_GIS_INSTANCE_LOC_PUB dependencies on FND_MESSAGE

Line 99: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');

95:
96: IF p_csi_instance_geoloc_tbl(i).instance_id IS NULL
97: OR p_csi_instance_geoloc_tbl(i).instance_id = FND_API.G_MISS_NUM THEN
98: IF p_asset_context = 'EAM' THEN
99: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');
100: ELSE
101: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_NULL');
102: END IF;
103: FND_MSG_PUB.ADD;

Line 101: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_NULL');

97: OR p_csi_instance_geoloc_tbl(i).instance_id = FND_API.G_MISS_NUM THEN
98: IF p_asset_context = 'EAM' THEN
99: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');
100: ELSE
101: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_NULL');
102: END IF;
103: FND_MSG_PUB.ADD;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: l_error_count:=l_error_count+1;

Line 163: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_ASSET');

159: END IF;
160:
161: IF (l_instance_tbl.EXISTS(p_csi_instance_geoloc_tbl(i).instance_id)) THEN
162: IF p_asset_context = 'EAM' THEN
163: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_ASSET');
164: ELSE
165: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_INSTANCE');
166: END IF;
167: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);

Line 165: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_INSTANCE');

161: IF (l_instance_tbl.EXISTS(p_csi_instance_geoloc_tbl(i).instance_id)) THEN
162: IF p_asset_context = 'EAM' THEN
163: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_ASSET');
164: ELSE
165: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_INSTANCE');
166: END IF;
167: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
168: FND_MSG_PUB.ADD;
169: x_return_status := FND_API.G_RET_STS_ERROR;

Line 167: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);

163: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_ASSET');
164: ELSE
165: FND_MESSAGE.SET_NAME('CSI','CSI_GIS_DUPLICATE_INSTANCE');
166: END IF;
167: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
168: FND_MSG_PUB.ADD;
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: l_error_count:=l_error_count+1;
171: RAISE FND_API.G_EXC_ERROR;

Line 571: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_GIS_DUP_INST_ASSET'),

567: l_error_count := l_error_count + 1;
568: l_record_status:='E';
569: UPDATE csi_ii_geoloc_interface
570: SET process_flag = 'E',
571: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_GIS_DUP_INST_ASSET'),
572: process_date=sysdate
573: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number
574: AND PROCESS_FLAG = 'R';
575: RAISE FND_API.G_EXC_ERROR;

Line 590: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_INSTANCE_NOT_FOUND'),

586: l_error_count := l_error_count + 1;
587: l_record_status:='E';
588: UPDATE csi_ii_geoloc_interface
589: SET process_flag = 'E',
590: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_INSTANCE_NOT_FOUND'),
591: process_date=sysdate
592: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number
593: AND PROCESS_FLAG = 'R';
594: RAISE FND_API.G_EXC_ERROR;

Line 612: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_INVALID_GEOCODE_FORMAT'),

608: l_error_count := l_error_count + 1;
609: l_record_status:='E';
610: UPDATE csi_ii_geoloc_interface
611: SET process_flag = 'E',
612: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_INVALID_GEOCODE_FORMAT'),
613: process_date=sysdate
614: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number
615: AND PROCESS_FLAG = 'R';
616: RAISE FND_API.G_EXC_ERROR;